Re: File in repo but wont check out

Philip Martin <philip.martin_at_wandisco.com> writes:

> Andy Colson <andy_at_squeakycode.net> writes:
>
>> $ svn co svn://marajade/counties2/8.0/htdocs/img/phelpsmo
>> A phelpsmo/GISLogo2.png
>> A phelpsmo/PCATransparent.png
>> A phelpsmo/SignExample.jpg
>> A phelpsmo/Courthouse.jpg
>> A phelpsmo/Phelps.gif
>> A phelpsmo/hsbillw.jpg
>> A phelpsmo/GISLogo.gif
>> A phelpsmo/doorhanger.jpg
>> U phelpsmo
>> Checked out revision 1394.
>>
>> So that worked. I guess that helps me be sure it is actually in the
>> repo, but I'm not sure what it means.
>
> In the broken working copy run
>
> sqlite3 .svn/wc.db "select * from nodes where local_relpath like
> '%Courthouse.jpg'"
>
> to see what working copy has for the path.

If the above command produces no output then one possibility is that a
Subversion bug has caused the working copy to lose track of the path.
If that is the case there are various things you could do to repair your
working copy.

A)

If you can afford to lose all the contents of phelpsmo/ then do

  svn up --set-depth empty phelpsmo
  svn up --set-depth infinity phelpsmo

B)

If you can identify the revision in which Courthouse.jpg was added to
the repository then updating phelpsmo/ to that revision will attempt to
delete the file and will produce an error. The error will leave the
phelpsmo/ directory marked 'incomplete' and then a second update to HEAD
should restore the missing file. Of course the first update will bring
other changes for that revision some of which may be unwelcome.

C)

Warning: the following could break your working copy.

You may be able to fix your working copy by manually marking the
directory 'incomplete'

sqlite3 .svn/wc.db "update nodes set presence='incomplete' where local_relpath='the/path/to/the/phelpsmo'"

where 'the/path/to/the/phelpsmo' is relative to the working copy root.
A subseqent update should restore the missing file.

-- 
Philip