pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gustavsson Mikael <mikael.gustavsson@smhi.se>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: Svensson Peter <peter.svensson@smhi.se>
Cc: Almen Anders <anders.almen@smhi.se>
Subject: SV: Problem with pg_notify / listen
Date: Fri, 27 Nov 2020 14:48:28 +0000
Message-ID: <19d46e8276a54d24b09b6bcbd3bc8e17@smhi.se> (raw)
In-Reply-To: <CAKFQuwb9rYE0FkBrg67at70VnX3kT+h7_SWxtRnJ8=Bvw7wDPw@mail.gmail.com>
References: <1b8561412e8a4f038d7a491c8b922788@smhi.se>
	<CAKFQuwb9rYE0FkBrg67at70VnX3kT+h7_SWxtRnJ8=Bvw7wDPw@mail.gmail.com>

Hi David,


Thanks for fast reply!


We had to restart the server to avoid problems with a full queue så process is no longer with us.

The queue is at 25% now and we have minimised the payload to avoid problems during the weekend.
# select * from pg_notification_queue_usage()
;
 pg_notification_queue_usage
-----------------------------
           0.245367050170898
(1 row)

If my calculations is correct we will reach 50% on monday.

kr
/Mikael Gustavsson

________________________________
Från: David G. Johnston <david.g.johnston@gmail.com>
Skickat: den 27 november 2020 15:28
Till: Gustavsson Mikael
Kopia: pgsql-generallists.postgresql.org; Svensson Peter; Almen Anders
Ämne: Re: Problem with pg_notify / listen

On Friday, November 27, 2020, Gustavsson Mikael <mikael.gustavsson@smhi.se<mailto: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.

view thread (13+ messages)  latest in thread

Message-ID: <19d46e8276a54d24b09b6bcbd3bc8e17@smhi.se>
Permalink:  ../19d46e8276a54d24b09b6bcbd3bc8e17@smhi.se/
Also on:    postgresql.org/message-id/19d46e8276a54d24b09b6bcbd3bc8e17@smhi.se

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: mikael.gustavsson@smhi.se, david.g.johnston@gmail.com, pgsql-general@lists.postgresql.org, peter.svensson@smhi.se, anders.almen@smhi.se
  Subject: Re: SV: Problem with pg_notify / listen
  In-Reply-To: <19d46e8276a54d24b09b6bcbd3bc8e17@smhi.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox