Subject RE: [ib-support] Corrupt GDB - Re Restore Crisis
Author Alan McDonald
do you mean the file was just copied?
out of interest were there connected users at the time of copying?
-----Original Message-----
From: rodbracher [mailto:rod@...]
Sent: Monday, 30 September 2002 21:38
Subject: [ib-support] Corrupt GDB - Re Restore Crisis

All is fixed - thanks to everybody's responses. I am just going to
post a summary of what happened - as if I had read this before my
crisis it would have been useful.

I had a corrupt GDB. A validate would give messages like :

PROG1 (Server) Sat Sep 28 13:48:14 2002
Index 11 is corrupt (missing entries) in table WAYBILL (197)

PROG1 (Server) Sat Sep 28 13:48:15 2002
Relation has 1 orphan backversions (0 in use) in table

I did a backup and restore - all the records were reported there -
but all tables were empty ! The crux was when I discoverd the all
useful -y restorelog.txt switch for GBak. At the end of the restore I
got :

gbak: creating indexes
gbak: ERROR: attempt to store duplicate value (visible to active
transactions) in unique index "RDB$PRIMARY67"
gbak: Index "RDB$PRIMARY67" failed to activate because:
gbak: The unique index has duplicate values or NULLs.
gbak: Delete or Update duplicate values or NULLs, and activate
index with

When I tried to activate the index in IBConsole I got the above same
error. There were no key duplicates in the orig GDB - so I did a
backup-restore but using the -inactive switch on the GBak restore.

Now I had data in my tables. And a query

Select key_field, count(key_field) from table
group by key_field
having count(*) > 1

retuned 4 records.

So back to the orig GDB - I deleted the records ( the ones I could
see ) - and another backup and restore with indexs active worked -
and my database had no validation errors.

Now in the new GDB the other records on the key were there - which I
could delete.

Strange but true.

The corruption was caused by a transfer of the GDB from 1 server to
another - not good.



To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]