[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

AW: How to check integrity of database?

From: Markus Karg <markus.karg_at_quipsy.de>
Date: 2005-10-05 14:46:41 CEST

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?
 
 
 
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
------------------------------------------------------------
Received on Wed Oct 5 14:51:41 2005

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.