Subject Re: [firebird-support] Encounter "Invalid Transaction Object"
Author Ann W. Harrison
Chee Yang wrote:
> Hi,
> 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++.

Gfix -v can report a number of benign conditions as errors. These
include pages that were allocated but not used, pages that were released
but not put back on the free list, back versions that were detached from
the newer version but not released, etc. Without knowing what error
you're getting, it's very hard to guess what the problem is.

Good luck,