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.
