@@ -396,8 +396,8 @@ sub test_io_error
396396{
397397my $invalid_page_re =
398398$tblname eq ' tbl_corr'
399- ?qr / invalid page in block 1 of relation base\/\d +\/\d +/
400- :qr / invalid page in block 1 of relation base\/\d +\/ t\d +_\d +/ ;
399+ ?qr / invalid page in block 1 of relation" base\/\d +\/\d +/
400+ :qr / invalid page in block 1 of relation" base\/\d +\/ t\d +_\d +/ ;
401401
402402# verify the error is reported in custom C code
403403psql_like(
@@ -798,7 +798,7 @@ sub test_inject
798798" shortened multi-block read detects invalid page" ,
799799qq( SELECT count(*) FROM tbl_corr WHERE ctid < '(2, 1)') ,
800800qr / ^$ / ,
801- qr / ERROR:.*invalid page in block 1 of relation base\/ .*/ );
801+ qr / ERROR:.*invalid page in block 1 of relation" base\/ .*/ );
802802
803803# trigger a hard error, should error out
804804$psql -> query_safe(
@@ -985,7 +985,7 @@ sub test_zero
985985qq(
986986SELECT read_rel_block_ll('tbl_zero', 0, zero_on_error=>false)) ,
987987qr / ^$ / ,
988- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 0 of relation base\/ .*\/ .*$ /
988+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 0 of relation" base\/ .*\/ .*$ /
989989);
990990
991991# Check that page validity errors are zeroed
@@ -996,7 +996,7 @@ sub test_zero
996996qq(
997997SELECT read_rel_block_ll('tbl_zero', 0, zero_on_error=>true)) ,
998998qr / ^$ / ,
999- qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 0 of relation base\/ .*\/ .*; zeroing out page$ /
999+ qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 0 of relation" base\/ .*\/ .*" ; zeroing out page$ /
10001000);
10011001
10021002# And that once the corruption is fixed, we can read again
@@ -1027,7 +1027,7 @@ sub test_zero
10271027" $persistency : test zeroing of invalid block 3" ,
10281028qq( SELECT read_rel_block_ll('tbl_zero', 3, zero_on_error=>true);) ,
10291029qr / ^$ / ,
1030- qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 3 of relation base\/ .*\/ .*; zeroing out page$ /
1030+ qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 3 of relation" base\/ .*\/ .*" ; zeroing out page$ /
10311031);
10321032
10331033
@@ -1044,7 +1044,7 @@ sub test_zero
10441044" $persistency : test reading of invalid block 2,3 in larger read" ,
10451045qq( SELECT read_rel_block_ll('tbl_zero', 1, nblocks=>4, zero_on_error=>false)) ,
10461046qr / ^$ / ,
1047- qr / ^psql:<stdin>:\d +: ERROR: 2 invalid pages among blocks 1..4 of relation base\/ .*\/ .*\n DETAIL: Block 2 held first invalid page\.\n HINT:[^\n ]+$ /
1047+ qr / ^psql:<stdin>:\d +: ERROR: 2 invalid pages among blocks 1..4 of relation" base\/ .*\/ .*\n DETAIL: Block 2 held the first invalid page\.\n HINT:[^\n ]+$ /
10481048);
10491049
10501050# Then test zeroing via ZERO_ON_ERROR flag
@@ -1054,7 +1054,7 @@ sub test_zero
10541054" $persistency : test zeroing of invalid block 2,3 in larger read, ZERO_ON_ERROR" ,
10551055qq( SELECT read_rel_block_ll('tbl_zero', 1, nblocks=>4, zero_on_error=>true)) ,
10561056qr / ^$ / ,
1057- qr / ^psql:<stdin>:\d +: WARNING: zeroing out 2 invalid pages among blocks 1..4 of relation base\/ .*\/ .*\n DETAIL: Block 2 held first zeroed page\.\n HINT:[^\n ]+$ /
1057+ qr / ^psql:<stdin>:\d +: WARNING: zeroing out 2 invalid pages among blocks 1..4 of relation" base\/ .*\/ .*\n DETAIL: Block 2 held the first zeroed page\.\n HINT:[^\n ]+$ /
10581058);
10591059
10601060# Then test zeroing via zero_damaged_pages
@@ -1069,7 +1069,7 @@ sub test_zero
10691069COMMIT;
10701070) ,
10711071qr / ^$ / ,
1072- qr / ^psql:<stdin>:\d +: WARNING: zeroing out 2 invalid pages among blocks 1..4 of relation base\/ .*\/ .*\n DETAIL: Block 2 held first zeroed page\.\n HINT:[^\n ]+$ /
1072+ qr / ^psql:<stdin>:\d +: WARNING: zeroing out 2 invalid pages among blocks 1..4 of relation" base\/ .*\/ .*\n DETAIL: Block 2 held the first zeroed page\.\n HINT:[^\n ]+$ /
10731073);
10741074
10751075$psql_a -> query_safe(qq( COMMIT) );
@@ -1091,7 +1091,7 @@ sub test_zero
10911091qq(
10921092SELECT count(*) FROM tbl_zero) ,
10931093qr / ^$ / ,
1094- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 2 of relation base\/ .*\/ .*$ /
1094+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 2 of relation" base\/ .*\/ .*$ /
10951095);
10961096
10971097# Verify that bufmgr.c IO zeroes out pages with page validity errors
@@ -1106,7 +1106,7 @@ sub test_zero
11061106COMMIT;
11071107) ,
11081108qr / ^\d +$ / ,
1109- qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 2 of relation base\/ .*\/ .*$ /
1109+ qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 2 of relation" base\/ .*\/ .*$ /
11101110);
11111111
11121112# Check that warnings/errors about page validity in an IO started by
@@ -1192,7 +1192,7 @@ sub test_checksum
11921192qq(
11931193SELECT read_rel_block_ll('tbl_normal', 3, nblocks=>1, zero_on_error=>false);) ,
11941194qr / ^$ / ,
1195- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 3 of relation base\/\d +\/\d +$ /
1195+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 3 of relation" base\/\d +\/\d +" $ /
11961196);
11971197
11981198my ($cs_count_after ,$cs_ts_after ) =
@@ -1214,7 +1214,7 @@ sub test_checksum
12141214qq(
12151215SELECT read_rel_block_ll('tbl_temp', 4, nblocks=>2, zero_on_error=>false);) ,
12161216qr / ^$ / ,
1217- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 4 of relation base\/\d +\/ t\d +_\d +$ /
1217+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 4 of relation" base\/\d +\/ t\d +_\d +" $ /
12181218);
12191219
12201220($cs_count_after ,$cs_ts_after ) = checksum_failures($psql_a ,' postgres' );
@@ -1235,7 +1235,7 @@ sub test_checksum
12351235qq(
12361236SELECT read_rel_block_ll('pg_shseclabel', 2, nblocks=>2, zero_on_error=>false);) ,
12371237qr / ^$ / ,
1238- qr / ^psql:<stdin>:\d +: ERROR: 2 invalid pages among blocks 2..3 of relation global\/\d +\n DETAIL: Block 2 held first invalid page\.\n HINT:[^\n ]+$ /
1238+ qr / ^psql:<stdin>:\d +: ERROR: 2 invalid pages among blocks 2..3 of relation" global\/\d +" \n DETAIL: Block 2 held the first invalid page\.\n HINT:[^\n ]+$ /
12391239);
12401240
12411241($cs_count_after ,$cs_ts_after ) = checksum_failures($psql_a );
@@ -1300,7 +1300,7 @@ sub test_checksum_createdb
13001300" create database w/ wal strategy, invalid source" ,
13011301$createdb_sql ,
13021302qr / ^$ / ,
1303- qr / psql:<stdin>:\d +: ERROR: invalid page in block 1 of relation base\/\d +\/\d +$ /
1303+ qr / psql:<stdin>:\d +: ERROR: invalid page in block 1 of relation" base\/\d +\/\d +" $ /
13041304);
13051305my ($cs_count_after ,$cs_ts_after ) =
13061306 checksum_failures($psql ,' regression_createdb_source' );
@@ -1409,7 +1409,7 @@ sub test_ignore_checksum
14091409qq(
14101410SELECT read_rel_block_ll('tbl_cs_fail', 2, nblocks=>3, zero_on_error=>false);) ,
14111411qr / ^$ / ,
1412- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 4 of relation base\/\d +\/\d +$ /
1412+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 4 of relation" base\/\d +\/\d +" $ /
14131413);
14141414
14151415# Test multi-block read with different problems in different blocks
@@ -1431,7 +1431,7 @@ sub test_ignore_checksum
14311431qq(
14321432SELECT read_rel_block_ll('tbl_cs_fail', 1, nblocks=>5, zero_on_error=>true);) ,
14331433qr / ^$ / ,
1434- qr / ^psql:<stdin>:\d +: WARNING: zeroing 3 page\( s\) and ignoring 2 checksum failure\( s\) among blocks 1..5 of relation/
1434+ qr / ^psql:<stdin>:\d +: WARNING: zeroing 3 page\( s\) and ignoring 2 checksum failure\( s\) among blocks 1..5 of relation " /
14351435);
14361436
14371437
@@ -1444,17 +1444,17 @@ sub test_ignore_checksum
14441444ok(1," $io_method : found information about checksum failure in block 2" );
14451445
14461446$node -> wait_for_log(
1447- qr / LOG: invalid page in block 3 of relation base.*; zeroing out page/ ,
1447+ qr / LOG: invalid page in block 3 of relation" base.*" ; zeroing out page/ ,
14481448$log_location );
14491449ok(1," $io_method : found information about invalid page in block 3" );
14501450
14511451$node -> wait_for_log(
1452- qr / LOG: invalid page in block 4 of relation base.*; zeroing out page/ ,
1452+ qr / LOG: invalid page in block 4 of relation" base.*" ; zeroing out page/ ,
14531453$log_location );
14541454ok(1," $io_method : found information about checksum failure in block 4" );
14551455
14561456$node -> wait_for_log(
1457- qr / LOG: invalid page in block 5 of relation base.*; zeroing out page/ ,
1457+ qr / LOG: invalid page in block 5 of relation" base.*" ; zeroing out page/ ,
14581458$log_location );
14591459ok(1," $io_method : found information about checksum failure in block 5" );
14601460
@@ -1473,7 +1473,7 @@ sub test_ignore_checksum
14731473qq(
14741474SELECT read_rel_block_ll('tbl_cs_fail', 3, nblocks=>1, zero_on_error=>false);) ,
14751475qr / ^$ / ,
1476- qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 3 of relation/ );
1476+ qr / ^psql:<stdin>:\d +: ERROR: invalid page in block 3 of relation " / );
14771477
14781478psql_like(
14791479$io_method ,
@@ -1482,7 +1482,7 @@ sub test_ignore_checksum
14821482qq(
14831483SELECT read_rel_block_ll('tbl_cs_fail', 3, nblocks=>1, zero_on_error=>true);) ,
14841484qr / ^$ / ,
1485- qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 3 of relation base\/ .*; zeroing out page/
1485+ qr / ^psql:<stdin>:\d +: WARNING: invalid page in block 3 of relation" base\/ .*" ; zeroing out page/
14861486);
14871487
14881488