berkeley DB problem

[Net Llama!]

On 08/18/2004 03:58 AM, Kurt Wall wrote:
> In a 1.6K blaze of typing glory, Net Llama! wrote:
> 
>>This one's for any berkeley DB experts out there.  I use berkeleyDB as 
>>the backend for my movable type blog.  About 10 days ago the partition 
>>where it resides filled up (this isn't my box, don't blame me), and 
>>caused some corruption to the DB.
>>
>>I've been trying to fix it with the assorted BDB tools (db_recover, 
>>db_dump) but i keep running into problems:
>>
>>$ db_dump -f entry.db.out entry.db
>>db_dump: page 206: illegal page type or format
>>db_dump: PANIC: Invalid argument
>>db_dump: DB->stat: DB_RUNRECOVERY: Fatal error, run database recovery
>>db_dump: PANIC: fatal region error detected; run recovery
>>db_dump: close: DB_RUNRECOVERY: Fatal error, run database recovery
>>db_dump: PANIC: fatal region error detected; run recovery
>>db_dump: dbenv->close: DB_RUNRECOVERY: Fatal error, run database recovery
> 
> 
> Use db_verify to validate the structure. I'd suggest using -h to specify
> a home directory that is different from the default.
> 
> 
>>$ db_recover -v
>>db_recover: unable to join the environment
>>db_recover: Recovery complete at Tue Aug 17 17:47:41 2004
>>db_recover: Maximum transaction id 80000000 Recovery checkpoint [0][0]
> 
> 
> Again, use -h to specify a different home directory. It sounds like you
> had a catastrophic failure, so use the -c option, too. See
> http://www.sleepycat.com/docs/ref/transapp/recovery.html, which might not
> apply if you aren't using DB's transaction support.

Tried that stuff, but no love.  Someone in comp.databases.berkeley-db 
suggested
db_dump -r -f entry.db.out entry.db

which does seem to give me a full dump, but when i load it back in, 
things are more broken than before.

I wish there was some kind of tool for viewing/editing the contents of 
BDB.  It wouldn't surprise me if the scope of the original problem was a 
few null values in a single record out of the 302 that I have.


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                       	       netllama at linux-sxs.org
Linux Step-by-step & TyGeMo: 		    http://netllama.ipfox.com

  18:45:00 up 59 days,  5:31,  1 user,  load average: 0.09, 0.16, 0.12