pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
9.1.2 Postgres corruption, any way to recover? 2+ messages / 2 participants [nested] [flat]
* 9.1.2 Postgres corruption, any way to recover? @ 2014-02-23 20:42 Tory M Blue <tmblue@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Tory M Blue @ 2014-02-23 20:42 UTC (permalink / raw) To: pgsql-performance Appears one of my bigger, but older DB's cored or other this morning and when it came back up the DB shows that it can't start and is possibly corrupted. I've read this was actually due to a kernel bug sometime back (or at least tied to the kernel bug). I'm wondering if there was any other work arounds or "tricks" that I may try to recover, vs doing a restore from backup? 2014-02-23 03:46:08 PST LOG: aborting startup due to startup process failure 2014-02-23 11:10:09 PST LOG: database system was interrupted while in recovery at 2014-02-23 03:46:04 PST 2014-02-23 11:10:09 PST HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. 2014-02-23 11:10:09 PST LOG: database system was not properly shut down; automatic recovery in progress 2014-02-23 11:10:09 PST LOG: consistent recovery state reached at 1493/24398AA8 2014-02-23 11:10:09 PST LOG: redo starts at 1493/5306FC8 *2014-02-23 11:10:09 PST PANIC: heap_update_redo: invalid lp* 2014-02-23 11:10:09 PST CONTEXT: xlog redo hot_update: rel 16399/868691025/959835680; tid 1180404/38; new 1180404/40 2014-02-23 11:10:09 PST LOG: startup process (PID 3175) was terminated by signal 6: Aborted 2014-02-23 11:10:09 PST LOG: aborting startup due to startup process failure Not holding out hope, but maybe just maybe someone has some ideas/shortcuts to maybe get this DB back up Thanks Tory ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 9.1.2 Postgres corruption, any way to recover? @ 2014-02-23 21:57 Tomas Vondra <tv@fuzzy.cz> parent: Tory M Blue <tmblue@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tomas Vondra @ 2014-02-23 21:57 UTC (permalink / raw) To: pgsql-performance On 23.2.2014 21:42, Tory M Blue wrote: > Appears one of my bigger, but older DB's cored or other this morning and > when it came back up the DB shows that it can't start and is possibly > corrupted. I've read this was actually due to a kernel bug sometime back > (or at least tied to the kernel bug). ... > > Not holding out hope, but maybe just maybe someone has some > ideas/shortcuts to maybe get this DB back up I think the first thing you should ask yourself is why you're running 9.1.2, i.e. a 3 years old revision, instead of the current 9.1.12. Maybe it's not the cause of the bug, but still ... Also, it seems to me that the corruption happened some time ago and you only discovered it now. Which is strange, because corrupted page header should kill every backup attempt. Are you sure you really have backups? I mean, tested and working backups? Do you have an idea how many blocks are actually corrupted? Is it just this single one, or are there more? Are you sure it's a actually due to a kernel bug, and not a storage failure (for example)? And what kernel do you have in mind? There are certainly tricks to make it work (e.g. zeroing the block with corrupted header), but that means data loss (you won't have data from the block) and it's tedious / time consuming. If you have a working backup, and if it's acceptable to loose the data since then, you should probably do that. The only thing that might help you to recover all the data is probably PITR, i.e. a base backup + WAL archive (or replication). regards Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-02-23 21:57 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-02-23 20:42 9.1.2 Postgres corruption, any way to recover? Tory M Blue <tmblue@gmail.com> 2014-02-23 21:57 ` Tomas Vondra <tv@fuzzy.cz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox