Re: test_autovacuum/001_parallel_autovacuum is broken
Sami Imseih <samimseih@gmail.com>
From: Sami Imseih <samimseih@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Alexander Lakhin <exclusion@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>, Daniil Davydov <3danissimo@gmail.com>
Date: 2026-04-09T20:14:15Z
Lists: pgsql-hackers
Attachments
- v2-0001-Fix-unstable-log_contains-in-parallel-autovacuum-.patch (application/octet-stream) patch v2-0001
> Optionally, we can change the comment above to something like this: > # Wait until the parallel autovacuum on the table completes and reports the > # number of launched workers, which must correspond to the value specified in > # the reloption. Made the comment less verbose but in the same spirit as the above. > > > One way to fix the test is to replace log_contains() with > > > wait_for_log(). We can also remove wait_for_autovacuum_complete() > > > logic altogether. > > > > +1. I was going to reply with exactly this. Attached is the fix. > > Thank you for the patch! I agree with the overall idea. Since we > enable autovacuum log only the test_autovac table, just checking > autovacuum log works as expected. > > I think we can simplify the test further by removing the logic around > the av_count variable. removed av_count and pg_stat_user_tables query, but hardened the regexp a bit to ensure that the parallel logging is for the test_autovac table. It gives the same assurance as counting pg_stat_user_tables and will be better if we add another parallel test table in the future. -- Sami
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix unstable log verification in test_autovacuum.
- c22d115f1d13 19 (unreleased) landed
-
Remove an unstable wait from parallel autovacuum regression test.
- 8030b839d3d2 19 (unreleased) landed