Re: PostgreSQL 9.0.4 crashing - Mailing list pgsql-general

From Merlin Moncure
Subject Re: PostgreSQL 9.0.4 crashing
Date
Msg-id CAHyXU0zTfEmkKTLU9JB9iZ2YA04pAT9SJ08_rcjiuf15zeLFTQ@mail.gmail.com
Whole thread Raw
In response to PostgreSQL 9.0.4 crashing  ("R, Abhilash (HP Software)" <abhilash.r@hp.com>)
Responses Re: PostgreSQL 9.0.4 crashing
List pgsql-general
On Thu, May 31, 2012 at 4:57 AM, R, Abhilash (HP Software)
<abhilash.r@hp.com> wrote:
> PostgreSQL 9.0.4 is crashing intermittently in Windows 2008 R2 environment
> with following error in log file.
>
>
>
> 2012-05-31 03:15:54 IST LOG:  server process (PID 49972) was terminated by
> exception 0xC000012D
>
> 2012-05-31 03:15:54 IST HINT:  See C include file "ntstatus.h" for a
> description of the hexadecimal value.
>
> 2012-05-31 03:15:54 IST LOG:  terminating any other active server processes
>
> 2012-05-31 03:15:54 IST WARNING:  terminating connection because of crash of
> another server process
>
> 2012-05-31 03:15:54 IST 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-05-31 03:15:54 IST HINT:  In a moment you should be able to reconnect
> to the database and repeat your command.
>
> 2012-05-31 03:15:54 IST WARNING:  terminating connection because of crash of
> another server process
>
>
>
> I could find a related, known issue with 8.3.9 with ref. 5965; Is  this
> issue fixed in 9.0.4?

After some googling I'm seeing some hints that you may have
overcommitted virtual memory.  How much memory do you have and what's
shared buffers set to?  Is this 32/64 bit?

merlin

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Procedural Languages
Next
From: Jeff Davis
Date:
Subject: Re: Procedural Languages