07.07.2015 12:17, Ivan Přenosil wrote: > Hi, > I am sure I read years ago that FB keeps track of changes made by transaction, > and if it did not modify any data, then it internally converts rollback to > commit. > > Now I have problem on customers site where every day OIT get stuck. > When the db was new (3 years ago), it happened very very rarely (so even > sweeping > once a week seemed unnecessary). I do not remember what version of FB was > then, > but now it is FB2.5.4 (and the same problem with FB2.5.2). > > Using trace log, I found the transaction/command responsible for stuck OIT.
OIT is the number of the oldest non-committed transaction *minus one*. I.e. if you look for OIT number at the trace log, then you found not what you really need. Look for OIT + 1. Regards, Vlad ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
