Re: [viewvc-users] The root 'XXX' was not found in the commit database

On 01/17/2013 01:33 PM, Dan Peterson wrote:
> So, after updating the DB to match the path listed in the viewvc.conf
> file, everything works.   That is to say everything works with the
> downgraded (1.6->1.5) repository.  The 1.6 repositories still don't work,
> but that's because of the version miss-match which I can understand.

Cool.

> So... now I have a slightly different problem.   While looking more
> closely at the repositories table, I noticed one of the repositories has
> 2 DB entries... one with the path that matches viewvc.conf and one with
> the other (symlink) path.   I can remove the "bad" entry from the
> repositories table, but I'm guessing there could be references in other
> tables.   Is there a correct way to remove a repository from the DB?  Is
> there a tool to remove a repository?  The svndbadmin tool (at least the
> version I have) doesn't seem to have a remove command.

In the version you are running, no, there's no good way to "purge" the
information for a single repository.  (Newer versions of 'svndbadmin' have a
"purge" subcommand for accomplishing this.)  You are correct: the "checkins"
and "tags" tables might have references to that repository's repositoryid.
If I'm reading the schema correctly (founding in the 'make-database'
script), though -- and that's a non-trivially-sized "if" -- the dependency
chain ends there, and you could remove the offending row from "repositories"
plus any rows in "tags" and "checkins" which refer to that repositoryid.

-- 
C. Michael Pilato <[email protected]>
CollabNet   <>   www.collab.net   <>   Enterprise Cloud Development

------------------------------------------------------
http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=3044219

To unsubscribe from this discussion, e-mail: [[email protected]].

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBCAAGBQJQ+HM8AAoJEPXg8AH+aBMzewIQAJVxI+2qaRuiaCO+WTekQtSf
/ylpvXSKvzYP24YPpwZ9/fXwtEzaTt0gj+sEZ+OO0681z2XowdYwuHBaA05vGzRR
u83U/rloLE8B7eZg/KhgluIH9V8Ho5ekFzMgvztasDPBCK+tWj1u700PMChV/ABU
kgSYKGAcDEY4zDknICFWJtsbyFk/GDLYPKKEhIBUlg3+p0VTB3UrTlSdbNsP1iKL
XNG4ipZL5TtKChwgvNPo0cC0uqDEx5lPzGs5NR0zi3l9x0g5iUSwe42MNpFyTYMy
ZIHZswccnUA2eIEL4lx1Y3YcCg9qWBfHl9AgUHXgtO2JtNXqekhfNQR4LlIfrEZa
bFn2PwVnr1Q7Xo9aMURvkKYFlM2sO8evenVfpnc916JffSOUOoNm6AYHON4bRQiU
joAY9M0KvFV4uR9uHlJmLxxoIjlpHL5tTGyfjEFlU326kbW10d1XC3nwzQkKW52/
6k710OhrN3d4G4rHujTPIBJwwxCONOlo5OsrIxomcE7l7yYS6r7u1DKu4mh+RJI1
M1Qq87U/oDpvpGKfXf9hm8IzCXu6i4kvjR+bzPxJ8JCRNpIcWcf5laGORXHhI8/w
V9ND6IIjfsA1+TNTq/V5X4kBweyu+2/XfkEN+Wkf0eJmURWS9/8SyXmojP3f2gD4
y+eNL+PKA6LOu0FO8A5Y
=8Rr/
-----END PGP SIGNATURE-----