Re: Back end dies...

>
> Does your server log have any entries at around that point for the actual
> backend death? Do you have a core file?

No core file, but here's the stuff from the log. Strange, I don't remember
kill -9'ing the backend...

> DEBUG: server process (pid 26460) was terminated by signal 9
DEBUG: terminating any other active server processes
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
DEBUG: all server processes terminated; reinitializing shared memory and
semaphores
DEBUG: database system was interrupted at 2002-03-15 20:56:17 IST
DEBUG: checkpoint record is at 33/CBC5968
DEBUG: redo record is at 33/CBC5968; undo record is at 0/0; shutdown FALSE
DEBUG: next transaction id: 5946; next oid: 783000267
DEBUG: database system was not properly shut down; automatic recovery in
progress
DEBUG: ReadRecord: record with zero length at 33/CBC59A8
DEBUG: redo is not required
DEBUG: database system is ready