Re: Problem with pg_notify / listen

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Problem with pg_notify / listen
Дата
Msg-id CAKFQuwb9rYE0FkBrg67at70VnX3kT+h7_SWxtRnJ8=Bvw7wDPw@mail.gmail.com
обсуждение исходный текст
Ответ на Problem with pg_notify / listen  (Gustavsson Mikael <mikael.gustavsson@smhi.se>)
Ответы SV: Problem with pg_notify / listen
Список pgsql-general
Дерево обсуждения
On Friday, November 27, 2020, Gustavsson Mikael <mikael.gustavsson@smhi.se> wrote:

Hi.

After applying the latest patch we have encountered a problem with the pg_notify queue. 

The queue is filling up and starts issuing warnings like 
WARNING:  NOTIFY queue is 87% full
DETAIL:  The server process with PID 2969993 is among those with the oldest transactions.
NOTIFY queue cannot be emptied until that process ends its current transaction.

There is no long-running 'active' or 'idle in transaction' transactions on the server.
 

As its easy enough to run can you please confirm this by showing us the pg_stat_activity record for that pid during the time when this warning appears?

Thanks!

David J.

В списке pgsql-general по дате отправления: