Re: Full socket send buffer prevents cancel, timeout - Mailing list pgsql-hackers

From Stephen R. van den Berg
Subject Re: Full socket send buffer prevents cancel, timeout
Date
Msg-id 20081027115937.GA28024@cuci.nl
Whole thread Raw
In response to Re: Full socket send buffer prevents cancel, timeout  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Full socket send buffer prevents cancel, timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Michael Fuhr wrote:
>On Sat, Oct 25, 2008 at 12:36:24PM -0400, Tom Lane wrote:
>> The backend can't take it upon itself to interrupt the send, because
>> that would result in loss of protocol message sync, and without
>> knowing how many bytes got sent there's really no way to recover.
>> The only escape from the backend side would be to abort the session ---
>> and even that's a bit problematic since we'd probably try to issue an
>> error message somewhere on the way out, which isn't going to work
>> either if the send buffer is full.

>Yeah, I've already explained those difficulties.  I was hoping that
>discussion might generate ideas on how to deal with them.

What about simply closing the filedescriptor upon discovering a
non-empty sendbuffer upon timeout/querycancel?
-- 
Sincerely,          Stephen R. van den Berg.

Teamwork is essential -- it allows you to blame someone else.


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Visibility map, partial vacuums
Next
From: Tom Lane
Date:
Subject: Re: new correlation metric