Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 9.0.4 crashing

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "R, Abhilash (HP Software)" <abhilash(dot)r(at)hp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL 9.0.4 crashing
Date: 2012-05-31 21:15:25
Message-ID: CAHyXU0zTfEmkKTLU9JB9iZ2YA04pAT9SJ08_rcjiuf15zeLFTQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, May 31, 2012 at 4:57 AM, R, Abhilash (HP Software)
<abhilash(dot)r(at)hp(dot)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

In response to

Responses

pgsql-general by date

Next:From: Jeff DavisDate: 2012-05-31 21:22:55
Subject: Re: Procedural Languages
Previous:From: Scott MarloweDate: 2012-05-31 20:57:58
Subject: Re: Procedural Languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group