E200033: Another process is blocking the working copy database

Question

When I checkout from repository

sudo svn co --username me http://192.168.1.27/svn/project

I got the this error and checkout process terminated

svn: E200033: Another process is blocking the working copy database, or the underlying filesystem does not support file locking; if the working copy is on a network filesystem, make sure file locking has been enabled on the file server 
svn: E200033: sqlite[S5]: database is locked 
svn: E200042: Additional errors: 
svn: E200033: sqlite[S5]: database is locked

I am unable to get checkout or update for this project (no cleanup, update, etc command working after getting error).

score 18 · Accepted Answer · answered Aug 23 '17 at 04:01

18

Follow the below steps:

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

Afterwards, do a svn cleanup.

svn: database is locked, executing statement 'RELEASE s0'

answered Aug 23 '17 at 04:01

Mohd Bashir

949
1
8
17

The command ".backup main wc.db" resulted in :"Error: databse is locked" for me. – Eliezer Miron Feb 16 '21 at 21:09

score 16 · Answer 2 · answered Aug 05 '18 at 09:26

16

If you are using Tortoise-SVN, sometimes it can go brain dead and the caching functionality gets stuck. Go into Task Manager and kill all instances of TortoiseSVN-Cache and try again.

answered Aug 05 '18 at 09:26

James John McGuire 'Jahmic'

11,728
11
67
78

This was it for us; we have the client installed on a build server that is wound in an extremely tight loop for checking for modifications and every so often we'd get this error. Because we did not care about Icon Overlays we disabled them completely for the build server. – aolszowka Nov 09 '18 at 22:20
For me it helped killing instances of both TSVNCache.exe and TortoiseProc.exe – Asu Feb 15 '23 at 17:53

score 13 · Answer 3 · answered Nov 09 '17 at 06:12

13

Close all the files opened in the editors and run the clean up. It fixed the issue for me. I closed my Netbeans and executed the clean up command.

answered Nov 09 '17 at 06:12

Kiren S

3,037
7
41
69

1

yes, closing netbeans solved the issue for me. Even when the project was closed from netbeans. – Sarah Tammam Sep 17 '18 at 10:24

score 2 · Answer 4 · answered Aug 22 '17 at 10:48

2

The internal working copy SQLite database is blocked (its in your working copy's hidden metadata pristine store: .svn/wc.db file). I'd start with checking your user account permissions. There is a great chance that you lack write access to the checkout target location.

It could be another SVN client instance that's by some reason is still running tasks with the WC. An antivirus or indexing service could also be the root cause -- it is a general recommendation to add antivirus and indexing exceptions to ensure that these tools do not touch the working copies.

answered Aug 22 '17 at 10:48

bahrep

29,961
12
103
150

How to deal with it? Any solution? @bahrep BTW, I am using Ubuntu, no need antivirus client – Ravee Sunshine Aug 23 '17 at 03:50
@RaveeSunshine *permissions* – bahrep Aug 23 '17 at 07:00

score 1 · Answer 5 · answered Jul 24 '19 at 15:48

1

Simple SVN clean up worked for me !!

answered Jul 24 '19 at 15:48

Gentleman

130
1
8

score 0 · Answer 6 · answered Dec 27 '18 at 13:54

0

are you using matlab? if yes, go to preference->general->source control then select no.

answered Dec 27 '18 at 13:54

shinxg

490
4
9

score 0 · Answer 7 · answered Aug 13 '19 at 19:28

0

I was trying to checkout into a networked drive, and had this issue. Once I moved my target checkout location to somewhere local, this issue disappeared. Then I could just copy the files into the networked location where I wanted them.

answered Aug 13 '19 at 19:28

Eliezer Miron

388
5
18

E200033: Another process is blocking the working copy database

7 Answers7