Hi Guru, We met below two kinds of Optimistic exceptions when doing the transactions, we use OPTIMISTIC and SERIALIZABLE isolation, do you have any suggestions, or if we change to PESSIMISTIC, any risks on that, such as performance or other exceptions? thanks.
{"log":"Caused by: org.apache.ignite.internal.transactions.IgniteTxOptimisticCheckedException: Failed to prepare transaction, read/write conflict [key=9999999992-USD, keyCls=java.lang.String, val=Balance(accountId=9999999992, instrumentId=USD, quantity=2307.81292028250000000000, reserved=0, lastUpdated=2020-07-31 03:10:36.889, lastUpdatedEvent=TRANSFER, tradeType=null), valCls=ignite.entity.Balance, cache=Balance, thread=IgniteThread [compositeRwLockIdx=7, stripe=4, plc=-1, holdsTopLock=false, forbiddenToRequestBinaryMetadata=false, name=sys-stripe-4-#5]]\n","stream":"stderr","time":"2020-07-31T03:10:36.953698541Z"} {"log":"Caused by: org.apache.ignite.internal.transactions.IgniteTxOptimisticCheckedException: Failed to prepare transaction (lock conflict): GridDhtTxLocal [nearNodeId=7e3589a0-c829-42a2-8fb4-115c57ba64f5, nearFutId=3077cc2a371-7364caca-357e-49f2-840e-a101e7c64fa8, nearMiniId=1, nearFinFutId=null, nearFinMiniId=0, nearXidVer=GridCacheVersion [topVer=207644034, order=1596164732765, nodeOrder=2], lb=null, super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[1325467324], recovery=false, mvccEnabled=false, mvccCachingCacheIds=[], txMap=ArrayList [IgniteTxEntry [txKey=IgniteTxKey [key=KeyCacheObjectImpl [part=45, val=9999999992-USD, hasValBytes=true], cacheId=1325467324], val=[op=UPDATE, val=ignite.entity.Balance [idHash=1055847466, hash=-1577210704, accountId=9999999992, lastUpdated=2020-07-31 03:10:36.943, quantity=1204.25992028250000000000, reserved=null, instrumentId=USD, tradeType=null, lastUpdatedEvent=TRANSFER]], prevVal=[op=NOOP, val=null], oldVal=[op=NOOP, val=null], entryProcessorsCol=null, ttl=-1, conflictExpireTime=-1, conflictVer=null, explicitVer=null, dhtVer=null, filters=CacheEntryPredicate[] [], filtersPassed=false, filtersSet=false, entry=GridDhtCacheEntry [rdrs=ReaderId[] [], part=45, super=GridDistributedCacheEntry [super=GridCacheMapEntry [key=KeyCacheObjectImpl [part=45, val=9999999992-USD, hasValBytes=true], val=null, ver=GridCacheVersion [topVer=207644034, order=1596164732830, nodeOrder=1], hash=-148923086, extras=GridCacheObsoleteEntryExtras [obsoleteVer=GridCacheVersion [topVer=2147483647, order=0, nodeOrder=0]], flags=2]]], prepared=1, locked=false, nodeId=null, locMapped=false, expiryPlc=null, transferExpiryPlc=false, flags=0, partUpdateCntr=0, serReadVer=GridCacheVersion [topVer=207644034, order=1596164732670, nodeOrder=1], xidVer=null], IgniteTxEntry [txKey=IgniteTxKey [key=KeyCacheObjectImpl [part=504, val=1380978-USD, hasValBytes=true], cacheId=1325467324], val=[op=UPDATE, val=ignite.entity.Balance [idHash=577969755, hash=-2001853349, accountId=1380978, lastUpdated=2020-07-31 03:10:36.95, quantity=13614077.57624000000000000000, reserved=null, instrumentId=USD, tradeType=null, lastUpdatedEvent=TRANSFER]], prevVal=[op=NOOP, val=null], oldVal=[op=NOOP, val=null], entryProcessorsCol=null, ttl=-1, conflictExpireTime=-1, conflictVer=null, explicitVer=null, dhtVer=null, filters=CacheEntryPredicate[] [], filtersPassed=false, filtersSet=false, entry=GridDhtCacheEntry [rdrs=ReaderId[] [], part=504, super=GridDistributedCacheEntry [super=GridCacheMapEntry [key=KeyCacheObjectImpl [part=504, val=1380978-USD, hasValBytes=true], val=null, ver=GridCacheVersion [topVer=0, order=0, nodeOrder=0], hash=1004605465, extras=null, flags=0]]], prepared=0, locked=false, nodeId=null, locMapped=false, expiryPlc=null, transferExpiryPlc=false, flags=0, partUpdateCntr=0, serReadVer=GridCacheVersion [topVer=207644034, order=1596164732670, nodeOrder=1], xidVer=null]]], super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=207644034, order=1596164732835, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=146, startTime=1596165036958, nodeId=990fbcf8-4105-4aee-b03f-bef9141f5533, startVer=GridCacheVersion [topVer=207644034, order=1596164732835, nodeOrder=1], endVer=null, isolation=SERIALIZABLE, concurrency=OPTIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=null, finalizing=NONE, invalidParts=null, state=MARKED_ROLLBACK, timedOut=false, topVer=AffinityTopologyVersion [topVer=4, minorTopVer=1], mvccSnapshot=null, skipCompletedVers=false, parentTx=null, duration=0ms, onePhaseCommit=false], size=2]]]\n","stream":"stderr","time":"2020-07-31T03:10:37.002484848Z"} -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/