pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres server crashing unexpectedly.
8+ messages / 4 participants
[nested] [flat]
* Postgres server crashing unexpectedly.
@ 2012-03-07 21:59 umashankar narayanan <umashankar@graffiti.net>
2012-03-08 17:06 ` Re: Postgres server crashing unexpectedly. Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 8+ messages in thread
From: umashankar narayanan @ 2012-03-07 21:59 UTC (permalink / raw)
To: pgsql-admin
Version : 8.3
Below is the log from the server.
-----------------------------------------------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
2012-03-07 21:59 Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
@ 2012-03-08 17:06 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 8+ messages in thread
From: Kevin Grittner @ 2012-03-08 17:06 UTC (permalink / raw)
To: umashankar narayanan <umashankar@graffiti.net>; pgsql-admin
"umashankar narayanan" <umashankar@graffiti.net> wrote:
> Version : 8.3
>
>
> Below is the log from the server.
>
>
> -----------------------------------------------------------------
> ------------------------------------------------------
The above is everything that showed up on your post. Make sure
you're not attaching large images, file which can only be viewed on
a particular operating system, or anything else unusual.
Please read this and try again:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
@ 2012-03-08 18:25 Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 8+ messages in thread
From: Kevin Grittner @ 2012-03-08 18:25 UTC (permalink / raw)
To: umashankar narayanan <umashankar@graffiti.net>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
@ 2012-03-08 19:23 umashankar narayanan <umashankar@graffiti.net>
2012-03-08 19:57 ` Re: Postgres server crashing unexpectedly. Scott Marlowe <scott.marlowe@gmail.com>
2012-03-08 20:06 ` Re: Postgres server crashing unexpectedly. Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 2 replies; 8+ messages in thread
From: umashankar narayanan @ 2012-03-08 19:23 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
2012-03-08 19:23 Re: Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
@ 2012-03-08 19:57 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-03-08 21:10 ` Re: Postgres server crashing unexpectedly. Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 8+ messages in thread
From: Scott Marlowe @ 2012-03-08 19:57 UTC (permalink / raw)
To: umashankar narayanan <umashankar@graffiti.net>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
On Thu, Mar 8, 2012 at 12:23 PM, umashankar narayanan
<umashankar@graffiti.net> wrote:
> 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?
If I remember correctly this bug was fixed in later windows versions.
Can you try upgrading to 8.3.latest?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
2012-03-08 19:23 Re: Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
2012-03-08 19:57 ` Re: Postgres server crashing unexpectedly. Scott Marlowe <scott.marlowe@gmail.com>
@ 2012-03-08 21:10 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2012-03-08 21:10 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: umashankar narayanan <umashankar@graffiti.net>; Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Thu, Mar 8, 2012 at 12:23 PM, umashankar narayanan
> <umashankar@graffiti.net> wrote:
>> The full version of Postgres is 8.3.1. It is running on Microsoft Windows
>> 2003 Standard 32-bit on VMWare.
> If I remember correctly this bug was fixed in later windows versions.
see release notes for 8.3.8 ...
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
2012-03-08 19:23 Re: Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
@ 2012-03-08 20:06 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 8+ messages in thread
From: Kevin Grittner @ 2012-03-08 20:06 UTC (permalink / raw)
To: umashankar narayanan <umashankar@graffiti.net>; pgsql-admin
[Please don't top-post. http://idallen.com/topposting.html ]
"umashankar narayanan" <umashankar@graffiti.net> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
>> "umashankar narayanan" <umashankar@graffiti.net> wrote:
>> Please give the full version
> The full version of Postgres is 8.3.1.
You are missing four years of bug fixes for 8.3.
http://www.postgresql.org/support/versioning/
To see what fixes you are missing, look at the links to release
notes for 8.3.2 to 8.3.18:
http://www.postgresql.org/docs/8.3/static/release.html
Please either update to a recent bug-fix release of 8.3 or review
all of these pages closely to be sure that your problem couldn't
have been caused by any of the already-fixed bugs.
>>> 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?
> 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"
That's about one minute before the crash. If that's not what caused
the crash, it's a heck of a coincidence.
>>> 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?
> 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.
Perhaps the debugger still had some process active and attached to
shared memory at the point that this was logged, but has since
released the memory? *Something* was still using PostgreSQL shared
memory at 2012-03-07 11:57:22 EST.
-Kevin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgres server crashing unexpectedly.
@ 2012-03-09 16:02 umashankar narayanan <umashankar@graffiti.net>
0 siblings, 0 replies; 8+ messages in thread
From: umashankar narayanan @ 2012-03-09 16:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
Thanks Team! We are working on upgrading to the later versions.
----- Original Message -----
From: Tom Lane
Sent: 03/08/12 04:10 PM
To: Scott Marlowe
Subject: Re: [ADMIN] Postgres server crashing unexpectedly.
Scott Marlowe <scott.marlowe@gmail.com> writes: > On Thu, Mar 8, 2012 at 12:23 PM, umashankar narayanan > <umashankar@graffiti.net> wrote: >> The full version of Postgres is 8.3.1. It is running on Microsoft Windows >> 2003 Standard 32-bit on VMWare. > If I remember correctly this bug was fixed in later windows versions. see release notes for 8.3.8 ... -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2012-03-09 16:02 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-07 21:59 Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
2012-03-08 17:06 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2012-03-08 18:25 Re: Postgres server crashing unexpectedly. Kevin Grittner <Kevin.Grittner@wicourts.gov>
2012-03-08 19:23 Re: Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
2012-03-08 19:57 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-03-08 21:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-03-08 20:06 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2012-03-09 16:02 Re: Postgres server crashing unexpectedly. umashankar narayanan <umashankar@graffiti.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox