Hi Rod,

if I were in your shoes, I d take orig. database find the primary
indexNr 67 and drop this index and restore it again.

after having a restore database i wd try to first find duplicates and if
none then create the index again.
I keep fingers crossed for you for ten years we had not such an gbak error.
yours
Claus



rodbracher wrote:

>OK I'm not crazy !
>
>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
>gbak: ALTER INDEX "RDB$PRIMARY67" ACTIVE;
>
>As a result all my relations are empty - I'm doing a gbak restore
>with -inactive as I type. But at least I know now this really can
>happen !
>
>--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
>
>>you start all this with the finding of checksum errors
>>is there some process where the gdb files are being copied
>>
>(backedup) or
>
>>restored after copying? these site to which you refer - are they
>>
>all windows
>
>>or unix?
>> -----Original Message-----
>> From: rodbracher [mailto:rod@m...]
>> Sent: Friday, 27 September 2002 17:15
>> To: ib-support@y...
>> Subject: [ib-support] Re: Restore crisis
>>
>>
>> No - but it still pops up with checksome errors at random times.
>>
>> --- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
>> > Rod,
>> >
>> > I hope you didn't do a restore that replaced the current
>>
>database?
>
>> >
>> >
>>
>>
>>
>> Yahoo! Groups Sponsor
>> ADVERTISEMENT
>>
>>
>>
>>
>> To unsubscribe from this group, send an email to:
>> ib-support-unsubscribe@e...
>>
>>
>>
>> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>>
>Service.
>
>>
>>
>>[Non-text portions of this message have been removed]
>>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>.
>

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