Hi,

> Probably you have broken/corrupted indices, that left orphan recods.
>
> What you could now do is;
> 1.) Drop you FK;
> 2.) Search for the orphan records and delete then or update then to a
> dummy parent record;
> 3.) Recreate your FK
> 4.) Make a back-up and restore it to somewhere else, so you don't risk
> to lost your "working" database

This has already been done (deleted the wrong records, and a database
backup/restore). What puzzles me is how this happened.

The OS is Linux (MDK 9.1 and RH 9) running on one case Interbase 6 and
in the other two cases Firebird (1.5). All of them in their respective
latest releases.

Anyway, thanks for answering. We're trying some tests (turning down the
machine while running operations involving FKs) to see if we can
reproduce the problem, but no success till now.



Tks
Rodrigo

>
> But the most important task is try to know why the indexes get
> corrupted...
>
> What version of FB, what OS ?
>
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://us.ard.yahoo.com/SIG=129bcn4j4/M=298184.5022502.6152625.3001176/D=groups/S=1705115386:HM/EXP=1088109278/A=2197946/R=0/SIG=11elgumq7/*http://www.netflix.com/Default?mqso=60183367>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

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