Re: Connections Crashing - Mailing list pgsql-general

From Richard Huxton
Subject Re: Connections Crashing
Date
Msg-id 4A0BB742.5000508@archonet.com
Whole thread Raw
In response to Re: Connections Crashing  ("Shahbaz A. Tyagi" <shahbaz.tyagi@sphere.ae>)
List pgsql-general
Shahbaz A. Tyagi wrote:
> Hi,
>
> Its not happening in all the machines, its only some machines. I am testing
> on XP 32 bit. Its coming only while running Postgres and accessing the DB.
>
> Strange part is that some machines are getting restarted as soon as it gets
> the error.

You mean the whole machine crashes and restarts? That shouldn't even be
possible.

>> From last some time we have started getting error as message dialog
> showing
>> error 0xC0000142 and after that, connections are crashing.
>
>> LOG:  server process (PID 8156) was terminated by exception 0xC0000142

It's probably worth making sure you are logging connections
(log_connections) and are recording the PID in the log-lines
(log_line_prefix).

http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html

Presumably this error is occuring when a new connection is made, but it
would be sensible to make sure.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Shahbaz A. Tyagi"
Date:
Subject: Re: Connections Crashing
Next
From: Greg Smith
Date:
Subject: Re: Space for pg_dump