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

From Tom Lane
Subject Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date
Msg-id 15465.1186086489@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3504: Some listening sessions never return from writing, problems ensue  ("Peter Koczan" <pjkoczan@gmail.com>)
Responses Re: BUG #3504: Some listening sessions never return from writing, problems ensue
List pgsql-bugs
"Peter Koczan" <pjkoczan@gmail.com> writes:
> A quick perusal of the other "notify interrupt" connections shows 13032 in
> the Send-Q column. They all got into this state at the same time.

That's far too much data to be a notify message, or even a small number
of notify messages.  Is it possible that the client's failed to collect
hundreds of notify events?

But in any case this clearly lets the backend off the hook.  The problem
is on the client side: it's not reading the data.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Next
From: "alan"
Date:
Subject: BUG #3507: pgxml.dll not work in V8.2.4