On Fri, Mar 27, 2020 at 05:10:03PM -0500, Justin King wrote: > Sounds great. I will email you directly with a link! Thanks. From the logs, the infinite loop on which autovacuum jobs are stuck is clear. We have a repetitive number of anti-wraparound and non-aggressive jobs happening for 7 shared relations every 5 seconds or so and autovacuum is not able to do something else: pg_auth_members pg_authid pg_database pg_replication_origin pg_shseclabel pg_subscription pg_tablespace However I have found a correlation between all the tests I have done on my own laptop, all the tests Julien and I have done in our internal company buildfarm, and your logs. We have 10 shared catalogs in the system and the problem does not happen with the three following ones, unable to trigger an anti-wraparound non-aggressive job: pg_db_role_setting pg_shdepend pg_shdescription Not sure yet what that is, but it is hard to believe that it is just a coincidence. > This is encouraging. As I mentioned, we have a workaround in place for > the moment, but don't hesitate if you need anything else from me. > Thanks for jumping in on the thread, it was nice validation to know > that I wasn't the only one seeing the issue! Yes. We have been able to confirm that 2aa6e33 is a direct cause of your problem. -- Michael
Attachment:
signature.asc
Description: PGP signature
