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