Postgres Pro
Downloads
Home   >   mailing lists

Auto-vacuum timing out and preventing connections - Mailing list pgsql-bugs

From David Johansen
Subject Auto-vacuum timing out and preventing connections
Date
Msg-id CAAcYxUczOL2iAyL7_+Wj7KBUko2gD_gArPg0_EcmnOge-ACXmQ@mail.gmail.com
Whole thread Raw
Responses Re: Auto-vacuum timing out and preventing connections
Re: Auto-vacuum timing out and preventing connections
Re: Auto-vacuum timing out and preventing connections
List pgsql-bugs
Tree view
We're running into an issue where the database can't be connected to. It appears that the auto-vacuum is timing out and then that prevents new connections from happening. This assumption is based on these logs showing up in the logs:
WARNING:  worker took too long to start; canceled
The log appears about every 5 minutes and eventually nothing can connect to it and it has to be rebooted.

These are the most similarly related previous posts, but the CPU usage isn't high when this happens, so I don't believe that's the problem

What can we do to diagnose this problem and get our database working reliably again?

Thanks,
Dave

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.
Next
From: Justin Pryzby
Date:
Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end