Hi, My postgres sessions, after being idle for 5 --6 hrs, crash on their own. Sometimes with error messages sometimes without. The message I get appended below. I was looking for suggestion to narrow down as to what could have caused this problem. System log doesn't show anything.
Thanks. Sandeep LOG: statistics collector process (PID 6631) was terminated by signal 9: Killed LOG: server process (PID 15710) was terminated by signal 9: Killed DETAIL: Failed process was running: COMMIT PREPARED 'T13199' 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 s erver 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. LOG: all server processes terminated; reinitializing
