Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit9959a07

Browse files
committed
Fix instability in 026_overwrite_contrecord.pl test.
We've seen intermittent failures in this test on slower buildfarmmachines, which I think can be explained by assuming that autovacuumemitted some additional WAL. Disable autovacuum to stabilize it.In passing, use stringwise not numeric comparison to compareWAL file names. Doesn't matter at present, but they arehex strings not decimal ...Discussion:https://postgr.es/m/1372189.1636499287@sss.pgh.pa.us
1 parent8a94efd commit9959a07

File tree

1 file changed

+7
-2
lines changed

1 file changed

+7
-2
lines changed

‎src/test/recovery/t/026_overwrite_contrecord.pl

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,12 @@
1919

2020
my$node = PostgresNode->get_new_node('primary');
2121
$node->init(allows_streaming=> 1);
22-
$node->append_conf('postgresql.conf','wal_keep_segments=16');
22+
# We need these settings for stability of WAL behavior.
23+
$node->append_conf(
24+
'postgresql.conf',qq(
25+
autovacuum = off
26+
wal_keep_segments = 16
27+
));
2328
$node->start;
2429

2530
$node->safe_psql('postgres','create table filler (a int, b text)');
@@ -58,7 +63,7 @@ END
5863
#$node->safe_psql('postgres', qq{create table foo ()});
5964
my$endfile =$node->safe_psql('postgres',
6065
'SELECT pg_walfile_name(pg_current_wal_insert_lsn())');
61-
ok($initfile!=$endfile,"$initfile differs from$endfile");
66+
ok($initfilene$endfile,"$initfile differs from$endfile");
6267

6368
# Now stop abruptly, to avoid a stop checkpoint. We can remove the tail file
6469
# afterwards, and on startup the large message should be overwritten with new

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp