diff options
| author | Noah Misch | 2020-12-13 05:38:36 +0000 |
|---|---|---|
| committer | Noah Misch | 2020-12-13 05:38:36 +0000 |
| commit | a1b8aa1e4eec520ed8f11c3d134a7a866358d39a (patch) | |
| tree | 2d05cfb5af9db583201f10466bdb786ff525e561 /src/test/subscription | |
| parent | 73aae4522b35125c4f9a506842a69336ec5d0f1b (diff) | |
Use HASH_BLOBS for xidhash.
This caused BufFile errors on buildfarm member sungazer, and SIGSEGV was
possible. Conditions for reaching those symptoms were more frequent on
big-endian systems.
Discussion: https://postgr.es/m/20201129214441.GA691200@rfd.leadboat.com
Diffstat (limited to 'src/test/subscription')
| -rw-r--r-- | src/test/subscription/t/015_stream.pl | 26 |
1 files changed, 24 insertions, 2 deletions
diff --git a/src/test/subscription/t/015_stream.pl b/src/test/subscription/t/015_stream.pl index fffe0019650..1b0e6fb9fb6 100644 --- a/src/test/subscription/t/015_stream.pl +++ b/src/test/subscription/t/015_stream.pl @@ -46,15 +46,37 @@ my $result = $node_subscriber->safe_psql('postgres', "SELECT count(*), count(c), count(d = 999) FROM test_tab"); is($result, qq(2|2|2), 'check initial data was copied to subscriber'); -# Insert, update and delete enough rows to exceed the 64kB limit. -$node_publisher->safe_psql('postgres', q{ +# Interleave a pair of transactions, each exceeding the 64kB limit. +my $in = ''; +my $out = ''; + +my $timer = IPC::Run::timeout(180); + +my $h = $node_publisher->background_psql('postgres', \$in, \$out, $timer, + on_error_stop => 0); + +$in .= q{ BEGIN; INSERT INTO test_tab SELECT i, md5(i::text) FROM generate_series(3, 5000) s(i); UPDATE test_tab SET b = md5(b) WHERE mod(a,2) = 0; DELETE FROM test_tab WHERE mod(a,3) = 0; +}; +$h->pump_nb; + +$node_publisher->safe_psql( + 'postgres', q{ +BEGIN; +INSERT INTO test_tab SELECT i, md5(i::text) FROM generate_series(5001, 9999) s(i); +DELETE FROM test_tab WHERE a > 5000; COMMIT; }); +$in .= q{ +COMMIT; +\q +}; +$h->finish; # errors make the next test fail, so ignore them here + $node_publisher->wait_for_catchup($appname); $result = |