Subject Re: [firebird-support] Broken foreign keys
Author Alexandre Benson Smith
Hi Rodrigo

Rodrigo Goncalves wrote:

>
>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
>
>
IB 6.0 has Forced Writes off by default (this causes more problems on
windows than linux), if you restore a DB from a IB 6.0 gbk the forced
writes will be off...

Try to turn forced writes on


FB created databases will have forced writes on by default on windows.

Did you know how forced writes are set in the corrupted DB ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br