Stuck transaction

Posted in 2015

MICHAEL HOFFMAN — Tue, 05 May 2015 14:45:59 — source: IIUG Forums & Mailing Lists

Hi All, I found a transaction using 'onstat -x' that is definitely stuck. 119696f88 -LH-G 0 0 logid 81731 81763:0x189257c COMMIT 0:00 0 The problem is that those log numbers date back to when the engine crashed in Nov. 2013! (our current logid is 86457) The engine has been restarted several times since then, so obviously this transaction can never be completed. Since it is not attached to a session (sesid = 0), it cannot be killed with 'onmode -z'. Any ideas how I can kill the session and preventit from restarting, or push it forward to completion? Thanks, Michael Hoffman

Related threads

Informix .Net Provider Connection Pool Issue
alarmprogram.sh when LTAPEDEV /dev/null