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:
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 ensurethat 1-min CPU is mostly <2 (and thus not many things hammering the disk) and withthat I see 0 failures these past few days. This isn't conclusive by any means, but itdoes seem that reducing IO contention has helped remove the errors, like whatAlexander suspects / repros here.Just a note, that I've reverted some of those recent changes now, and so if the theoryholds 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 по дате отправления: