Hello Andres, 02.04.2025 14:58, Andres Freund wrote:
Hi,I've pushed fixes for 1) and 2) and am working on 3).
When running multiple installcheck's against a single server (please find the ready-to-use script attached (I use more sophisticated version with additional patches to make installcheck pass cleanly, but that's not required for this case)), I've encountered an interesting error related to AIO/uring: iteration 8: Sun Apr 6 19:22:39 UTC 2025 installchecks finished: Sun Apr 6 19:23:47 UTC 2025 2025-04-06 19:22:44.216 UTC [349525] LOG: could not read blocks 0..0 in file "base/6179194/2606": Operation canceled 2025-04-06 19:22:44.216 UTC [349525] ERROR: could not read blocks 0..0 in file "base/6179194/2606": Operation canceled server.log contains: 2025-04-06 19:22:44.215 UTC [38231] LOG: checkpoint complete: wrote ... 2025-04-06 19:22:44.216 UTC [38231] LOG: checkpoint starting: immediate force wait flush-all 2025-04-06 19:22:44.216 UTC [349525] LOG: could not read blocks 0..0 in file "base/6179194/2606": Operation canceled2025-04-06 19:22:44.216 UTC [349525] STATEMENT: alter table parted_copytest attach partition parted_copytest_a1 for values in(1);
2025-04-06 19:22:44.216 UTC [349525] ERROR: could not read blocks 0..0 in file "base/6179194/2606": Operation canceled2025-04-06 19:22:44.216 UTC [349525] STATEMENT: alter table parted_copytest attach partition parted_copytest_a1 for values in(1);
It's reproduced better on tmpfs for me; probably you would need to increase NUM_INSTALLCHECKS/NUM_ITERATIONS for your machine. I can reduce the testing procedure to something trivial, if it makes sense for you. Probably, the same effect can be also achieved with just pgbench... Best regards, Alexander Lakhin Neon (https://neon.tech)
test-icx+.tar.gz
Description: application/gzip
