From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: umashankar narayanan <umashankar@graffiti.net>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres server crashing unexpectedly.
Date: Thu, 08 Mar 2012 14:06:48 -0600
Message-ID: <4F58BCF80200002500046051@gw.wicourts.gov> (raw)
In-Reply-To: <20120308192359.223710@gmx.com>
References: <20120308192359.223710@gmx.com>
[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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, umashankar@graffiti.net
Subject: Re: Postgres server crashing unexpectedly.
In-Reply-To: <4F58BCF80200002500046051@gw.wicourts.gov>
References: <20120308192359.223710@gmx.com> <4F58BCF80200002500046051@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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