page 1 of relation global/11787 was uninitialized

From: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: page 1 of relation global/11787 was uninitialized
Date: 2013-04-09 16:21:20
Message-ID: 20130409162120.GA12023@cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Just today one of my systems experienced a kernel panic, and halted abruptly.
Running Linux 3.1.9, PostgreSQL 9.0.4 (Debian 9.0.4-1+b1, to be precise).

The system was moderately active, i.e. about one commit per minute.
It is not a large problem if the last few commits would be gone.

Now, in restarting the system, I get this:

-------------------------
LOG: database system was interrupted while in recovery at 2013-04-09 18:07:45 CEST
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at D/B0BCE118
LOG: redo starts at D/B0BAB734
LOG: invalid record length at D/B0BAE010
LOG: redo done at D/B0BADFC4
LOG: last completed transaction was at log time 2013-04-09 14:50:29.743986+02
WARNING: page 1 of relation global/11787 was uninitialized
PANIC: WAL contains references to invalid pages
LOG: startup process (PID 30827) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
-------------------------

Looking at global/11787, doesn't reveal any obvious corruption.
The server was running with:
synchronous_commit = off
full_page_writes = off

to maximise performance, since the data is not 100% critical, but I would
like to recover the data up to some point in the past (an hour ago is fine).

Any suggestions?
Restarting PostgreSQL several times, results in identical messages.
--
Stephen.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-04-09 16:22:10 Re: [HACKERS] pgsql: Add sql_drop event for event triggers
Previous Message David Fetter 2013-04-09 16:13:04 Re: Call for Google Summer of Code mentors, admins