Subject Re: [firebird-support] Server failed (power) and clients stayed up
Author Helen Borrie
At 04:38 AM 9/09/2004 +0000, you wrote:
>Immediatly after I received a KeyViol complaint and found the the
>generator was delivering numbers less that max(Table.Id).
>A week or so later received same fault report on another table.
>Would this indicate that forced writes were off?

Even if forced writes were off, once a generator value has been delivered,
it can't be delivered again, regardless of what happens to writes in the
disk cache. I would rather look for (and kill) an application or a trigger
that is messing about with values that you expect to be delivered by the
generator - esp. those those that select max() and add 1; or read
gen_id(aGen, 0) and add 1. Those are your integrity-killers.