The following bug has been logged online: Bug reference: 3591 Logged by: Ben Kim Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
