Subject Re: [firebird-support] RE: Reached end of file error - Interbase 5.6
Author Johannes Pretorius
Thank you Gary , we will do this as a safety measure.

Can you please give me the google search string you used. Maybe it will help
me in the future to find this out without botherting you.

Yours Sincerely

Johannes Pretorius


At 11:57 AM 04/01/2006, you wrote:

>>>Please forgive if this was asked before. I have searched google and
>>>ibphoenix so far
>>>but I don't really get a answer on this.
>>>
>>>We are running Interbase 5.6
>>>Database size : 1.5 gb
>>>Network protocol : Tcp/IP
>>>Max users : 15
>>>
>>>We have a database that has started giving funny reached end of file
>>>errors. We first thought it might be
>>>related to named pipe's protocol, but this is not used on the network.
>>>
>>
>> What are you actually doing when you get an End of File error? Trying to
>> restore a database? The only InterBase error that I know of that has the
>> words "end of file" in the message is isc code 336330802
>> gbak_unexp_eof "Unexpected end of file on backup file".
>>
>
>A quick scan of the interbase.msg file shows a couple of errors related to
>'end of file' that are not related to backups, so getting this message
>during normal database use is possible and probably related to a hardware
>failure of some sort. Google says that this can happen when a sector
>containing critical structures is damaged. My advice is to replace your
>drive asap, or switch to a RAID volume. It could of course also be related
>to a controller board failure, or corrupted drivers/OS. You were very lucky
>to be able to recover the database without data loss.
>
>HTH
>Gary
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>