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

Re: CRITICAL HELP NEEDED! DEAD DB!

From: "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com>
To: Cott Lang <cott(at)internetstaff(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CRITICAL HELP NEEDED! DEAD DB!
Date: 2004-09-24 18:16:13
Message-ID: 4154646D.7040608@tocr.com (view raw or flat)
Thread:
Lists: pgsql-hackers
For starters a little more detail would be helpful, for example:

What version of PostgreSQL?  What OS? What compiler?  What happened that 
caused this? Server Crash?

Matthew


Cott Lang wrote:

>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!!!
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>  
>


In response to

pgsql-hackers by date

Next:From: Dann CorbitDate: 2004-09-24 18:37:29
Subject: Re: CRITICAL HELP NEEDED! DEAD DB!
Previous:From: Cott LangDate: 2004-09-24 17:21:28
Subject: CRITICAL HELP NEEDED! DEAD DB!

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