Re: AW: How to check integrity of database?

On Wed, 2005-10-05 at 14:46 +0200, Markus Karg wrote:
> I just wanted to know whether this *is* a sufficient check, or not.
> I'm asking this because I have often seen database that worked well,
> but used broken or misleading links internally. This means, never an
> error appeared, but the data shown to the user was screwed. So the
> question is: Does svnadmin verify actually test the FSFS integrity, or
> does it only read each file? If it does the first, I am happy. If it
> does the last, it will not find misleading links. That's why I asked
> for a special FSFS tool but not for a SVN tool. So is there a FSFS
> guru near to answer this?

It does check that every revision can be reconstructed (identical
to dumping the repository without saving the results). I don't see
that anything else is necessary.

>
>
>
> Mit freundlichem Gruss / With kind regards
> Markus KARG, Staatl. gepr. Inf.
> Entwicklung / R & D
> QUIPSY QUALITY GmbH
>
>
> ______________________________________________________________________
> Von: Gary Thomas [mailto:gary@mlbassoc.com]
> Gesendet: Mi 05.10.2005 14:42
> An: Markus Karg
> Cc: SVN Discussion
> Betreff: Re: How to check integrity of database?
>
>
>
> On Wed, 2005-10-05 at 14:38 +0200, Markus Karg wrote:
> > Some relational databases (also Microsoft VSS) come with their own
> > tools to check integrity of the logical database structure (e. g. it
> > might be a page is corrupted etc.). Is there such a tool for FSFS? I
> > mean, can FSFS be broken and how can I detect this as early as
> > possible so I can restore the latest backup before and major loss
> > occurs?
>
> Is this not sufficient?
>
> svnadmin help verify
> verify: usage: svnadmin verify REPOS_PATH
>
> Verifies the data stored in the repository.
>
> --
> ------------------------------------------------------------
> Gary Thomas | Consulting for the
> MLB Associates | Embedded world
> ------------------------------------------------------------
>
>
>
>

-- 
------------------------------------------------------------
Gary Thomas                 |  Consulting for the
MLB Associates              |    Embedded world
------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org