[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Connections getting stuck sending data to client
From:       "Scott Marlowe" <scott.marlowe () gmail ! com>
Date:       2008-10-31 18:27:27
Message-ID: dcc563d10810311127h239f8018pe6ba745448f638a5 () mail ! gmail ! com
[Download RAW message or body]

On Fri, Oct 31, 2008 at 9:36 AM, Chris Butler <chrisb@zedcore.com> wrote:
> I've been having intermittent problems with our DB server (running
> postgresql 8.3.3) reaching its connection limit, all because of a SELECT
> statement that's stuck while sending data. This gets stuck because there's a
> transaction waiting to do an ALTER TABLE, then the subsequent SELECTs wait
> for the ALTER.
>
> The problem seems to be that the client connection drops while the server is
> sending data to the client.

Are the clients windows?  I know there's a well known and published
bug in windows where it freaks out on blocking ports and the
connection hangs.  There's a kb article on it on the ms site.  It's
been around since windows 95 or so and there appears to be no plans to
fix it.

If it's not that I'm not sure what it would be.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]