The following bug has been logged online:
Bug reference: 3808
Logged by: Daniel Migowski
Email address: dmigowski@ikoffice.de
PostgreSQL version: 8.1.4
Operating system: Windows Server 2003
Description: Connections stays open in state CLOSE_WAIT
Details:
Hello dear bug report readers,
I am using PostgreSQL 8.1.4 on Windows 2003 Server and do my backups with
the pg_dump in the same package.
From time to time the server side of the connection remains open with
netstat showing the connection in state CLOSE_WAIT. The pg_dump process at
this time has succesfully done its job and is gone long, but the connection
stays open.
I notices this, because, together with the connection, many AccessShare
locks on different tables and one ExclusiveLock remains open.
It is possible to cancel the backend process from PGAdmin, but after
grinding the server to a halt with the most minor update script (it was a
DROP NOT NULL), I really get annoyed about this bug.
Even more problematic is, that the behaviour cannot be reproduced (i tried
for hours), it just occurs occacionally.
I noticed the changelog of version 8.1.10 (Magnus: Windows Socket
Improvements). Will they fix this bug?
Do you need more information to fix this bug?
Thank you very much for taking your time to cover this in advance, and with
best regards,
Daniel Migowski