PANIC: block 463 unfound during REDO after out of disk space failure during VACUUM

From: Warren Guy <warren(dot)guy(at)calorieking(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PANIC: block 463 unfound during REDO after out of disk space failure during VACUUM
Date: 2007-01-11 06:12:31
Message-ID: 45A5D54F.7010906@calorieking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)guy(at)calorieking(dot)com
www.calorieking.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2007-01-11 06:41:57 Re: PANIC: block 463 unfound during REDO after out of disk space failure during VACUUM
Previous Message Jaime Casanova 2007-01-11 05:58:01 share info between backends