From: | "Ben Kim" <bkim(at)tamu(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3591: autovacuum crash |
Date: | 2007-08-31 20:13:01 |
Message-ID: | 200708312013.l7VKD1BT050820@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3591
Logged by: Ben Kim
Email address: bkim(at)tamu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-08-31 21:09:20 | Re: BUG #3591: autovacuum crash |
Previous Message | Tom Lane | 2007-08-31 14:00:17 | Re: BUG #3590: Error while in Plpgsql : |