random backend crashes - how to debug ( Is crash dump handler released ? )

From: BangarRaju Vadapalli <BangarRaju(dot)Vadapalli(at)infor(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: random backend crashes - how to debug ( Is crash dump handler released ? )
Date: 2011-06-14 14:26:46
Message-ID: 3DF304319BFE284182A530654E026383189081855D@INHYWEXMB2.infor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Everybody,

We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. Here are the logs.

2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 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.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 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.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 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.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 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.

I searched online and found crash dump handler idea has been proposed and patch for that has already been released if I am not wrong. Could anyone please detail the steps to install crash dump handler in windows? Also could you please help me with the ways to debug the crashes happening as shown above.

Thanks,
Bangar Raju

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erwin Moller 2011-06-14 14:45:02 psql reports back wrong number of affected rows.
Previous Message Tom Lane 2011-06-14 14:15:00 Re: Per-query local timezone