Auto-vacuum timing out and preventing connections

Поиск
Список
Период
Сортировка
От David Johansen
Тема Auto-vacuum timing out and preventing connections
Дата
Msg-id CAAcYxUczOL2iAyL7_+Wj7KBUko2gD_gArPg0_EcmnOge-ACXmQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Auto-vacuum timing out and preventing connections  (Julien Rouhaud <rjuju123@gmail.com>)
Re: Auto-vacuum timing out and preventing connections  (Jeff Janes <jeff.janes@gmail.com>)
Re: Auto-vacuum timing out and preventing connections  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end