Re: "no such revision" revisited

On Wednesday 15 August 2007 00:07, David Chin wrote:
> I just recovered from a disk error, and I keep getting the error message:
>
> svnadmin: No such revision NNN
>
> I read the thread here:
>
> http://svn.haxx.se/users/archive-2004-01/0327.shtml
>
> but my case seems to be different.
>
> Details:
>
> OS: Fedora Core 7 2.6.22.1-41.fc7PAE
> SVN version: 1.4.3 (r23084)
> HTTPd version: 2.2.4-4.1.fc7
>
> My repository is in /opt/repos. If I look in /opt/repos/db/revs, I note
> that there are missing files corresponding to revisions which are
> reported missing: 119, 131, 141-149. The range 150-154 (latest)
> has corresponding files in there.

Okay, so you will have to restore these revisions from a backup.

> If I ask for "svnadmin verify /opt/repos", it barfs on revision 119.
> If I do "svnadmin recover /opt/repos", it ends with "Recovery completed."
> and "The latest repos revision is 154." However, the missing revs
> are still missing.

IIRC recover only deletes locks from an interrupted commit, but that is not
the case here, you have a repository corruption rather, and nothing within
Subversion will be able to recover data that was deleted due to the disk
crash.

> If I try to dump the last available range,
> "svnadmin dump -r 150:154 /opt/repos > /tmp/dump.out" I get:
>
> svnadmin: Can't open file '/opt/repos/db/revs/131': No such file
> or directory

It seems that one of 150:154 is referring to data in 131, which was
corrupted/destroyed. It needs this old revision because it only stores
deltas.

> Anyone have suggestions on how to fix this?

Depends, what kind of backup do you have, a dumpfile or a raw copy of the
repository? If you have a raw copy, you might be able to restore the missing
files, otherwise you will first have to load the dumpfile into a temporary
repository.

> And also how to prevent this occuring?

Use a RAID, although even that doesn't prevent it but makes it possible to
recover from it easier and less likely to occur.

-- 
Sator Laser GmbH
Geschäftsführer: Ronald Boers, Amtsgericht Hamburg HR B62 932
**************************************************************************************
           Visit our website at <http://www.satorlaser.de/>
**************************************************************************************
Diese E-Mail einschließlich sämtlicher Anhänge ist nur für den Adressaten bestimmt und kann vertrauliche Informationen enthalten. Bitte benachrichtigen Sie den Absender umgehend, falls Sie nicht der beabsichtigte Empfänger sein sollten. Die E-Mail ist in diesem Fall zu löschen und darf weder gelesen, weitergeleitet, veröffentlicht oder anderweitig benutzt werden.
E-Mails können durch Dritte gelesen werden und Viren sowie nichtautorisierte Änderungen enthalten. Sator Laser GmbH ist für diese Folgen nicht verantwortlich.
**************************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org