Resolve SVN cleanup error: Failed to run the WC DB work queue associated with

The update failed while updating the folder in the SVN local directory. Then svn prompts me, let me cleanup a bit, so I go to cleanup. The result also failed: Failed to run the WC-DB work queue associated with "catalog/file"

-----Solutions

First, download sqlite3, install. If you have already installed, please start the second step directly. I'm window10.64-bit specific tutorials refer to this: 54574060

Sqlite3 File Download:

1. Download sqlite-dll-win32-x86-3140100

2. Download sqlite-tools-win32-x86-3140100

Installation:

First build a folder in the C drive SQLite,

1. Copy the two files (Sqlite3.def and Sqlite3.dll) extracted from the sqlite-dll-win32-x86-3140100 into the newly created directory (C:\sqlite)

2. Copy the extracted files from the sqlite-tools-win32-x86-3140100 sqlite3.exe to the C:\sqlite directory

3. Add the System environment variable, add C:\sqlite after the value of the path variable (do not forget the semicolon) as shown in:

Next Test whether the installation is complete

Run cmd, switch to the C-packing directory, enter Sqlite3, and then enter, if the installation succeeds, the SQLite version number is displayed, as shown in:

The Ok,sqlite3 is already installed.

Second, start emptying the queue

Step one, empty the SVN queue 1, go to the. SVN directory where you need to clean up the directory to see if the Wc.db file exists

F:\svnClient\188\shengshiDoc\.svn>dir


2018/04/27 09:32 3 entries
2018/04/27 09:32 3 format
2018/04/27 09:33 <DIR> pristine
2018/04/27 09:36 <DIR> tmp
2018/04/27 11:35 4,161,536 wc.db --This file
2018/04/27 11:35 0 wc.db-journal
4 files 4,161,542 bytes
2 directories 29,035,597,824 available bytes

2. Execute the sqlite3 command to view the contents of the WC.DB database

F:\svnClient\188\shengshiDoc\.svn>sqlite3 wc.db "select * from work_queue"
4237|(file-install 113 software/office2013/SW_DVD5_Office_Professional_Plus_2013_64Bit_ChnSimp_MLF_X18-55285/KMSpico_setupActive version.exe 1 0 1 1)
4238|(file-install 95 software/office2013/SW_DVD5_Office_Professional_Plus_2013_64Bit_ChnSimp_MLF_X18-55285/autorun.inf 1 0 1 1)
4239|(file-install 94 software/office2013/SW_DVD5_Office_Professional_Plus_2013_64Bit_ChnSimp_MLF_X18-55285/readme.htm 1 0 1 1)
4240|(file-install 93 software/office2013/SW_DVD5_Office_Professional_Plus_2013_64Bit_ChnSimp_MLF_X18-55285/setup.dll 1 0 1 1)
4241|(file-install 93 software/office2013/SW_DVD5_Office_Professional_Plus_2013_64Bit_ChnSimp_MLF_X18-55285/setup.exe 1 0 1 1)

3. Empty the Work_queue table data and see if it is clear

F:\svnClient\188WC"delete from Work_queue"

4. Empty the Wc_lock table data

Sometimes just emptying the work_queue table data, you have to empty the Wc_lock table data to cleanup success

F:\svnClient\188WC"delete from Wc_lock 

Step two, run the cleanup command

After you run the cleanup command, the interface shown below is displayed, and the cleanup operation can be performed normally.

Step three, run the SVN Update command

After the successful cleanup, the SVN update is run successfully, as follows:

Reference 53082607

Solve SVN Cleanup error: Failed to run the WC DB work queue associated with

Alibaba Cloud Hot Products
Elastic Compute Service (ECS)	Dedicated Host (DDH)	ApsaraDB RDS for MySQL (RDS)	ApsaraDB for PolarDB(PolarDB)	AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL)	Data Transmission Service (DTS)	Server Load Balancer (SLB)	Global Accelerator (GA)	Cloud Enterprise Network (CEN)
Object Storage Service (OSS)	Content Delivery Network (CDN)	Short Message Service (SMS)	Container Service for Kubernetes (ACK)	Data Lake Analytics (DLA)
ApsaraDB for Redis (Redis)	ApsaraDB for MongoDB (MongoDB)	NAT Gateway	VPN Gateway	Cloud Firewall
Anti-DDoS	Web Application Firewall (WAF)	Log Service	DataWorks	MaxCompute
Elastic MapReduce (EMR)	Elasticsearch