Ethan Bradford <ethan.bradf...@swype.com> writes: >> sqlite3 .svn/wc.db "select * from work_queue" > > 3|(file-install 59 > DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED] 1 0 1 1) > >> sqlite3 .svn/wc.db "select * from nodes where > local_relpath='DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]'" > > 1|DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]|0|DBBuild/Wordlists/Belarusian|1|Trunk/DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]|3936|normal|||file||infinity|||3323|1294867663142001|Erik.Larsson|504|1294985508149158|| > > So there's no checksum (according to other entries, it would be the field > just after "infinity").
That's very odd. Do you know which version of Subversion is running on the server? Running something like "curl -D - REPO_URL" might help find out. Are there other files with no checksum? sqlite3 .svn/wc.db "select count(*) from nodes where checksum is null and kind='file'" If there are other files then is there any pattern in the filenames? All in the same directory? All modified in the same commit? etc. sqlite3 .svn/wc.db "select local_relpath from nodes where checksum is null and kind='file'" Can you describe the recent activity in the working copy? Do you normally update the whole working copy or do you update subtrees? Did you commit changes in the Belarusian directory just before the update? The NODES row shows that the update was trying to install revision 3936 of the file. The filename is "BelarusianForceFreq.txt[MOVED]"; has this file been moved/copied within the repository? The last modified revision of the file is 3323, would you have committed that revision from this working copy? Do you know the revision before the update? It's possible that you can identify it using sqlite3 .svn/wc.db "select revision from nodes where revision != 3936" or perhaps sqlite3 .svn/wc.db "select revision from nodes where parent_relpath='DBBuild/Wordlists/Belarusian'" or perhaps you can guess the approximate revision based on dates? If you can identify the (approx?) revision before the update then running "svn log -vq URL" will allow you to see the sort of changes the update would have been making. I want to know what the update did to this file, did it just modify the content of the file, or add the file, or replace another file of the same name? Perhaps the whole directory was being added? Thanks for your help so far! -- Philip