Subject | RE: [firebird-support] Fixing corrupted indexes without restoring |
---|---|
Author | Maya Opperman |
Post date | 2010-06-10T06:06:16Z |
>> I just want to double check that the following is safe to do, andwon't
>> result in users being able to post duplicate keys, if something goesindexes.
>> wrong with reactivating an index for some odd reason:
> It isn't safe and it isn't necessary. Rebuild only corrupted
>For the rest SET STATISTICS is enough.Is there a SQL statement, or a call to GFIX that will tell me which
> Use IBAnalyst or FBDataGuard to watch your DB.
indexes are corrupt?
All I know is my totals don't add up properly till a backup restore, and
validating the database shows me X number of indexes are corrupt.
This is happening at about 5 sites that I know of, at east once a year,
sometimes once a week at the busy sites, both FB 1.5, and FB 2.1
It might be due to network disconnections - looking at their logs, that
has been happening.
I plan to try get some of the more problematic sites on to FB2.5, but I
see from a post here in the past month, that FB2.5 still has some
unexplained index corruptions... so I'm sticking to the devil I know
just a little bit longer...