Re: Auto-vacuum timing out and preventing connections
| От | Jeff Janes |
|---|---|
| Тема | Re: Auto-vacuum timing out and preventing connections |
| Дата | |
| Msg-id | CAMkU=1xMBJZk9NoDNtwCjF7YULiCWyvX8FAr=mz+vgnZRZiFhQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Auto-vacuum timing out and preventing connections (David Johansen <davejohansen@gmail.com>) |
| Ответы |
Re: Auto-vacuum timing out and preventing connections
|
| Список | pgsql-bugs |
On Mon, Jun 27, 2022 at 4:38 PM David Johansen <davejohansen@gmail.com> wrote:
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; canceledThe log appears about every 5 minutes and eventually nothing can connect to it and it has to be rebooted.
As Julien suggested, this sounds like another victim, not the cause. Is there anything else in the log files?
What version are you using?
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
But, I don't see high CPU described as a symptom in either of those threads.
If you can't reproduce the problem locally, there probably isn't much we can do. Maybe ask Amazon to look into it, since they are the only ones with sufficient access to do so.
Cheers,
Jeff
В списке pgsql-bugs по дате отправления: