Re: LOG entries: "could not receive data from client" ?

On Sat, Aug 27, 2005 at 03:34:30AM +0200, me@alternize.com wrote:
> we're lately migrating our MSSQL server to PGSQL 8. the performance is
> great and i'm more than happy with PG. still, i've found quite a lot of
> the following logfile entries:
>
> 2005-08-26 18:54:26 LOG:  could not receive data from client: No connection could be made because the target machine
activelyrefused it. 
>
> sometimes the error is accompagnied with this one:
>
> 2005-08-26 15:59:23 LOG:  unexpected EOF on client connection
>
> - but most the time not.

The error appears to be ECONNRESET, or whatever the Windows equivalent
is.  Apparently the client abruptly closed the connection instead
of doing it nicely; if you were to run a sniffer on the connection
you'd probably see the client sending RST instead of following the
proper application- and TCP-layer shutdown protocols.  Maybe somebody
else can suggest why that might be happening.

--
Michael Fuhr