Re: LOG: unexpected EOF on client connection - Mailing list pgsql-sql

From Bernd Nawothnig
Subject Re: LOG: unexpected EOF on client connection
Date
Msg-id j90pk6xlah.ln2@bernd.nawothnig.dialin.t-online.de
Whole thread Raw
In response to LOG: unexpected EOF on client connection  (<ezequias@fastcon.com.br>)
Responses Re: LOG: unexpected EOF on client connection  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Venkateswara Rao Bondada
Date:
Subject: Re: Create table command fails with permission denied
Next
From: Tom Lane
Date:
Subject: Re: LOG: unexpected EOF on client connection