Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Transaction Limit Exceeded

No recent searches

    Popular Articles

            Sorry! nothing found for

            Transaction Limit Exceeded

            Created by Russ Hartle, Modified on Tue, 1 Apr, 2025 at 1:45 PM by Russ Hartle

            The Firebird limit is roughly 2 billion database transactions. Once a database reaches this amount of transactions, additional data cannot be written and the database will not synch or accept new synchronization connections. There is a simple fix to reset the database transaction count:

            1. Stop the Firebird services
            2. Rename the Database
            3. Start the Firebird services
            4. Run the following commands:
            • gfix -mode read_only -user sysdba -password j316fgsl “path\to\*.fdb”
            • gbak -v -f -t -user sysdba -password j316fgsl “path\to\*.fdb” “path\to\*.bak”
            • gbak -v -f -r -user sysdba -password j316fgsl “path\to\*.bak” “path\to\*-new.fdb”
            • gfix -mode read_write -user sysdba -password j316fgsl “path\to\*-new.fdb”
            1. Stop the Firebird services
            2. Rename the Database back to original name
            3. Start the Firebird services

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Feedback sent

            We appreciate your effort and will try to fix the article

            X