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 <andres@anarazel.de>)
Ответы Re: test/isolation/expected/stats_1.out broken for me  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
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
Дата:
Сообщение: Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas
Следующее
От: Andres Freund
Дата:
Сообщение: Re: test/isolation/expected/stats_1.out broken for me