Subject Encounter "Invalid Transaction Object"
Author Chee Yang

I have an application using Firebird 1.5 and Firebird 2.1 as database server. The application is a client/server apps that have about 20 to 30 instances in a LAN environment. The application is written by Delphi DBX framework.

The application will prompt "Invalid Transaction Object" after using the apps and database in a week. I use "gfix -v -full" to check the database and found that the database has error. I have tried sweep the database but errors persist. The only cure is backup and restore to get rid of the error. This is a time consuming operation as the database has grow to 3GB++.

After the backup/restore, the error gone. However, the same error occurs in another week. Does anyone hasa same experience as me?

Thank you