From: Bernd Nawothnig <Bernd.Nawothnig@t-online.de>
Subject: Re: LOG:  unexpected EOF on client connection
Date: Wed, 05 Aug 2009 20:40:19 +0200
Organization: CUTEC Institut GmbH
Lines: 34
Message-ID: <j90pk6xlah.ln2@bernd.nawothnig.dialin.t-online.de>
Reply-To: Bernd.Nawothnig@web.de
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
User-Agent: slrn/pre1.0.0-11 (Linux)
To: pgsql-sql@postgresql.org

Hello,

A client application written in C# + npgsql 2.0.6 causes reproducable
log entries like this:

LOG:  unexpected EOF on client connection
LOG:  could not receive data from client: Die Verbindung wurde vom
Kommunikationspartner zurückgesetzt(*)

(*) Connection reset by peer

The responsable Programmer claims autovacuum caused the malfunction.
But after disabling autovacuum the same error occured. Another
program, written Python + psycopg2, which invokes exactly the same
function resulting the above connection reset in the C# program runs
without any problem while inserting far more than 10 times the amount
of data the C# program should do. Even running 2 parallel instances of
the Python program does not result in any error.


Server is version 8.4 + Postgis 1.4 (both compiled with gcc 4.3), OS
is Debian Lenny running on a Quadcore-Xeon Dell Precision 690 with 2
GB RAM. When the above error occurs the C# program is the only client
connecting to the server.


What may be the most probable cause of that?


Bernd

-- 
No time toulouse