Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 4622D119C295
	for <pgsql-admin@postgresql.org>; Thu,  8 Mar 2012 15:24:14 -0400 (AST)
Received: from mailout-us.gmx.com ([74.208.5.67])
	by makus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <umashankar@graffiti.net>) id 1S5iwe-0008Co-Ls
	for pgsql-admin@postgresql.org; Thu, 08 Mar 2012 19:24:13 +0000
Received: (qmail 28055 invoked by uid 0); 8 Mar 2012 19:23:59 -0000
Received: from 24.173.152.125 by rms-us009.v300.gmx.net with HTTP
Content-Type: multipart/alternative;
	boundary="========GMXBoundary223711331234639377093"
Date: Thu, 08 Mar 2012 14:23:59 -0500
From: "umashankar narayanan" <umashankar@graffiti.net>
Message-ID: <20120308192359.223710@gmx.com>
MIME-Version: 1.0
Subject: Re: Postgres server crashing unexpectedly.
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>,pgsql-admin@postgresql.org
X-Authenticated: #100483258
X-Flags: 0001
X-Mailer: GMX.com Web Mailer
x-registered: 0
X-GMX-UID: GGIrbwc23zOl29sjlnEhQ0B+IGRvbwDH
X-Pg-Spam-Score: -1.5 (-)
X-Archive-Number: 201203/39
X-Sequence-Number: 39227

--========GMXBoundary223711331234639377093
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Kevin,

 The full version of Postgres is 8.3.1. It is running on Microsoft Windows 2003 Standard 32-bit on VMWare.
 On the system logs around this time, the only message that we receive is that the PID crashed. 

 All that I see on the postgres log before the crash is the below message:

 2012-03-07 11:56:12 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"

 No other postgres processes are lingering. I did confirm that no other batch jobs or monitoring jobs were running during this time, that would grab the same shared memory block.

 Thanks!
 Umashankar



----- Original Message -----
From: Kevin Grittner
Sent: 03/08/12 01:25 PM
To: umashankar narayanan, pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres server crashing unexpectedly.

 "umashankar narayanan" <umashankar@graffiti.net> wrote: > Version : 8.3 Please give the full version and a bit more information about the environment it's running in: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems > 2012-03-07 11:57:20 EST LOG: server process (PID 5944) exited > with exit code 128 Was there anything in the PostgreSQL log ahead of this to give a clue what went wrong and caused this? Is there anything in any of system logs from around this time? > 2012-03-07 11:57:20 EST LOG: terminating any other active server > processes This is normal -- when one process crashes this hard, it can leave shared memory in a corrupted state, so PostgreSQL restarts to get a clean environment with minimal down time. > [each client process logging its termination] > 2012-03-07 11:57:21 EST LOG: all server processes terminated; > reinitializing OK, it's trying to restart so clients can re-connect and continue. > 2012-03-07 11:57:22 EST FATAL: pre-existing shared memory block > is still in use > 2012-03-07 11:57:22 EST HINT: Check if there are any old server > processes still running, and terminate them. Something is still hanging on to the PostgreSQL shared memory block. Are any postgres processes lingering? Are you running anything else which might be grabbing the same shared memory block? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

--========GMXBoundary223711331234639377093
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<span style=3D'font-family:Verdana'><span style=3D'font-size:12px'><span st=
yle=3D"font-family: verdana;"><span style=3D"font-size: 12px;">Kevin,<br />=
=20
<br />=20
The full version of Postgres is 8.3.1. It is running on Microsoft Windows 2=
003 Standard 32-bit on VMWare.<br />=20
On the system logs around this time, the only message that we receive is th=
at the PID crashed. </span></span><br />=20
<br />=20
All that I see on the postgres log before the crash is the below message:<b=
r />=20
<br />=20
2012-03-07 11:56:12 EST LOG:&nbsp; loaded library "$libdir/plugins/plugin_d=
ebugger.dll"<br />=20
<br />=20
No other postgres processes are lingering. I did confirm that no other batc=
h jobs or monitoring jobs were running during this time, that would grab th=
e same shared memory block.<br />=20
<br />=20
Thanks!<br />=20
Umashankar<br />=20
<br />=20
<br />=20
<br />=20
<p style=3D"margin:0px; padding:0px;" >=20
	=C2=A0</p>=20
<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); padding-lef=
t: 5px; margin: 0px 0px 0px 5px;" type=3D"cite">=20
	<p style=3D"margin:0px; padding:0px;" >=20
		<span style=3D"font-family: Verdana;"><span style=3D"font-size: 12px;">--=
--- Original Message -----</span></span></p>=20
	<p style=3D"margin:0px; padding:0px;" >=20
		<span style=3D"font-family: Verdana;"><span style=3D"font-size: 12px;">Fr=
om: Kevin Grittner</span></span></p>=20
	<p style=3D"margin:0px; padding:0px;" >=20
		<span style=3D"font-family: Verdana;"><span style=3D"font-size: 12px;">Se=
nt: 03/08/12 01:25 PM</span></span></p>=20
	<p style=3D"margin:0px; padding:0px;" >=20
		<span style=3D"font-family: Verdana;"><span style=3D"font-size: 12px;">To=
: umashankar narayanan, pgsql-admin@postgresql.org</span></span></p>=20
	<p style=3D"margin:0px; padding:0px;" >=20
		<span style=3D"font-family: Verdana;"><span style=3D"font-size: 12px;">Su=
bject: Re: [ADMIN] Postgres server crashing unexpectedly.</span></span></p>=
=20
	<br />=20
	<div>=20
		<div>=20
			<pre style=3D"white-space: pre-wrap; word-wrap: break-word;">=20
"umashankar narayanan" &lt;umashankar@graffiti.net&gt; wrote:=20
=20
&gt; Version : 8.3=20
=20
Please give the full version and a bit more information about the=20
environment it's running in:=20
=20
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems=20
=20
&gt;  2012-03-07 11:57:20 EST LOG: server process (PID 5944) exited=20
&gt; with exit code 128=20
=20
Was there anything in the PostgreSQL log ahead of this to give a=20
clue what went wrong and caused this?  Is there anything in any of=20
system logs from around this time?=20
=20
&gt;  2012-03-07 11:57:20 EST LOG: terminating any other active server=20
&gt; processes=20
=20
This is normal -- when one process crashes this hard, it can leave=20
shared memory in a corrupted state, so PostgreSQL restarts to get a=20
clean environment with minimal down time.=20
=20
&gt; [each client process logging its termination]=20

&gt;  2012-03-07 11:57:21 EST LOG: all server processes terminated;=20
&gt; reinitializing=20
=20
OK, it's trying to restart so clients can re-connect and continue.=20
=20
&gt;  2012-03-07 11:57:22 EST FATAL: pre-existing shared memory block=20
&gt; is still in use=20
&gt;  2012-03-07 11:57:22 EST HINT: Check if there are any old server=20
&gt; processes still running, and terminate them.=20
=20
Something is still hanging on to the PostgreSQL shared memory block.=20
=20
Are any postgres processes lingering?  Are you running anything else=20
which might be grabbing the same shared memory block?=20
=20
-Kevin=20

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)=20
To make changes to your subscription:=20
http://www.postgresql.org/mailpref/pgsql-admin</pre>=20
		</div>=20
	</div>=20
</blockquote>=20
</span></span>

--========GMXBoundary223711331234639377093--