postmaster crash - another server process exited abnormally - Mailing list pgsql-general

From Michael Korotun
Subject postmaster crash - another server process exited abnormally
Date
Msg-id 200505061254.j46Cspci017931@outmail.freedom2surf.net
Whole thread Raw
Responses Re: postmaster crash - another server process exited abnormally
Re: postmaster crash - another server process exited
List pgsql-general

Hi Guys,

 

I am writing here again. Here is the scenario of my problem:

 

I have Postgres 8.0.1 on Linux FC3 and everything goes fine, except that a one time per week approximately I am getting server crash with a message in log:

 

==========================

LOG:  server process (PID 5252) was terminated by signal 9

LOG:  terminating any other active server processes

WARNING:  terminating connection because of crash of another server process

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.

HINT:  In a moment you should be able to reconnect to the database and repeat your command.

 

This message is appearing perhaps 40x times and server stopped. I am wondering how can I get details of where it comes from? What is the process is crashing and what causes it. Please, any help is greatly appreciated as always.

 

 

 

 

Best Regards,

Michael Korotun

 

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Adventures in Quest for GUI RAD
Next
From: Vidya
Date:
Subject: Cursor problem