Subject Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version
Author Lester Caine
Helen Borrie wrote:
>> I had thought that caching of write data in windows had been sorted, but I'm not
>> >entirely surprised if just some block of data has been lost.
> I believe the OP mentioned that they were using Fb 2.1.3. That's almost three years old now and two sub-releases out of date. I suspect the moves to improve the caching behaviour on Windows came more recently.
Actually I was referring to Windows itself rather than Firebird, but the
improvements in FB were done because of this sort of problem.

>> >If it was one of my sites I'd drop a new machine in just to prove a point ...
> The system log reports of disk corruption are suspicious...but they don't account for lost generator values. If the generator page was actually written to a corrupt block, I'd expect the page to be kaput and to see other evidence of corruption. It seems more likely the page write was lost when they had that power failure.
> I wonder whether anyone has checked to see whether Forced Writes is off. If so, the chances of pending writes disappearing on a power outage would be high.
Again Windows seems to be a little too cleaver at times. While it may have
reported a failed write, it still works as if the cached data has been written?
Even with Forced Writes on :(

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -