Recreating SVN wc.db

Question

Some of our development teams have had issues with their working copies and it appears that the wc.db database is corrupt. Is there a quick way to repair or rebuild the database instead of doing a fresh checkout?

The error message I get is "no such table: wcroot", and the OS is Windows 7 and using TortoiseSVN 1.7.6.

Even though this is a specific error, what is the best option when the SQLite database gets corrupted besides doing a full checkout?

Solution 1

SmartSVN proposes a tool that repairs some kinds or wc.db corruption (Modify|Validate admin area), retrieving missing/incorrect information from the repository. I'm not sure it will help, but just try.

Solution 2

Simple, just downgrade.

There is absolutely no logic in putting all your metadata into an SQLite database; Subversion developers are not that bright. Previously, you had .svn files spread across your checkout ... a .svn folder gets screwed; it happens occasionally. Simple: rename, check it out again, merge local changes - with Subversion 1.7 the solution is to "please check out the 10G again".

If you have a big project, like I do (more than 10 GB), and you cannot afford to check out the whole stuff on a monthly basis, downgrade Subversion.