Big difference to Next Transaction

[michaelJ]

Hello,

I use IBDAC V3.60.0.24 with AutoCommit=False and FB V1.5.
When I look into the Database header page information I see the following:

Code: Select all

        Flags                   0 
        Checksum                12345 
        Generation              304117 
        Page size               4096 
        ODS version             10.1 
        Oldest transaction      27528 
        Oldest active           27529 
        Oldest snapshot         27514 
        Next transaction        304108 

What could be the reason for the big gap between NT and (OT/OA/OS) and waht ca I do to solve the problem? Currently I have no performance issues. Everything works fine.
Thanks,

Michael

[ZEuS]

Hello.

Such problem can occur when TIBCTransaction.CommitRetaining method is executed. Try to avoid using CommitRetaining and use Commit instead of it.
To solve the problem you can try to backup and restore your database.
You can find more information about NT, OT, OA and OS parameters in the official Firebird documentation here: http://www.firebirdsql.org/manual/bk02ar17s03.html