|
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 |
