[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: db broken, recover and dump fails

From: Henrik Frisk <mail_at_henrikfrisk.com>
Date: 2005-05-09 23:46:38 CEST

Max Bowsher <maxb@ukf.net> wrote:

> > This is what I get in the end:
> >
> > svnadmin verify subv
> > svn: Corrupt DB: revision 0 missing from 'revisions' table, in filesystem
> > 'subv/db'
> >
> > At least, that's a message i haven't seen before :). Is there's
> > something I
> > can do to fix that? db_recover doesn't work and svnadmin recover doesn't
> > work. I put my repository up at
> > http://www.henrikfrisk.com/documents/repos.tar.gz
>
>
> Drat, I forgot about that bug in BDB 4.2's db_dump.
>
> If you haven't deleted a_new_repository, then run the procedure below:
>
> cd path/to/my_old_repository
> cd ..
>
> for i in revisions uuids; do
> db_dump -r "$i" | egrep -v '^keys=1$' | db_load -h
> ../../a_new_repository/db "$i"
> done
>
> cd ../..
> svnadmin recover a_new_repository
> svnadmin verify a_new_repository
>
>
>
> If you have deleted a_new_repository, then the *full* procedure would be:
>
> cd path/to/my_old_repository
> cd ..
> svnadmin create --fs-type=bdb a_new_repository
> cd a_new_repository/db
> rm *s __db.* log.*
> cd ../../my_old_repository/db
> for i in changes copies nodes representations strings transactions; do
> db_dump -r "$i" | db_load -h ../../a_new_repository/db "$i"
> done
> for i in revisions uuids; do
> db_dump -r "$i" | egrep -v '^keys=1$' | db_load -h
> ../../a_new_repository/db "$i"
> done
> cd ../..
> svnadmin recover a_new_repository
> svnadmin verify a_new_repository
>
>
>
>
> Max.

Max, You are a genius! So far it seems to work, I did a check out and a commit and I didn't get any error messages. Thank you so much! You really saved me a lot of trouble there.

One more question: How come this happened? Was it the power failure? It seems to me that a few people have run in to similar problems and some seems to suggest not using bdb. These are just open questions, I know that there has been some discussions going on on this list. I will treat my repos with great care from now on.

Best,

Henrik Frisk

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon May 9 23:49:44 2005

This is an archived mail posted to the Subversion Users mailing list.