You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by VeenaMithare <v....@cmcmarkets.com> on 2020/12/10 13:53:38 UTC
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/
Re: Regarding long running transaction
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <v....@cmcmarkets.com>:
> 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/
>