Re: test/isolation/expected/stats_1.out broken for me
От
Andres Freund
Тема
Re: test/isolation/expected/stats_1.out broken for me
Дата
Msg-id
20220407185408.n7dvsgqsb3q6uze7@alap3.anarazel.de
Ответ на
Re: test/isolation/expected/stats_1.out broken for me (Andres Freund)
Список
Дерево обсуждения
test/isolation/expected/stats_1.out broken for me chap@anastigmatix.net
Re: test/isolation/expected/stats_1.out broken for me Tom Lane <tgl@sss.pgh.pa.us>
Re: test/isolation/expected/stats_1.out broken for me chap@anastigmatix.net
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me chap@anastigmatix.net
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Re: test/isolation/expected/stats_1.out broken for me Tom Lane <tgl@sss.pgh.pa.us>
Re: test/isolation/expected/stats_1.out broken for me Andres Freund <andres@anarazel.de>
Hi,
On 2022-04-07 11:02:41 -0700, Andres Freund wrote:
> I've now reproduced this, albeit not reliably yet. Looking.
Caused by me misremembering when deduplication happens - somehow recalled that
deduplication didn't happen when payloads. So the statement that was supposed
to guarantee needing more than one page:
SELECT pg_notify('stats_test_use', repeat('0', current_setting('block_size')::int / 2)) FROM generate_series(1, 3);
didn't actually guarantee that. It just failed to fail by chance.
When regression tests and isolation test run in sequence against the same
freshly started cluster, the offsets when starting out are just right to not
need another page in the first test.
I'll change it to use distinct payloads..
Greetings,
Andres Freund
В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата: