Anne - -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ann Harrison Sent: Thursday, August 18, 2011 4:50 PM To: [email protected] 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 am >> running gbak each night (with garbage collection enabled, of course). >> 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 backup Ah, that makes me feel much better! Thanks. ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
