User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 426,970 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,433 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 1061 | Replies: 0
Reply
Join Date: Aug 2006
Posts: 999
Reputation: EnderX is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 1
EnderX EnderX is offline Offline
Posting Shark

PostgreSQL restart error: PANIC: block 39 unfound

  #1  
Jul 31st, 2007
Yesterday, I was attempting to reload a remote copy of a postgresql database that had been corrupted. Creating the new db went well, as did reloading the data schema, but somewhere during the reload of the data itself, I lost the remote connection. After killing the now-unworking putty connection and opening a new one, I discovered that neither the postgresql system, nor the postmaster it uses, were running. And when I try to restart the postmaster, I get the following page of errors:

LOG: database system was interrupted while in recovery at 2007-07-31 08:54:40 CDT
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
WARNING: autovacuum not started because of misconfiguration
HINT: Enable options "stats_start_collector" and "stats_row_level".
LOG: checkpoint record is at 3C/D7008078
LOG: redo record is at 3C/D7008078; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 59170527; next OID: 532878
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 3C/D70080BC
PANIC: block 39 unfound
LOG: startup process (PID 6852) was terminated by signal 6
LOG: aborting startup due to startup process failure

I googled for the panic message and found a small thread on the postgresql hacker's mailing list detailing a similar event, but the thread gave no clues as to how to resolve the issue. Can anyone here think of anything that might help solve this problem?
"No trees were harmed in the production of this post. However, several electrons were severely inconvenienced."

Kumquat.
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Database Design Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Database Design Forum

All times are GMT -4. The time now is 1:26 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC