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

DB Corruption and Tuning

From: Peter Kahn <pkahn_at_connected.com>
Date: 2005-03-08 17:05:01 CET

My DB hit the same corruption again yesterday. I believe I found the
cause. I looked back through my commit logs and the same user was
always the last to commit prior to my crash. Upon interviewing here I
discovered that when she submitted via Tortoise 113, the files would
start to go up, there would be a connection lost error and upon resubmit
the submission would work. This submission was the last prior to svn
becoming wedged.

I soon discovered the following interesting aspects of her workspace

1. The commit - fail - recommit problem
2. A bunch of files that she thought she had committed didn't show up in
the build
3. If she did an update she got scores of conflicts even though she had
the latest version of the files (or so svn command line 1.1.3 claimed)

We created a new workspace and migrated individual files over and she
appears to be ok now. The 3 problems above are gone and I haven't
crashed in almost 12 hours even though she checked in.

So, my problems may be been related to a corruption in a workspace. Or
the problems with the server may have caused the corruption. It could
even be a symbiotic relationship.

I am considering two courses of action:
1. Investigating the file system based FCFS for backend storage
2. Looking into tuning my BerkeleyDB backend

I developer at my shop noticed the following email on the developer list

It is possible that the default svn tuning options in DB_CONF are viable
for a small environment, but do not serve a 7 GB environment with 20-40

I have the db_stat (with -m option) command running every 10 minutes
making samples so I have an idea of cache usage and a few other

QUESTIONS -------------------------------------
Does anyone have any experience with tuning, especially with increasing
the cache? I haven't yet found the right syntax for setting it higher
than the 256KB.


Peter Kahn
Connected Corporation,
A subsidiary of Iron Mountain Incorporated
PackReq Described:
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Mar 8 17:07:39 2005

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

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.