Re: recoveryCheck/008_fsm_truncation is failing on dodo in v14- (due to slow fsync?)

Поиск
Список
Период
Сортировка
От Alexander Lakhin
Тема Re: recoveryCheck/008_fsm_truncation is failing on dodo in v14- (due to slow fsync?)
Дата
Msg-id f6654e9d-6799-7f31-186d-201f51874e3a@gmail.com
обсуждение исходный текст
Ответ на Re: recoveryCheck/008_fsm_truncation is failing on dodo in v14- (due to slow fsync?)  (Robins Tharakan <tharakan@gmail.com>)
Список pgsql-hackers
Hello Robins,

28.06.2024 13:20, Robins Tharakan wrote:
The past ~1 week, I tried to space out all other tasks on the machine, so as to ensure
that 1-min CPU is mostly <2 (and thus not many things hammering the disk) and with
that I see 0 failures these past few days. This isn't conclusive by any means, but it
does seem that reducing IO contention has helped remove the errors, like what 
Alexander suspects / repros here.

Just a note, that I've reverted some of those recent changes now, and so if the theory
holds true, I wouldn't be surprised if some of these errors restarted on dodo.

Looking back at the test failures, I can see errors really reappeared
just after your revert (at 2024-06-28), so that theory proved true,
but I see none of those since 2024-07-02. Does it mean that you changed
something on dodo/fixed that performance issue?

Could you please describe how you resolved this issue, just for the record?

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-06-28%2017%3A00%3A28
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-06-28%2017%3A10%3A12
[3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-07-01%2012%3A10%3A12
[4] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-07-01%2013%3A01%3A00
[5] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-07-02%2005%3A00%3A36
[6] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dodo&dt=2024-07-02%2018%3A00%3A15

Best regards,
Alexander

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Detailed release notes
Следующее
От: Robert Haas
Дата:
Сообщение: Re: tls 1.3: sending multiple tickets