Regarding long running transaction

classic Classic list List threaded Threaded
2 messages Options
VeenaMithare VeenaMithare
Reply | Threaded
Open this post in threaded view
|

Regarding long running transaction

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Regarding long running transaction

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 <[hidden email]>:
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/