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

Re: Database is crashing too often

From: Rachael Russell <rachael.russell_at_gmail.com>
Date: 2005-09-06 13:00:04 CEST

Matthias Fechner wrote:

>Hi,
>
>i have here subversion 1.2.1 on FreeBSD running. For some days it is
>running fine and after a not reproducable time i get the error
>message, if i try to checkin:
>
>svn: Commit failed (details follow):
>svn: Berkeley DB error for filesystem /usr/local/svn/wow/db while
>opening environment:
>DB_RUNRECOVERY: Fatal error, run database recovery
>svn: bdb: PANIC: fatal region error detected; run recovery
>
>I need then to recover the database with svnadmin recover, after this
>it is working fine.
>
>What can here be the problem?
>
>
>
You might find fsfs more stable than BDB - we used to have lots of
crashes, until moving over to a fsfs repository.

This is how I convert repositories from BDB to fsfs:

(from the Red Book:
http://svnbook.red-bean.com/en/1.1/ch05s03.html#svn-ch-5-sect-3.5):

> svnadmin verify /path/to/old/bdb/repos (check no issues in old
repository)
> svnadmin create --fs-type fsfs /path/to/new/fsfs/repos (1.2 may use
fsfs by default I think??)
> svnadmin dump /path/to/old/bdb/repos | svnadmin load
/path/to/new/fsfs/repos

** Note - this will dump every revision - you can add filters etc to the
dump command if needed.

Once you're happy it's all OK, you can then delete the old bdb
repository - if the repository has the same name as the old one in your
apache conf, clients shouldnt need to change anything to continue working.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Sep 6 13:02:17 2005

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