On 10/13/21 5:50 PM, Tom Lane wrote:
Jeff Ross <jross@xxxxxxxxxxxxxx> writes:
On 10.15 I'm getting the following on a logically replicated server.
2021-10-13 18:49:39.792 EDT,,,213601,,6143c257.34261,64243,,2021-09-16
18:16:55 EDT,4/3914851,60709901,WARNING,01000,"NOTIFY queue is 66%
full",,,,,,,,,""
In the CSV logs above what part points to "the session that is
preventing cleanup" so that I can kill it?
Normally there's a DETAIL entry citing the session's PID. Looking
at the code, the reason for the lack of any such entry must be that
there is no session whose current notify queue position exactly
matches the supposed global minimum position. This corresponds to
a known bug that was fixed in 10.16, so I'd suggest upgrading.
As a temporary workaround you could restart that server, but
likely the problem would recur after awhile.
regards, tom lane
Thanks as always, Tom. I'll schedule the upgrade to 10.18 and restart
for this weekend.
Jeff
