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

DB Crash - Wedge

From: Peter Kahn <pkahn_at_connected.com>
Date: 2005-04-13 18:32:42 CEST

Hi, looks like SVN had an issue again. I hope that 1.2 fixes whatever
bug is being exposed because this is very troubling.

Every so often my repository becomes in accessible with this error:
        svn: Berkeley DB error while checkpointing after Berkeley DB
        for filesystem /home/svn/repos/db:
        DB_INCOMPLETE: Cache flush was unable to complete

I remedy this by using svnadmin recover. I actually run it via a simple
script like this:
        date >> $LOG
        svnadmin recover repos >> $LOG 2>&1
        date >> $LOG

This time it took less than a minute. Usually, it takes about 2 hours
(sometimes it takes 16 hours). Still, I'd like to avoid the problem.

Looking through my hook script logs I can tell who was the last user to
check-in. It was a doc person who uses tortoise. She said that did
the following:
        1. created a new directory
        2. right click - TortoisSVN Add directory
        3. click and drag to move files from one location to the new
        4. she noticed a few files that had been moved could be deleted,
so she
                did a right click - TortoisSVN Del on each of these
        5. she committed

What I see in my commit logs is a check-in from her which about 16
modified files, but no moves or deletes. When I look at a copy of her
workspace, I do not see a record of this kind of change either.

Any ideas on what is a reasonable course of action? I was going to
attempt to replicate the situation on a backup copy of my database, but
that does bring in many variables because I cannot get back to the same
state that the db was in prior to the issue. My other possibility is to
write an additional pre-commit hook to analyze the check in prior to
processing and record this information in a log.

Environment: Server

OS: Linux 2.4.20-8
svn: version 1.1.2 (r12471) compiled Jan 21 2005, 10:09:03
Access: http - WebDav readonly
                 svnserve - read write
Automated Tasks - hotbackup daily, db_stat -m -h every 10 minutes

Environment: Client

OS: WinXP Professional, SP1

SVN Installation: version 1.1.3 (r12730) compiled Jan 20 2005,

TortoiseSVN 1.1.3, Build 2502, UNICODE
    Subversion 1.1.3,
    apr 0.9.5
    apr-iconv 0.9.5
    apr-utils 0.9.5
    berkeley db 4.2.52
    neon 0.24.7
    OpenSSL 0.9.7e 25 Oct 2004
    zlib 1.2.2


Peter Kahn
Iron Mountain Digital
Received on Wed Apr 13 18:36:44 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.