Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 292B1119C295 for ; Thu, 8 Mar 2012 14:29:51 -0400 (AST) Received: from mailout-us.gmx.com ([74.208.5.67]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S5i5y-0008Lg-32 for pgsql-admin@postgresql.org; Thu, 08 Mar 2012 18:29:49 +0000 Received: (qmail 22123 invoked by uid 0); 8 Mar 2012 18:29:32 -0000 Received: from 24.173.152.125 by rms-us014.v300.gmx.net with HTTP Content-Type: multipart/alternative; boundary="========GMXBoundary223721331231370594872" Date: Thu, 08 Mar 2012 13:29:30 -0500 From: "umashankar narayanan" Message-ID: <20120308182930.223720@gmx.com> MIME-Version: 1.0 Subject: Postgres 8.3 crashing unexpectedly To: Pgsql Admin X-Authenticated: #100483258 X-Flags: 0001 X-Mailer: GMX.com Web Mailer x-registered: 0 X-GMX-UID: 3Z8qbwA23zOl29sjlnEhwWl+IGRvbwAJ X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/38 X-Sequence-Number: 39226 --========GMXBoundary223721331231370594872 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit Version : 8.3 Below is the log from the server. ----------------------------------------------------------------------------------------------------------------------- 2012-03-07 11:57:20 EST LOG: server process (PID 5944) exited with exit code 128 2012-03-07 11:57:20 EST LOG: terminating any other active server processes 2012-03-07 11:57:20 EST WARNING: terminating connection because of crash of another server process 2012-03-07 11:57:20 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-03-07 11:57:20 EST HINT: In a moment you should be able to reconnect to the database and repeat your command. 2012-03-07 11:57:20 EST WARNING: terminating connection because of crash of another server process 2012-03-07 11:57:20 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-03-07 11:57:20 EST HINT: In a moment you should be able to reconnect to the database and repeat your command. 2012-03-07 11:57:20 EST WARNING: terminating connection because of crash of another server process 2012-03-07 11:57:20 EST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2012-03-07 11:57:20 EST HINT: In a moment you should be able to reconnect to the database and repeat your command. some more repeat of the above WARNING, DETAIL, HINT messages and then the below 2012-03-07 11:57:21 EST LOG: archiver process (PID 9600) exited with exit code 1 2012-03-07 11:57:21 EST LOG: all server processes terminated; reinitializing 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. ----------------------------------------------------------------------------------------------------------------------- Thanks in advance! --========GMXBoundary223721331231370594872 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Version&= nbsp;  : 8.3
=20
=20 Below is the log from the server.
=20
=20 ---------------------------------------------------------------------------= --------------------------------------------
=20
=20 2012-03-07 11:57:20 EST LOG:  server process (PID 5944) exited with ex= it code 128
=20 2012-03-07 11:57:20 EST LOG:  terminating any other active server proc= esses
=20 2012-03-07 11:57:20 EST WARNING:  terminating connection because of cr= ash of another server process
=20 2012-03-07 11:57:20 EST DETAIL:  The postmaster has commanded this ser= ver process to roll back the current transaction and exit, because another = server process exited abnormally and possibly corrupted shared memory.
=20 2012-03-07 11:57:20 EST HINT:  In a moment you should be able to recon= nect to the database and repeat your command.
=20 2012-03-07 11:57:20 EST WARNING:  terminating connection because of cr= ash of another server process
=20 2012-03-07 11:57:20 EST DETAIL:  The postmaster has commanded this ser= ver process to roll back the current transaction and exit, because another = server process exited abnormally and possibly corrupted shared memory.
=20 2012-03-07 11:57:20 EST HINT:  In a moment you should be able to recon= nect to the database and repeat your command.
=20 2012-03-07 11:57:20 EST WARNING:  terminating connection because of cr= ash of another server process
=20 2012-03-07 11:57:20 EST DETAIL:  The postmaster has commanded this ser= ver process to roll back the current transaction and exit, because another = server process exited abnormally and possibly corrupted shared memory.
=20 2012-03-07 11:57:20 EST HINT:  In a moment you should be able to recon= nect to the database and repeat your command.
=20
=20 some more repeat of the above WARNING, DETAIL, HINT messages and then the b= elow
=20
=20
=20 2012-03-07 11:57:21 EST LOG:  archiver process (PID 9600) exited with = exit code 1
=20 2012-03-07 11:57:21 EST LOG:  all server processes terminated; reiniti= alizing
=20 2012-03-07 11:57:22 EST FATAL:  pre-existing shared memory block is st= ill in use
=20 2012-03-07 11:57:22 EST HINT:  Check if there are any old server proce= sses still running, and terminate them.
=20
=20
=20 ---------------------------------------------------------------------------= --------------------------------------------
=20
=20 Thanks in advance! --========GMXBoundary223721331231370594872--