Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: cannot find tip page



Permlink Replies: 3 - Last Post: Oct 5, 2015 11:18 AM Last Post By: Aage Johansen Threads: [ Previous | Next ]
Arek W.

Posts: 8
Registered: 2/19/00
cannot find tip page
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 3, 2015 9:09 AM
Today our XE7-IBServer generates the following Error:

	internal gds software consistency check (cannot find tip page (165), file: tra.c line: 4022)
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "D:\DATABASE\DB.GDB"
	Error while trying to access file
	Das Handle ist ungültig. 
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "D:\DATABASE\DB.GDB"
	Error while trying to access file
	Das Handle ist ungültig. 
	internal gds software consistency check (attempt to release block overlapping prior free block (156), file: all.c line: 1790)
	internal gds software consistency check (attempt to release free block (154), file: all.c line: 1734)
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "4" <----- Does IB forgotten the Filename of the Database?
     ^^^^^^^^^^^^^
	Error while trying to access file
	Das Handle ist ungültig. 
	internal gds software consistency check ( free block (154), file: all.c line: 1734)
	internal gds software consistency check ( all.c line: 1734)
 


Then the IBServer does not responds.

After killing the IBServer-Process i have start gfix -v -f with the following Error:

Page xxxxx is an orphan


Now i'm a little confused. What is here wrong. Can somebody help?

Regards

Arek
quinn wildman

Posts: 856
Registered: 12/2/99
Re: cannot find tip page
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 5, 2015 9:00 AM   in response to: Arek W. in response to: Arek W.
This all means something has gone wrong with your database. Here is what
you should do:

1. Pray.
2. Mend your database.
3. Try to backup and restore your database. If that works, you are home
free.
4. If steps 2-3 do not work, going to a backup of your database is your
best alternative.
5. If you don't have a backup of your database, I recommend
www.ib-aid.com. They are the experts at recovering databases.

I did run across this problem myself with one database. It was an ODS 15
database, which means it was created with InterBase XE3. Using the
database with XE3 worked fine, but caused this error with XE7. So, if
this is an ODS 15 database and you using it with XE7, then going back to
XE3 might help too.

Arek W. wrote:
Today our XE7-IBServer generates the following Error:

	internal gds software consistency check (cannot find tip page (165), file: tra.c line: 4022)
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "D:\DATABASE\DB.GDB"
	Error while trying to access file
	Das Handle ist ungültig.
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "D:\DATABASE\DB.GDB"
	Error while trying to access file
	Das Handle ist ungültig.
	internal gds software consistency check (attempt to release block overlapping prior free block (156), file: all.c line: 1790)
	internal gds software consistency check (attempt to release free block (154), file: all.c line: 1734)
 
	Database: D:\DATABASE\DB.GDB
	I/O error for file "4" <----- Does IB forgotten the Filename of the Database?
      ^^^^^^^^^^^^^
	Error while trying to access file
	Das Handle ist ungültig.
	internal gds software consistency check ( free block (154), file: all.c line: 1734)
	internal gds software consistency check ( all.c line: 1734)
 


Then the IBServer does not responds.

After killing the IBServer-Process i have start gfix -v -f with the following Error:

Page xxxxx is an orphan


Now i'm a little confused. What is here wrong. Can somebody help?

Regards

Arek
Arek W.

Posts: 8
Registered: 2/19/00
Re: cannot find tip page
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 5, 2015 9:38 AM   in response to: quinn wildman in response to: quinn wildman
Hi Quinn,

thank You for Your Response.

Since Interbase 2009 i have to pray every day, because the Server Engine seems to be not very stable.

I'm confused because after killing IB and restart, the Server runs fine. And the only Error after gfix was the "orphan pages"-Error. This seems to be a not serious error, right? A Backup running fine without any Errors.

A Restore is a little bit difficult, because the Database is round about 100GB. So i have to wait until the next Weekend.

The question is, was this error a Server Error or a Database File Error.

Regards

Arek
Aage Johansen

Posts: 23
Registered: 9/27/00
Re: cannot find tip page
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 5, 2015 11:18 AM   in response to: Arek W. in response to: Arek W.
On 05.10.2015 18:38, Arek W. wrote:
Hi Quinn,

thank You for Your Response.

Since Interbase 2009 i have to pray every day, because the Server Engine seems to be not very stable.

I'm confused because after killing IB and restart, the Server runs fine. And the only Error after gfix was the "orphan pages"-Error. This seems to be a not serious error, right? A Backup running fine without any Errors.

A Restore is a little bit difficult, because the Database is round about 100GB. So i have to wait until the next Weekend.

The question is, was this error a Server Error or a Database File Error.

Regards

Arek

"Orphans" are not a serious problem - they are just some "lost space".
Probably caused by an uncontrolled halt. A few lost pages in a 100GB
database is just a minor nuisance, and a backup+restore will get rid of
the orphans.

--
Aage J.

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02