RealHeavyDude
Well-Known Member
OpenEdge 11.3.1 64Bit Solaris SPARC
Lately we run into trouble with long running transactions causing the Before Image of our production database to unexpectedly grow. Bad code ...
Therefore I have introduced a transaction monitor to report long running transactions and eventually disconnect the offending processes from the database when the database is in before image panic ( utilization has reached 80% of 6 GB threshold ).
I use this query to get a hold on all active transactions:
The _Trans._Trans-Duration field hols the time in seconds.
During testing I encountered some weirdness where the _Trans._Trans-Duration was insanely high and exceeded the process life time - calculated from _Connect._Connect-Time - by far. To me this does not make any sense at all.
I found out that this only happens with self service clients though.
I am inclined to think that this is a bug.
Has anybody else seen something like this?
Thanks in Advance, RealHeavyDude.
Lately we run into trouble with long running transactions causing the Before Image of our production database to unexpectedly grow. Bad code ...
Therefore I have introduced a transaction monitor to report long running transactions and eventually disconnect the offending processes from the database when the database is in before image panic ( utilization has reached 80% of 6 GB threshold ).
I use this query to get a hold on all active transactions:
Code:
for each _Trans no-lock where _Trans._Trans-State = 'ACTIVE',
first _Connect no-lock where _Connect._Connect-Usr = _Trans._Trans-UsrNum:
end.
The _Trans._Trans-Duration field hols the time in seconds.
During testing I encountered some weirdness where the _Trans._Trans-Duration was insanely high and exceeded the process life time - calculated from _Connect._Connect-Time - by far. To me this does not make any sense at all.
I found out that this only happens with self service clients though.
I am inclined to think that this is a bug.
Has anybody else seen something like this?
Thanks in Advance, RealHeavyDude.