Traced this down to another thread removing a map. cheers Mark
On Thursday, May 30, 2019 at 2:01:57 PM UTC+1, Mark McKeown wrote: > > Hi All, > We have hit the following problem when using MvStore 1.4.198 > > java.lang.IllegalStateException: An old transaction with the same id is still > open: 1 [1.4.198/102] > > at > org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:883) > > at > org.h2.mvstore.tx.TransactionStore.addUndoLogRecord(TransactionStore.java:407) > > at org.h2.mvstore.tx.Transaction.log(Transaction.java:306) > > at org.h2.mvstore.tx.TxDecisionMaker.logIt(TxDecisionMaker.java:131) > > at org.h2.mvstore.tx.TxDecisionMaker.decide(TxDecisionMaker.java:69) > > at > org.h2.mvstore.tx.TxDecisionMaker$PutDecisionMaker.decide(TxDecisionMaker.java:199) > > at org.h2.mvstore.MVMap.operate(MVMap.java:1670) > > at org.h2.mvstore.tx.TransactionMap.set(TransactionMap.java:306) > > at org.h2.mvstore.tx.TransactionMap.set(TransactionMap.java:289) > > at org.h2.mvstore.tx.TransactionMap.put(TransactionMap.java:226) > > > The code that triggers this is: > > > Transaction tx = ts.begin(); > TransactionMap<Long, AgreedProposal> map = tx.openMap(mapId); > old = map.put(agreed.getKey(), agreed); > TransactionMap<String, Long> highestKeyMap = tx.openMap(HIGHEST_KEY_MAP); > // We track the highest key we see. > highestKeyMap.put(highestSendKeyLookup, agreed.getKey()); > tx.commit(); > > > > I found another post from someone who hit a similar issue but they had > multiple threads using the same transaction which we are not doing. > > > This only triggers when we do a load test of our application. > > > Any advice on how we could be triggering this, or how to debug? I am trying > to isolate it in a unit test. > > > I rolled back to 1.4.197 but got an "Entry is locked [1.4.197/101]" error. > > > I will test with 1.4.199 but I suspect it is some code change we did that is > triggering this. > > > cheers > > Mark > > > * <http://wandisco.com>* > > The LIVE DATA Company > > *Find out more wandisco.com <http://wandisco.com/> > <https://www.wandisco.com/welcome-live-data-world-video>* > > THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY AND MAY BE > PRIVILEGED > > If this message was misdirected, WANdisco, Inc. and its subsidiaries, > ("WANdisco") does not waive any confidentiality or privilege. If you are > not the intended recipient, please notify us immediately and destroy the > message without disclosing its contents to anyone. Any distribution, use or > copying of this email or the information it contains by other than an > intended recipient is unauthorized. The views and opinions expressed in > this email message are the author's own and may not reflect the views and > opinions of WANdisco, unless the author is authorized by WANdisco to > express such views or opinions on its behalf. All email sent to or from > this address is subject to electronic storage and review by WANdisco. > Although WANdisco operates anti-virus programs, it does not accept > responsibility for any damage whatsoever caused by viruses being passed. > -- * <http://wandisco.com>* **The LIVE DATA Company *Find out more *wandisco.com <http://wandisco.com/>* <https://www.wandisco.com/welcome-live-data-world-video> * THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY AND MAY BE PRIVILEGED If this message was misdirected, WANdisco, Inc. and its subsidiaries, ("WANdisco") does not waive any confidentiality or privilege. If you are not the intended recipient, please notify us immediately and destroy the message without disclosing its contents to anyone. Any distribution, use or copying of this email or the information it contains by other than an intended recipient is unauthorized. The views and opinions expressed in this email message are the author's own and may not reflect the views and opinions of WANdisco, unless the author is authorized by WANdisco to express such views or opinions on its behalf. All email sent to or from this address is subject to electronic storage and review by WANdisco. Although WANdisco operates anti-virus programs, it does not accept responsibility for any damage whatsoever caused by viruses being passed. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/10440672-8b4b-4252-a776-d0d46d536de9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
