Re: Postgres 9.2.8 crash sporadically on Windows

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Postgres 9.2.8 crash sporadically on Windows
Date: 2014-04-07 14:52:02
Message-ID: 20140407145202.GE4161@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

On 2014-04-07 09:49:09 -0500, Sofer, Yuval wrote:
> 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!

This is unfortunately not giving us many details to work with...

Are you using any self written functions? Any extensions? What's the
last query executed before the crash?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-04-07 15:15:32 Re: Postgres 9.2.8 crash sporadically on Windows
Previous Message Sofer, Yuval 2014-04-07 14:49:09 Postgres 9.2.8 crash sporadically on Windows