Thread: LOG entries: "could not receive data from client" ?
hi list
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 actively refused 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.
as i haven't found any usefull information on this, i hope to get an explanation (and maybe a hint how to get rid of them) here.
this is our setup:
db server: 10.1.1.18 running windows 2003 and pgsql 8
web server: 10.1.1.4 running windows 2003, iis, pgodbc
the pgsql is pretty much in standard configuration except for some increased memory configuration parameters. there are no network outages between the two machines that could provoke an unexpected disconnect...
thanks in advance,
thomas
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