Skip site navigation (1) Skip section navigation (2)

BUG #3591: autovacuum crash

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2007-08-31 21:09:20
Subject: Re: BUG #3591: autovacuum crash
Previous:From: Tom LaneDate: 2007-08-31 14:00:17
Subject: Re: BUG #3590: Error while in Plpgsql :

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group