PANIC: block 463 unfound during REDO after out of disk space failure during VACUUM - Mailing list pgsql-hackers

Hi everyone

Was running a VACUUM on a database on a partition which was running out 
of disk space. During VACUUM the server process died and failed to restart.

Running PostgreSQL 8.1.4

I basically want to get the system back up and running ASAP with as 
little data loss as possible. All and any help is greatly appreciated.

Here is output from error log:

Jan 11 15:02:32 marshall postgres[71515]: [2-1] WARNING:  terminating 
connection because of crash of another server process
Jan 11 15:02:32 marshall postgres[71515]: [2-2] DETAIL:  The postmaster 
has commanded this server process to roll back the current transaction 
and exit, because another server
Jan 11 15:02:32 marshall postgres[71515]: [2-3]  process exited 
abnormally and possibly corrupted shared memory.
Jan 11 15:02:32 marshall postgres[71515]: [2-4] HINT:  In a moment you 
should be able to reconnect to the database and repeat your command.
Jan 11 15:02:32 marshall postgres[67977]: [4-1] LOG:  all server 
processes terminated; reinitializing
Jan 11 15:02:32 marshall postgres[73888]: [5-1] LOG:  database system 
was interrupted at 2007-01-11 15:02:22 WST
Jan 11 15:02:32 marshall postgres[73888]: [6-1] LOG:  checkpoint record 
is at 4D/AA7B784
Jan 11 15:02:32 marshall postgres[73888]: [7-1] LOG:  redo record is at 
4D/AA7B784; undo record is at 0/0; shutdown FALSE
Jan 11 15:02:32 marshall postgres[73888]: [8-1] LOG:  next transaction 
ID: 376382676; next OID: 2891876
Jan 11 15:02:32 marshall postgres[73888]: [9-1] LOG:  next MultiXactId: 
44140; next MultiXactOffset: 91044
Jan 11 15:02:32 marshall postgres[73888]: [10-1] LOG:  database system 
was not properly shut down; automatic recovery in progress
Jan 11 15:02:32 marshall postgres[73888]: [11-1] LOG:  redo starts at 
4D/AA7B7C8
Jan 11 15:02:32 marshall postgres[73889]: [5-1] FATAL:  the database 
system is starting up
Jan 11 15:02:32 marshall postgres[73892]: [5-1] FATAL:  the database 
system is starting up
Jan 11 15:02:39 marshall postgres[73909]: [5-1] FATAL:  the database 
system is starting up
Jan 11 15:02:40 marshall postgres[73888]: [12-1] PANIC:  block 463 unfound
Jan 11 15:02:41 marshall postgres[67977]: [5-1] LOG:  startup process 
(PID 73888) was terminated by signal 6
Jan 11 15:02:41 marshall postgres[67977]: [6-1] LOG:  aborting startup 
due to startup process failure


Thanks in advance

-- 
Warren Guy

System Administrator
CalorieKing - Australia
Tel: +618.9389.8777
Fax: +618.9389.8444
warren.guy@calorieking.com
www.calorieking.com