Hi , I see this in my transaction log : 2020-12-10T07:32:59,525 WARN o.a.i.i.diagnostic [grid-timeout-worker-#1035%config-sync-GREEN-igniteclient-SINGLE%]: First 10 long running transactions [total=1] 2020-12-10T07:32:59,525 WARN o.a.i.i.diagnostic [grid-timeout-worker-#1035%config-sync-GREEN-igniteclient-SINGLE%]: >>> Transaction [startTime=07:31:22.861, curTime=07:32:59.392, systemTime=0, userTime=96531, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=false, needCheckBackup=null, hasRemoteLocks=false, trackTimeout=true, systemTime=0, systemStartTime=0, prepareStartTime=0, prepareTime=0, commitOrRollbackStartTime=0, commitOrRollbackTime=0, txDumpsThrottling=o.a.i.i.processors.cache.transactions.IgniteTxManager$TxDumpsThrottling@f46affc, lb=null, mvccOp=null, qryId=-1, crdVer=0, thread=<failed to find active thread 39198>, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[], recovery=null, mvccEnabled=null, mvccCachingCacheIds=[], txMap=EmptySet []], super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=218929849, order=1607454902519, nodeOrder=6], writeVer=null, implicit=false, loc=true, threadId=39198, startTime=1607585482861, nodeId=e25ecc8b-66e4-4856-9da5-5eebeec67a45, startVer=GridCacheVersion [topVer=218929849, order=1607454902519, nodeOrder=6], endVer=null, isolation=READ_COMMITTED, concurrency=PESSIMISTIC, timeout=900000, sysInvalidate=false, sys=false, plc=2, commitVer=null, finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=-1, minorTopVer=0], mvccSnapshot=null, skipCompletedVers=false, parentTx=null, duration=96531ms, onePhaseCommit=false], size=0]]]]
How do I know the cause for this long running transaction ? I see this in the log above : thread=<failed to find active thread 39198>. What does this mean. I am updating around 50k records in a transaction and have given the tx timeout as 120 secs. What is the threshold for ignite to decide that a transaction is long running ?I can see that this is showing a usertime of 96531. I dont see any other WARN or ERROR messages after this log , ( there is one more warn message about 'dumping the stack trace of near node that started this transaction' , but that is not helpful ) regards, Veena. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
