Subject RE: [firebird-support] Oldest transaction stuck
Author Bob Murdoch
Anne -

-----Original Message-----
[] On Behalf Of Ann Harrison
Sent: Thursday, August 18, 2011 4:50 PM
Subject: Re: [firebird-support] Oldest transaction stuck

>> Database header page information:
>> Oldest transaction 12778
>> Oldest active 24126761
>> Oldest snapshot 24126761
>> Next transaction 24152614
>> My understanding was that I do not need to run a manual sweep if I
>> running gbak each night (with garbage collection enabled, of
>> The question is, do I need to run a sweep on this DB, or is there
>> something else that is preventing the OIT from advancing?
>Don't worry about it. Oldest active is a problem, and OIT was a
problem with classic on small memory systems that have been gone for a
decade. If it bothers >you, run a sweep after a garbage collectung

Ah, that makes me feel much better!