Re: [Firebird-devel] Converting Rollback to Commit

2015-07-27 Thread Ivan Přenosil
> From: Vlad Khorsun > > Now I have problem on customers site where every day OIT get stuck. ... >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. Thanks, tha

Re: [Firebird-devel] Converting Rollback to Commit

2015-07-07 Thread Vlad Khorsun
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

[Firebird-devel] Converting Rollback to Commit

2015-07-07 Thread Ivan Přenosil
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