svn 1.7.8 database is locked, cannot release
SvnSvn Problem Overview
when I run:
svn cleanup
I get the error message:
svn: E200033: database is locked, executing statement 'RELEASE s0'
or any other command to change DB, e.g. commit, update etc.
This is on linux server, the directory is nfs.
I can checkout another version and copy my changes, but it is a hassle and I think this error will come back.
how do I fix this on a working directory, and is there a way to prevent it.
p.s. there are no processes currently running, maybe eclipse crashed in the middle of some action.
Svn Solutions
Solution 1 - Svn
This helped me solve the problem (subversion 1.7.10):
$ cd /my/repository/.svn
$ mv wc.db wc.db.old
$ sqlite3 wc.db.old
sqlite> .backup main wc.db
sqlite> .exit
After making sure it works, you can remove wc.db.old.
See also: http://technosophos.com/content/sqlite-database-locked-error-and-unlocking-database
Solution 2 - Svn
In windows I killed the process TSVNCache.exe and that helped me.
Solution 3 - Svn
may be sometimes svn keep running in the IDE(if svn configured in IDE) and locks the svn files. close your IDE and then perform clean up. or use simple way restart your pc and then perform cleanup.
Solution 4 - Svn
Following steps worked for me.
- Close all the files open for that repo in the other notepads/eclipse
- run svn cleanup
- run svn up.
Solution 5 - Svn
Use
svn resolved -R .
If you still see issues, go one level up and execute the same command.
Solution 6 - Svn
In ubuntu system try following commands.
ps -efa | grep 'svn'
7792 15593 0 14:10 pts/3 00:00:03 svn status
it will list down all running processes of SVN. Kill svn process that is currently running.
Kill -9 7792
Try after kill process it will work.
Solution 7 - Svn
If you are tagging and releasing through NetBeans
Please change the path to the installed svn in your IDE
Solution 8 - Svn
Resolved my issue by closing IDE like netbeans/sublime.
Close IDE and again do pull request.
Please try this solution.
Solution 9 - Svn
None of the above worked for me on a Windows system, I had to restart the SVN service to clear the lock on the database and then run a clean-up on the branch and all worked fine then.
Solution 10 - Svn
How I fixed this problem for me was that I re-installed TortoiseSVN version 1.9.2. In the process of doing this I had to shut down the processes for Explorer, Eclipse (using the svn workspace), TortoiseSVN, SQL Dev, Notepad++...
So maybe it was something with restarting these processes that fixed the problem, or reinstalling TortoiseSVN.
Solution 11 - Svn
Updated visual code IDE block this svn update. so close the vs code. and its work.
Solution 12 - Svn
I am using netbean windows version. I try to right click the root folder->subversion->working copy->cleanup. It doesn't work. I saw above command "svn cleanup" but the in Windows, don't have this command line. What I do I download the tortoisesvn from https://tortoisesvn.net/downloads.html, install it with the "Commandline client tools" during installation. After installed, you can run "svn clean" in your root folder (make sure your netbean ide is closed), then everything work fine.
Solution 13 - Svn
I had same trouble here on windows 10.
Working in selenium tests, when I try to commit my changes, the SNV shows the error: Database is locked.
I have executed svn cleanup and still no working.
So, I opened the windows task manager (ctrl + shift + esc) and I saw some chromedriver.exe process still running. I killed all of them and executed svn cleanup again and this worked!
Solution 14 - Svn
I kill TortoiseProc.exe process in windows