Hi, I was trying to explore H2 console in my application, but when I was trying to query a cache I got below error.
can you please tell me how to configure or fix it ? SELECT * FROM "tradingMembersCache".TRADINGMEMBERS; General error: "java.lang.IllegalStateException: GridH2QueryContext is not initialized."; SQL statement: SELECT * FROM "tradingMembersCache".TRADINGMEMBERS [50000-195] <http://10.23.209.152:56732/query.do?jsessionid=4f8c86efcb1a05099c05db855a65b6fe#> HY000/50000 (Help) <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50000> org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: GridH2QueryContext is not initialized."; SQL statement: SELECT * FROM "tradingMembersCache".TRADINGMEMBERS [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=345&build=195> ) at org.h2.message.DbException.get(DbException.java:168 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=168&build=195> ) at org.h2.message.DbException.convert(DbException.java:295 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=295&build=195> ) at org.h2.command.Command.executeQuery(Command.java:215 <http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=215&build=195> ) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:187 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=187&build=195> ) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:165 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=165&build=195> ) at org.h2.server.web.WebApp.getResult(WebApp.java:1380 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1380&build=195> ) at org.h2.server.web.WebApp.query(WebApp.java:1053 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1053&build=195> ) at org.h2.server.web.WebApp$1.next(WebApp.java:1015 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1015&build=195> ) at org.h2.server.web.WebApp$1.next(WebApp.java:1002 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1002&build=195> ) at org.h2.server.web.WebThread.process(WebThread.java:164 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=164&build=195> ) at org.h2.server.web.WebThread.run(WebThread.java:89 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=89&build=195> ) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.IllegalStateException: GridH2QueryContext is not initialized. at org.apache.ignite.internal.processors.query.h2.opt.GridH2IndexBase.threadLocalSegment(GridH2IndexBase.java:178) at org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:177) at org.apache.ignite.internal.processors.query.h2.opt.GridH2ScanIndex.find(GridH2ScanIndex.java:108) at org.apache.ignite.internal.processors.query.h2.opt.GridH2ScanIndex.find(GridH2ScanIndex.java:103) at org.h2.index.IndexCursor.find(IndexCursor.java:169 <http://h2database.com/html/source.html?file=org/h2/index/IndexCursor.java&line=169&build=195> ) at org.h2.table.TableFilter.next(TableFilter.java:468 <http://h2database.com/html/source.html?file=org/h2/table/TableFilter.java&line=468&build=195> ) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452 <http://h2database.com/html/source.html?file=org/h2/command/dml/Select.java&line=1452&build=195> ) at org.h2.result.LazyResult.hasNext(LazyResult.java:79 <http://h2database.com/html/source.html?file=org/h2/result/LazyResult.java&line=79&build=195> ) at org.h2.result.LazyResult.next(LazyResult.java:59 <http://h2database.com/html/source.html?file=org/h2/result/LazyResult.java&line=59&build=195> ) at org.h2.command.dml.Select.queryFlat(Select.java:519 <http://h2database.com/html/source.html?file=org/h2/command/dml/Select.java&line=519&build=195> ) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625 <http://h2database.com/html/source.html?file=org/h2/command/dml/Select.java&line=625&build=195> ) at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114 <http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=114&build=195> ) at org.h2.command.dml.Query.query(Query.java:352 <http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=352&build=195> ) at org.h2.command.dml.Query.query(Query.java:333 <http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=333&build=195> ) at org.h2.command.CommandContainer.query(CommandContainer.java:113 <http://h2database.com/html/source.html?file=org/h2/command/CommandContainer.java&line=113&build=195> ) at org.h2.command.Command.executeQuery(Command.java:201 <http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=201&build=195> ) ... 9 more -- Regards, Rajarshi Pain
