Subject | RE: [firebird-support] What is wrong with transactions here? |
---|---|
Author | Svein Erling Tysvær |
Post date | 2014-11-05T07:46:58Z |
>> Hi!I don't think this can be the reason for next transaction showing 139981575359934 originally, Marcus - that would require there to be about 1 million transactions per second for five years of which one of the oldest is still active (I would expect this to be more than Firebird can handle and certainly more than enough to test the patience of any user of the database).
>>
>> I have some lines in firebird.log like this:
>> ===================
>> cxv.servers.net Tue Nov 4 11:37:38 2014
>> Sweep is started by SWEEPER
>> Database "SkyNetInt"
>> OIT 1221095, OAT 1231335, OST 1231313, Next 139981575359934
>>
>>
>> cxv.servers.net Tue Nov 4 11:37:46 2014
>> Sweep is finished
>> Database "SkyNetInt"
>> OIT 1248701, OAT 1248707, OST 1248707, Next 1248709
>>
>> ===================
>
>That's housekeeping for transactions. Depending on how applications are connect to the database and how the applications are handling
>their connects, statements and commits - you will see a gap between the oldest active and the next transaction.
Though I've no idea what the reason can be and leave this for others to answer,
Set