Subject | Re: [firebird-support] DB Corruption |
---|---|
Author | Ann W. Harrison |
Post date | 2005-03-17T16:59:51Z |
Trinidad Miravet Celades wrote:
forced write turned off in the Firebird configuration file, the message
is not unexpected. Windows does not write cached pages until the file
is closed. Reading beyond the end of file give Firebird a page of all
zeros. All pages have a "checksum" of 12345 that is the first thing
checked after the page is read. A page of zeros announces itself as a
checksum error.
If you think you need to run with forced writes off, get an
uninterruptable power source.
Regards
Ann
>If you had an earlier power failure and were running on Windows and had
> Database: XXX
> I/O error for file "XXX"
> Error while trying to read from file
> Se ha alcanzado el final del archivo.
>
> .... one minute after ....
>
forced write turned off in the Firebird configuration file, the message
is not unexpected. Windows does not write cached pages until the file
is closed. Reading beyond the end of file give Firebird a page of all
zeros. All pages have a "checksum" of 12345 that is the first thing
checked after the page is read. A page of zeros announces itself as a
checksum error.
If you think you need to run with forced writes off, get an
uninterruptable power source.
Regards
Ann