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.
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 |