Subject Re: [firebird-support] Re: Unique Constraints being violated in Firebird
Author Ann W. Harrison
Adam wrote:
> If Firebird happens to write the data to the data page before
> populating the index page (is this possible??) and there is a problem
> such as hardware failure before the index is updated then I can see
> this happenning.

The problem with that theory is that the failure would have prevented
the transaction that entered the bad value from being committed. An
uncommitted duplicate would not cause an error.

How big is the database file? Unfortunately, the backup won't have
any clues as to how the failure happened.