Re: Unknown winsock error 10061

"Sofer, Yuval" <Yuval_Sofer@bmc.com> wrote:

> Postgres server crashed on windows vista.

What causes you to say that the server crashed?

> 2010-04-07 07:00:35.694 LOG:  could not receive data from client:
> Unknown winsock error 10061
> 2010-04-07 07:00:35.694 LOG:  could not receive data from client:
> Unknown winsock error 10061
> 2010-04-07 07:00:35.694 LOG:  unexpected EOF on client connection
> 2010-04-07 07:00:35.694 LOG:  unexpected EOF on client connection

This looks like a network disruption or a client machine being
turned off.  Sort of.  The odd thing is the error code of 10061,
which is supposed to be for "connection refused" -- are you using
anything which might be trying to connect out from the PostgreSQL
server (e.g., dblink)?

> 2010-04-07 08:27:53.934 LOG:  received fast shutdown request
> 2010-04-07 08:27:53.934 LOG:  aborting any active transactions

This looks like the server was shut down an hour and half after the
broken client connections.  Did you shut it down at 8:27?

> Why did the postgres server crashed?

What did you see that makes you think it did?

> Is it operating system problem or postgres?

I don't see any indication of a PostgreSQL problem.  By the way,
what version of PostgreSQL is this?

> Is there any work around ?

Without knowing what happened, it's hard to say.  Any idea what
might have happened with the network or client machine(s) at 7:00?

If you review this page and follow the suggestions there, you'll
give us more to work with when trying to help:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin