Skip site navigation (1) Skip section navigation (2)

Re: CRITICAL HELP NEEDED! DEAD DB!

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Cott Lang" <cott(at)internetstaff(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CRITICAL HELP NEEDED! DEAD DB!
Date: 2004-09-24 18:37:29
Message-ID: D425483C2C5C9F49B5B7A41F894415470554E0@postal.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org 
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Cott Lang
> Sent: Friday, September 24, 2004 10:21 AM
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: [HACKERS] CRITICAL HELP NEEDED! DEAD DB!
> 
> 
> Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG:  database 
> system was interrupted while in recovery at 2004-09-24 
> 10:21:41 MST Sep 24 10:22:37 snafu postgres[18306]: [2-2] 
> HINT:  This probably means that some data is corrupted and 
> you will have to use the last backup for recovery. Sep 24 
> 10:22:37 snafu postgres[18306]: [3-1] LOG:  checkpoint record 
> is at 9A/C2022368 Sep 24 10:22:37 snafu postgres[18306]: 
> [4-1] LOG:  redo record is at 9A/C2022368; undo record is at 
> 0/0; shutdown FALSE Sep 24 10:22:37 snafu postgres[18306]: 
> [5-1] LOG:  next transaction ID: 197841225; next OID: 
> 715436086 Sep 24 10:22:37 snafu postgres[18306]: [6-1] LOG:  
> database system was not properly shut down; automatic 
> recovery in progress Sep 24 10:22:37 snafu postgres[18306]: 
> [7-1] LOG:  redo starts at 9A/C20223B0 Sep 24 10:22:37 snafu 
> postgres[18306]: [8-1] PANIC:  btree_insert_redo: failed to 
> add item Sep 24 10:22:37 snafu postgres[18299]: [2-1] LOG:  
> startup process (PID
> 18306) was terminated by signal 6
> Sep 24 10:22:37 snafu postgres[18299]: [3-1] LOG:  aborting 
> startup due to startup process failure
> 
> 
> Any suggestions to recover?!  I'm dead in the water!  Please!!!

When did you do your last backup?

This message is a clue:
"HINT:  This probably means that some data is corrupted and you will
have to use the last backup for recovery."

If you do a restore from your last backup, you will lose the data
between that time and the time of the problem.  Any other solution will
be fraught with peril, I think.

Otherwise, maybe something here will help:
http://svana.org/kleptog/pgsql/pgfsck.html

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-09-24 18:43:22
Subject: Re: CRITICAL HELP NEEDED! DEAD DB!
Previous:From: Matthew T. O'ConnorDate: 2004-09-24 18:16:13
Subject: Re: CRITICAL HELP NEEDED! DEAD DB!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group