>> I found a strange issue when sweep is executed.
>>
>> I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits.
>>
>> I first execute "SHOW DATABASE" in isql:
>>
>> PAGE_SIZE 16384
>> Number of DB pages allocated = 524480
>> Sweep interval = 20000
>> Forced Writes are OFF
>> Transaction - oldest = 26483174
>> Transaction - oldest active = 26483175
>> Transaction - oldest snapshot = 26483171
>> Transaction - Next = 26483367
>>
>> Shortly after, I do a manual sweep to the same database. This lines
>> appear in firebird.log:
>>
>> Sweep is started by SYSDBA
>> Database "path_to_databse.fdb"
>> OIT 26489872, OAT 26489873, OST 26489873, Next 140660205433875
>>
>> As you can see, it seems to be a huge gap between next transaction and
>> the other values.
>>
>> I guess that is not true, as just some minutes went on from measured
>> points.
>>
>> Is it a normal behaviour?
>
> No, this is a known bug:
> http://tracker.firebirdsql.org/browse/CORE-3978--

Does this also apply to the output via the Trace API?

Thanks!


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

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