Re: recoveryCheck/008_fsm_truncation is failing on dodo in v14- (due to slow fsync?)
Alexander Lakhin <exclusion@gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
To: Robins Tharakan <tharakan@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2024-07-26T14:00:00Z
Lists: 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