今天遇到奇怪的事：SVN本地代码的标记突然没了，Cleanup也报错

今天遇到奇怪的事：SVN本地代码的标记突然没了，Clean up也报错

脑子一想这种情况，可以先把原来的目录改一个名字，重新把代码check out下来，再合并提交更新，但这样也太LOW了吧

上网上百度了下，发现了两篇文章，提供了解决方案，我的SVN版本为1.8，实践了方法一，果然奏效了！适用SVN低版本的方法二有待各位尝试了！

解决方案如下：

从SVN库更新项目代码，导致SVN状态异常，更新失败。

通过查阅资料，也有偶尔因为提交代码错误导致的类似问题，都需要在问题路径下执行Clean Up命令来清理。
错误如下： 该目录下执行CleanUp命令失败，提示“svn cleanup failed–previous operation has not finished; run cleanup if it was interrupted”，解决办法如下： 方法一： SVN版本1.7+，需要清理根目录下.svn文件夹下wc.db文件中的队列数据记录即可，命令参考如下： 0. 拷贝sqlite3.exe文件到项目文件夹根目录下。 1. cmd命令行定位到项目文件夹下。 2. 执行 sqlite3 .svn/wc.db "select * from work_queue" ，会将block svn正常工作的记录查询出来。 3. 执行 sqlite3 .svn/wc.db "delete from work_queue" ，删除错误数据即可让Clean Up正常工作。 4. 根目录下执行Clean up即可成功。 方法二： SVN版本1.7以下，考虑删除该目录下所有lock文件，命令参考如下： 0. cd 到svn项目目录下。 1. 执行 del lock /q/s 即可删除lock文件。 2. 根目录下执行Clean up即可成功。
英文文档：

Usually, an svn cleanup fixes most issues with tortoise svn. However, I ran into an issue which caused me some grief.

The specific error I was seeing:

Previous operation has not finished; run 'cleanup' if it was interrupted

Solution: Somehow, svn is stuck on the previous operation. We need to remove this operation from it’s ‘work queue’.

The data is stored in the wc.db sqllite database in the offending folder.

1. Install sqllite (32 bit binary for windows) from here

2. sqlite .svn/wc.db “select * from work_queue”

The SELECT should show you your offending folder/file as part of the work queue. What you need to do is delete this item from the work queue.

3. sqlite .svn/wc.db “delete from work_queue*

That’s it. Now, you can run cleanup again – and it should work. Or you can proceed directly to the task you were doing before being prompted to run cleanup (adding a new file etc.)

Also, svn.exe (a command line tool) is part of the Tortoise installer – but is unchecked for some reason. Just run the installer again, choose ‘modify’ and select the ‘command line tools’.