<help>Database is Wedged for the 6th time. Diagnostics or Prozac, anyone?

Below was my email from the 5th crash. I'm now up to the 6th. The
difference this time is that I didn't have websvn running.

I am coming to the conclusion that the svnserve executable is not ready
for production. Switching my users back from svn to http is going to
hurt, but at this point I can see no other alternative.

Does anyone have any suggestions on what I can do to make my environment
stable?

Thanks for any help you can give...

Our repository is presently at 7.7 GB with 2-4 GB of unused db logs.
Could there be a size issue for the svnserve?

My last HTTP accesses were:
192.168.163.128 - - [04/Mar/2005:15:54:01 -0500] "GET /svn/repos/V7.1/
HTTP/1.1" 200 2083 192.168.163.128 - - [04/Mar/2005:15:54:01 -0500] "GET
/favicon.ico HTTP/1.1" 404 304 192.168.163.128 - - [04/Mar/2005:15:54:03
-0500] "GET /svn/repos/V7.1/BaseVercommn.h HTTP/1.1" 200 852

My last http errors were:
[Fri Mar 04 15:47:54 2005] [error] [client 192.168.163.128] Could not
fetch resource information. [301, #0], referer:
http://svn:8080/svn/repos/Welcome_To_SVN/index.html
[Fri Mar 04 15:47:54 2005] [error] [client 192.168.163.128] (2)No such
file or directory: Requests for a collection must have a trailing slash
on the URI. [301, #0], referer:
http://svn:8080/svn/repos/Welcome_To_SVN/index.html

Tail of My Permissions Log - from pre-commit hook
Fri Mar 4 16:06:19 EST 2005
commit attempt /home/svn/repos lrf
jgoldste
2005-03-04 16:05:57 -0500 (Fri, 04 Mar 2005)
21
Fixes and changes /jg

Tail of my My commit.log - from post-commit hook
-----------------
Deltifying revision 17543...done.
Fri Mar 4 15:55:33 EST 2005
-----------------
Deltifying revision 17544...done.
Fri Mar 4 16:06:21 EST 2005
-----------------
svn: Berkeley DB error while checkpointing after Berkeley DB transaction
for filesystem /home/svn/repos/db:
DB_INCOMPLETE: Cache flush was unable to complete

-----------------------------------------------

Server:
svn: version 1.1.2 (r12471) compiled Oct 31
2004, 08:30:56
protocols supported: svnserve [read/write] & WebDav [read only]
Apache: 2.0.52
OS: Linux 2.4.20-8
Notes:
        we deltify after each check-in. I'm told this will do no harm
and do no good either.

        excerpt from my post-commit log
        # Deltify predecessors of things changed in this revision.
        date >> /home/svn/commit.log
        (nice -2 /usr/local/bin/svnadmin deltify "$REPOS" -r "$REV" >>
/home/svn/commit.log 2>&1 ) &
        echo "-----------------" >> /home/svn/commit.log

Clients:
svn 1.1.1 on Win32, MacOS X and Linux
svn 1.1.2, 1.1.3 on Win32

Permissions state that all is owned by the svn user
Both Apache and svnserve are run as the svn user

Questions:
- is anyone using the svnserve on Linux with the BerkeleyDB?
        if so, how large is your environment?
      how much activity do you have in terms of commits per day?
- has anyone had problems with svnserve
- has anyone added any logging to their environment and if so how?

Thanks for the help.

--
Peter Kahn
pkahn@connected.com
Connected Corporation,
A subsidiary of Iron Mountain Incorporated
PackReq Described:
http://svn:8080/svn/repos/Welcome_To_SVN/buildFarmTutorial.html#Packager
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org