Attached are a few consecutive stack traces of the thread that performs the
slow queries.
The queries that are used while taking these stack traces are recursive
queries using CTE (common table expressions) using H2's syntax:
http://www.h2database.com/html/advanced.html#recursive_queries
While the queries can be improved and optimized, this still doesn't account
for the difference between embedded H2 running standalone which takes ~2
minutes and embedded H2 running within a Maven multi-module build which
takes ~1 hour for the same exact operations.
I think there's an issue with how H2 is searching the pages inside the
memory, notice how most traces are in the binarySearch and comparison
operations.
I am also investigating a possible issue with a /dev/urandom seeding
problem, currently I'm using the following JVM setting without any results:
-Djava.security.egd=file:/dev/./urandom
I will keep looking into this.
On Saturday, April 29, 2017 at 11:46:34 PM UTC+3, Noel Grandin wrote:
>
> Sorry, then I'm out of ideas. I've run multiple H2 instances in the same
> VM without slowdown, so I don't know what is going on here.
>
>
>
--
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.
For more options, visit https://groups.google.com/d/optout.
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.value.Value.compareTypeSafe(Value.java:1011)
at org.h2.mvstore.db.ValueDataType.compareValues(ValueDataType.java:138)
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:105)
at org.h2.mvstore.MVMap.compare(MVMap.java:713)
at org.h2.mvstore.Page.binarySearch(Page.java:334)
at org.h2.mvstore.Cursor.min(Cursor.java:122)
at org.h2.mvstore.Cursor.hasNext(Cursor.java:36)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1388)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.<init>(TransactionStore.java:1384)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1379)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1367)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:309)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:254)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.mvstore.Page.binarySearch(Page.java:324)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:466)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.get(MVMap.java:455)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1203)
- locked <0x00000004aeeb1e88> (a org.h2.mvstore.MVMap)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1180)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1148)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1168)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1415)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1430)
at
org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:507)
at org.h2.index.IndexCursor.next(IndexCursor.java:305)
at org.h2.table.TableFilter.next(TableFilter.java:499)
at org.h2.table.TableFilter.next(TableFilter.java:480)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.mvstore.Page.binarySearch(Page.java:334)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:466)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.get(MVMap.java:455)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1203)
- locked <0x00000004aeeb1e88> (a org.h2.mvstore.MVMap)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1180)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1148)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1168)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1415)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1430)
at
org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:507)
at org.h2.index.IndexCursor.next(IndexCursor.java:305)
at org.h2.table.TableFilter.next(TableFilter.java:499)
at org.h2.table.TableFilter.next(TableFilter.java:480)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.result.LocalResult.cloneLobs(LocalResult.java:271)
at org.h2.result.LocalResult.addRow(LocalResult.java:298)
at org.h2.command.dml.Select.queryFlat(Select.java:523)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:209)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.value.Value.compareTypeSafe(Value.java:1011)
at org.h2.mvstore.db.ValueDataType.compareValues(ValueDataType.java:138)
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:105)
at org.h2.mvstore.MVMap.compare(MVMap.java:713)
at org.h2.mvstore.Page.binarySearch(Page.java:334)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:466)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.get(MVMap.java:455)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1203)
- locked <0x00000004aeeb1e88> (a org.h2.mvstore.MVMap)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1180)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1148)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1168)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1415)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1430)
at
org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:507)
at org.h2.index.IndexCursor.next(IndexCursor.java:305)
at org.h2.table.TableFilter.next(TableFilter.java:499)
at org.h2.table.TableFilter.next(TableFilter.java:480)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.mvstore.db.ValueDataType.compareValues(ValueDataType.java:121)
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:105)
at org.h2.mvstore.MVMap.compare(MVMap.java:713)
at org.h2.mvstore.Page.binarySearch(Page.java:334)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:466)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:474)
at org.h2.mvstore.MVMap.get(MVMap.java:455)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1203)
- locked <0x00000004aeeb1e88> (a org.h2.mvstore.MVMap)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1180)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1148)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1168)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1415)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.<init>(TransactionStore.java:1384)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1379)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1367)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:309)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:254)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
"H2 TCP Server (tcp://<host-omitted>:10114) thread" prio=10
tid=0x00007f046c48b000 nid=0x7214 runnable [0x00007f04608c6000]
java.lang.Thread.State: RUNNABLE
at org.h2.mvstore.Page.binarySearch(Page.java:324)
at org.h2.mvstore.Cursor.min(Cursor.java:122)
at org.h2.mvstore.Cursor.hasNext(Cursor.java:36)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1388)
at
org.h2.mvstore.db.TransactionStore$TransactionMap$1.<init>(TransactionStore.java:1384)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1379)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.keyIterator(TransactionStore.java:1367)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:309)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:254)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.index.ViewIndex.findRecursive(ViewIndex.java:223)
at org.h2.index.ViewIndex.find(ViewIndex.java:288)
at org.h2.index.ViewIndex.find(ViewIndex.java:161)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:468)
at org.h2.table.TableFilter.next(TableFilter.java:538)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
- locked <0x00000004aecbbc40> (a org.h2.engine.Database)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:329)
- locked <0x00000004aeeb1638> (a org.h2.engine.Session)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:722)
