Hello! It is possible that the thread was terminated before you have issued commit() or rollback() on that transaction. ACTIVE state means that you haven't.
Regards, -- Ilya Kasnacheev чт, 10 дек. 2020 г. в 16:53, VeenaMithare <[email protected]>: > 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/ >
