Hello, Kenneth!

---------------- cit---------------------------------
From: Kenneth Foo

I'm getting such errors and I'm not sure whether it's database corruption or
what.
I did a database backup and restore and I'm still getting the same error.
Any alternative solutions?

-----------------------------------
2004-05-21 10:46:03,633 DEBUG [Thread-12] (POP3Monitor.java:180) - 0 mails
in mailbox
2004-05-21 10:46:13,179 ERROR [http8080-Processor22] (FBTempDB.java:311) -
List failed
org.firebirdsql.jdbc.FBSQLException: Resource Exception. internal gds
software consistency check (can't continue after bugcheck)
Reason: internal gds software consistency check (can't continue after
bugcheck)
at
org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:818)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:85)


------------------End of cit---------------------------



It's database corruption - bugcheck error is born deep inside the engine, I doubt that JDBC can ever produce it itself.

Please check it once more - did you replace old database with new one?
If you use Linux, be sure you turned off all users from FB before restore, including Tomcat instance.
(the best way to do it - just reboot computer).

Also it may be useful to see these docs
http://ibphoenix.com/main.nfs?a=ibphoenix&l=;PAGES;NAME='ibp_db_corr'
http://www.ibsurgeon.com/interbase/firebird/error/commonerrors.html
http://www.ibsurgeon.com/interbase/firebird/corruption/guide.html

Sincerely yours,
Alexey Kovyazin
www.ib-aid.com






[Non-text portions of this message have been removed]