Re: svn client hangs on db access

Jim Blandy wrote:
>
> Peter Schuller <peter.schuller@infidyne.com> writes:
> > all of a sudden when I was going to do an "svn update" today svn started
> > hanging. I can do "svn status" but not an "update". Probably becauset he
> > former is local. I did a strace and got:
> >
> > open("/home/infidyne/svn/db/__db.001", O_RDWR|O_LARGEFILE) = 3
> > fcntl64(0x3, 0x2, 0x1, 0x2) = 0
> > mmap2(NULL, 8192, PROT_READ|PROT_WRITE, MAP_SHARED, 3, 0) = 0x40133000
> > close(3) = 0
> > select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
> > select(0, NULL, NULL, NULL, {0, 2000}) = 0 (Timeout)
> > select(0, NULL, NULL, NULL, {0, 4000}) = 0 (Timeout)
> > select(0, NULL, NULL, NULL, {0, 8000}) = 0 (Timeout)
>
> Try:
> - shutting down your server
> - su to the user who owns the repository
> - cd to the `db' subdirectory of the repository
> - run db_recover -ve (make sure to use the db_recover that comes with
> the version of Berkeley DB that you built Subversion itself with)
> - restart the server
>
> > Looks like it's waiting on a db lock.

Did you run a lot of other commands on the repository?

I saw one of these on my repository and running

db_recover -ve -h

didn't work, it would just hang forever. However, running

db_recover -v -h (without the -e)

did work, but then you loose your __db* files, and then I believe
ra_local or mod_dav_svn can't open the db.

The only way out for me was to restore from the last hot backup. I
would make sure you run hot-backup.py.

By the way, I sent this to Sleepcat and all they've found so far
was that not using -e got the db_recover to finish.

Best,
Blair

-- 
Blair Zajac <blair@orcaware.com>
Web and OS performance plots - http://www.orcaware.com/orca/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org