The following bug has been logged online:
Bug reference: 3591
Logged by: Ben Kim
Email address: bkim@tamu.edu
PostgreSQL version: 8.1.0
Operating system: Solaris 8
Description: autovacuum crash
Details:
The server crashed suddenly the second time since two days ago. ulimit is
unlimited, but I see no core file under the postgresql root directory.
=============================
6780 2007-08-31 14:01:46 CDT LOG: autovacuum process (PID 6379) was
terminated by signal 11
6780 2007-08-31 14:01:46 CDT LOG: terminating any other active server
processes
user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 WARNING: terminating
connection because of crash of another server process
user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 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.
user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 HINT: In a moment you
should be able to reconnect to the database and repeat your command.
.... (repeated for every database) ...
6780 2007-08-31 14:01:47 CDT LOG: all server processes terminated;
reinitializing
6381 2007-08-31 14:01:47 CDT LOG: database system was interrupted at
2007-08-31 14:01:35 CDT
6381 2007-08-31 14:01:47 CDT LOG: checkpoint record is at F/5A51F588
6381 2007-08-31 14:01:47 CDT LOG: redo record is at F/5A51F588; undo
record is at 0/0; shutdown FALSE
6381 2007-08-31 14:01:47 CDT LOG: next transaction ID: 140043601; next
OID: 25139832
6381 2007-08-31 14:01:47 CDT LOG: next MultiXactId: 411; next
MultiXactOffset: 897
6381 2007-08-31 14:01:47 CDT LOG: database system was not properly
shut down; automatic recovery in progress
6381 2007-08-31 14:01:47 CDT LOG: redo starts at F/5A51F5D0
6381 2007-08-31 14:01:47 CDT LOG: record with zero length at
F/5A525C18
6381 2007-08-31 14:01:47 CDT LOG: redo done at F/5A525BE8
6381 2007-08-31 14:01:47 CDT LOG: database system is ready
6381 2007-08-31 14:01:47 CDT LOG: transaction ID wrap limit is
1206535619, limited by database db3