Home / server / Questions / 697804
In Process
Prashant Lakhera
Asked: 2015-06-10 14:54:52 +0800 CST

SVN Checkin Failure(sqlite[S5]: database is locked)

  • 772

I am facing this issue intermittently when I am trying to check-in files 

svn ci -m "commit message" file
Warning: post commit FS processing had error:
sqlite[S5]: database is locked 

Some more info
Server side OS --> Centos6.5 and svn version 1.8.5 
Client Side OS --> Centos 5.11 and svn version 1.7.7

I already check some forums and these are the suggestion but it doesn't resolve my issue

1: Check server load(Server is fairly idle when I faced this issue..checked load average,IO and memory utilization)
2: There is a longer commit is in progress at that time
3: Both server and client are in same geographic location

As the error is intermittent and I checked svn repo file is there(i.e file checked in properly)so I am not sure what is the issue.Any help is really appreciated.

svn

3 Answers

  1. I believe this is a client side, and not server side error, based on your comments it seems you are using file based svn, so the only database that can be locked is on the client.

    Try this

    $ cd /my/repository/.svn
$ mv wc.db wc.db.old
$ sqlite3 wc.db.old
sqlite> .backup main wc.db
sqlite> .exit

    now you have a new wc.db that should not have any locking errors

    If it all works OK, delete wc.db.old

    If not you can always

    $ mv wc.db.old wc.db

    and you will be right back where you stated before I Posted this .....

    but it should work ....

    • 6

  2. In case you use symbolic links on your file system, note that SVN can get confused as well.

    My local SVN directory is a actually directory symlink to the real local SVN repo folder.

    Let's see how this can go wrong while moving files for instance:

    In order to move a file with turtoise svn you can cut (CTRL-X) the files using Windows explorer first, then select Paste from the turtoise SVN context menu.

    Normally a SVN popup appears and SVN will move your files inside the repo. However now the "database is locked" messsage appears.

    What happened?

    Well, upon further inspection, it turns out the directory path changes while I am navigating around in explorer from the 'source' directory to the 'destination' directory of the move.

    The reason is the symlink.

    When first navigating to the 'source' directory of the move (via the directory symlink), the path is still showing with the symlink name. So far, so good.

    But when I navigate to the 'destination' directory, Windows explorer seems to resolve the symlink all of a sudden. Now the path looks different in the address bar.

    This seems to confuse SVN, it now probably thinks there are two different repos and the files are being moved from one repo to another?

    • 0

  3. I faced the same issue. For me, it was because the project folder was inside OneDrive and OneDrive was syncing the same folder. When I stopped syncing OneDrive and closed it, things were resolved. I hope this helps

    • 0