Re: Postgres 9.2.8 crash sporadically on Windows - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Postgres 9.2.8 crash sporadically on Windows
Date
Msg-id 5342BEE3.6090400@aklaver.com
Whole thread Raw
In response to Postgres 9.2.8 crash sporadically on Windows  ("Sofer, Yuval" <Yuval_Sofer@bmc.com>)
List pgsql-general
On 04/07/2014 07:48 AM, Sofer, Yuval wrote:
> Hi,
>
> Postgres server (9.2.8) crash on Windows sporadically
>
> Usually it happens after machine reboot that we do, once in a day
>
> After ~4 minutes it crashes with this error in the log:
>
> 2014-04-06 08:08:01.069 GMTLOG:  server process (PID 5304) exited with
> exit code 0
>
> 2014-04-06 08:08:01.069 GMTLOG:  terminating any other active server
> processes
>
> 2014-04-06 08:08:01.833 GMTLOG:  all server processes terminated;
> reinitializing
>
> 2014-04-06 08:08:11.183 GMTFATAL:  pre-existing shared memory block is
> still in use
>
> 2014-04-06 08:08:11.183 GMTHINT:  Check if there are any old server
> processes still running, and terminate them.
>
> This is production, Please help!

Some more information is going to be needed.

1) What do the system/Postgres logs show when the system is shut down?

2) Have you checked to see if there are indeed old server processes
still running?

>
> *Yuval Sofer*



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "Sofer, Yuval"
Date:
Subject: Postgres 9.2.8 crash sporadically on Windows
Next
From: Ilya Ivanov
Date:
Subject: Re: Regexp matching + typecasts