I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

"reached end of file error"

"reached end of file error" in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: "reached   error"   "reached end   "reached end of   file error"  
Phoenix
 (Inactive)
Philippines
This error message appears on multiple database in Interbase when trying to open the database. Please help!
 Posted 19 years ago (Thread Starter)
Comment Quote
About Phoenix -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #7491, 1 replies
Thread Started 9/10/2002 10:50:00 PM
View Counter=2507
Last Reply Posted 9/20/2002 6:27:00 AM)
Location=Philippines  
Joined=19 years ago   MB Posts=1  
Most Recent Post
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Well, one of three things has probably happened:



1.) The database files themselves have reached the 4GB limit. If this is the case, you're going to need to extend the databases with another database file (the InterBase help on altering databases has a very clear example of how to do this).



2.)You could have two different clients connecting to the database using different connect strings. This causes the server to see the database file as two different databases, and the database file gets corrupted.



For example, these two connect strings look like the same connection, but the server sees them as different databases:

c:\data\main.gdb
c:data\main.gdb


3.)There is a transaction in limbo that wasn't written correctly to the transaction page. There is only one way to clear this up - either restore the database file from the last good backup, or try backing up with the Ignore transactions in limbo setting turned on, then restore the database. In restoring, always make sure that you set the page size to the same value as the existing database file. If you don't know what it is set to, look for the Page Size setting on the database's properties.
 Posted 19 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #7624 (Level 1.1)  Reply to 7491
Thread Started 9/20/2002 6:27:00 AM
View Counter=2
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1181A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #7491 Counter
2507
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech