Hello,

>>> Hi!
>>>
>>> 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.
>
> 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).

http://tracker.firebirdsql.org/browse/CORE-3978



--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.