Hi Rod this primary must be a contraint on a field with has references
to foreign keys this constrained must be dropped first.
Bew carefull do not hack the rdb$indices tables from the "backdoor".
alter index drop index
or alter table drop contstrained xxxx must do it.
keep fingers crossed for you.
Claus

----- Original Message -----
From: rodbracher <rod@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, September 27, 2002 4:43 PM
Subject: [ib-support] Re: Restore crisis


> how do I drop a rdb$primary67 index ?
>
> I get
>
> Unsuccessful metadata update
> ERASE RDB$INDICES failed
> action cancelled by trigger (1) to preserve data integrity
> Cannot delete index used by an Integrity Constraint
> Statement: drop index rdb$primary67
>
> I have dropped all secondary indexes, triggers
> and shutdown the database
>
> what else must I do ?
>
>
> --- In ib-support@y..., Claus Heeg <heeg.c@t...> wrote:
> > 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@e...
> > >
> > >
> > >
> > >Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >.
> > >
> >
> >
> >
> > [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/
>
>
>