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 10791.1186064249@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3504: Some listening sessions never return from writing, problems ensue  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: BUG #3504: Some listening sessions never return from writing, problems ensue
List pgsql-bugs
1Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Peter Koczan wrote:
>> There is a problem where connections listening for asynchronous notifies
>> occasionally block for writing on ther server side and never finish,

> Does the client read the async notifies? The write in the server will
> block if the client doesn't keep up with reading the data.

Loss of network connectivity to the client (eg, timeout of a NAT
mapping) seems like another plausible explanation.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Laurent Martelli"
Date:
Subject: BUG #3506: to_number silently ignore characters
Next
From: Peter Koczan
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue