Re: BUG #3504: Some listening sessions never return from writing, problems ensue - Mailing list pgsql-bugs

From Peter Koczan
Subject Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date
Msg-id 4544e0330708170919ie3ac511q485eba1e1df95869@mail.gmail.com
Whole thread Raw
In response to Re: BUG #3504: Some listening sessions never return from writing, problems ensue  (tomas@tuxteam.de)
List pgsql-bugs
> Hm. To me it looks like the first psql session isn't prepared to gather
> async notifies (checking...) indeed, psql only checks for async notifies when
> issuing commands (you don't have to issue a NOTIFY in "Connection 1" to
> receive the pending notifies -- *any* request directed to the server would do).
>
> If you see the queue building up as above, the problem lies almost
> certainly on the client not gathering the notifies. The backend is
> obviously willing to talk to you :-)
>
> I'd look for the problem in the client library (It's DBD::Pg in your
> "real" case, isn't it?)

*Light bulb lights up* Ah....I see what's going on now.

I think I have enough information to test and fix the problem on our
end. Thank you all for your help and patience. This can be considered
resolved.

Peter

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Next
From: Kris Jurka
Date:
Subject: Re: BUG #3544: SQLException from JDBC driver