Svn error "Previous operation has not finished"

I tried the top solution by Sigurd V, but the SELECT query gave me errors. I'm using SVN 1.9.2 and SQLite 3.13.0.

To clarify, the file to download from SQLite site is "sqlite-tools-win32-x86-3130000.zip(1.51 MiB)"

Here is what I did with help form our software eng:

1. download this zip and copied sqlite3.exe into my working copy folder
2. in cmd line, connect to the svn database in this folder: sqlite3.exe .svn/wc.db
3. type command to SQLite to show what's locked up: sqlite> select * from work_queue;
4. type command to SQLite to delete the requests: sqlite> delete from work_queue;
5. repeat step3 to check nothing is locked.
6. everything is back normal now!

Screenshot showing step3/4/5:

'svn cleanup' worked for me. You might need to run this as Administrator.

I tried all the solutions listed in this page, but my problem still didn't work out.

I solved it by another way. Just in case some still didn't get a solution, try this (I'm using TortoiseSVN 1.9.5):

1. Click "Clean up..." as usual and open cleanup popup

2. check "Break locks"

3. click "OK" button to execute

Actually just found the answer to my question by looking here

It seems that svn was stuck in the old operation. All of these operations are stored in the database wc.db in the .svn folder.

By downloading SQLite to my checkout directory and running

sqlite3.exe .svn/wc.db "select * from work_queue"

from cmd

i got a list of all pending operations. These operations are the ones "not finished" then by running

sqlite3.exe .svn/wc.db "delete from work_queue"

all of these pending operations are deleted and i can commit again. No need for a re checkout or anything