Subject Re: [firebird-support] RE: Reached end of file error - Interbase 5.6
Author Johannes Pretorius
Thank you Ann. This is a lot of help and we will look into this immediatly !!

Once again thanks

Johannes

At 00:14 05/01/2006, you wrote:

>Johannes,
>
> The "reached end of file" error can occur after a crash
>on Windows systems that don't have forced writes turned on.
>By default, Windows caches all changes until the file is
>closed, so the chances of losing newly created pages in the
>database is quite high. If one of the older pages references
>an unwritten page, the result is "Reached end of file".
>Firebird avoids that problem in two ways. First, by default,
>databases are opened with forced writes enabled. Second,
>in V1.5, when forced writes are disabled, the cache is flushed
>on a regular schedule that you can adjust in the firebird.conf
>file.
>
> That's what happened. What can you do now? Restore from
>a backup, turn on forced writes, and rerun the intervening
>activity, or contact ibsurgeon.com - they can create the missing
>structural pages for you.
>
>Regards,
>
>
>Ann
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 04/01/2006


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 04/01/2006