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. There is only start transaction, execute block, and rollback. The Execute block contains some Select commands (good optimized and returning 0 or 1 row), and at the end also Update command, but it did not run in this specific case, so during transaction there were no updates to db. The same scenario happens many times during day, but the OIT get stuck only sometimes. When I run the trace log, the load on db was much lower than usually (early morning), but at the same time there were import in progress (transaction running more than hour importing millions of rows). To me it looks like a bug, right ? Not sure I should put it to tracker since I do not have simple test case at hand. Ivan ------------------------------------------------------------------------------ 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
