Hi, Could you show the query and the code block with the query execution because query "with p as (select * from person) select * from p" works well on 2.9.0. I suspect that the issue could be related to creating jdbc resources. Could you also show the configuration for the hikari jdbc pool.
Thanks, Pavel пн, 7 дек. 2020 г. в 12:43, Alexandr Shapkin <[email protected]>: > Hi, > > > > I’ve filed a JIRA ticket > https://issues.apache.org/jira/browse/IGNITE-13822 to track this issue. > > Full logs or a simple reproducer would help to debug this more quickly, > feel free to share them as well. > > > > *From: *yangjiajun <[email protected]> > *Sent: *Monday, December 7, 2020 5:40 AM > *To: *[email protected] > *Subject: *With as syntax does not work in ignite 2.9.0? > > > > Hello. > > > > We use 'with xxx as (select xxx) ',which works vrey fine in 2.8.1 and > other > > past release versions.After we uprade to 2.9.0,such sqls start to throw > > exception. In the server side,the error looks like: > > > > , args=Object[] [], stmtType=SELECT_STATEMENT_TYPE, autoCommit=true, > > partResReq=false, super=JdbcRequest [type=2, reqId=790418]]] > > class org.apache.ignite.internal.processors.query.IgniteSQLException: > Failed > > to parse query. General error: "java.lang.NullPointerException" [50000-197] > > at > > > org.apache.ignite.internal.processors.query.h2.H2Connection.prepareStatementNoCache(H2Connection.java:194) > > at > > > org.apache.ignite.internal.processors.query.h2.H2PooledConnection.prepareStatementNoCache(H2PooledConnection.java:109) > > at > > > org.apache.ignite.internal.processors.query.h2.QueryParser.parseH2(QueryParser.java:355) > > at > > > org.apache.ignite.internal.processors.query.h2.QueryParser.parse0(QueryParser.java:222) > > at > > > org.apache.ignite.internal.processors.query.h2.QueryParser.parse(QueryParser.java:138) > > at > > > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1071) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2779) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2775) > > at > > > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:3338) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$2(GridQueryProcessor.java:2795) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2833) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2769) > > at > > > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2727) > > at > > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:647) > > at > > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:320) > > at > > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:257) > > at > > > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:202) > > at > > > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:56) > > at > > > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > > at > > > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > > at > > > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > > at > > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) > > at > > > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > > at > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: org.h2.jdbc.JdbcSQLException: General error: > > "java.lang.NullPointerException" [50000-197] > > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:357) > > at org.h2.message.DbException.get(DbException.java:168) > > at org.h2.message.DbException.convert(DbException.java:307) > > at > org.h2.message.DbException.toSQLException(DbException.java:280) > > at > org.h2.message.TraceObject.logAndConvert(TraceObject.java:357) > > at > org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:697) > > at > > > org.apache.ignite.internal.processors.query.h2.H2Connection.prepareStatementNoCache(H2Connection.java:191) > > ... 26 more > > Caused by: java.lang.NullPointerException > > at > org.h2.table.Table.removeChildrenAndResources(Table.java:545) > > at > org.h2.table.TableView.removeChildrenAndResources(TableView.java:439) > > at > org.h2.engine.Session.removeLocalTempTable(Session.java:409) > > at > org.h2.command.Parser.parseSingleCommonTableExpression(Parser.java:5233) > > at org.h2.command.Parser.parseWith(Parser.java:5145) > > at > org.h2.command.Parser.parseWithStatementOrQuery(Parser.java:1931) > > at org.h2.command.Parser.parsePrepared(Parser.java:499) > > at org.h2.command.Parser.parse(Parser.java:335) > > at org.h2.command.Parser.parse(Parser.java:307) > > at org.h2.command.Parser.prepareCommand(Parser.java:278) > > at org.h2.engine.Session.prepareLocal(Session.java:611) > > at org.h2.engine.Session.prepareCommand(Session.java:549) > > at > org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247) > > at > org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) > > at > org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:694) > > ... 27 more > > > > In the client side,the error looks like: > > > > java.sql.SQLException: Failed to parse query. General error: > > "java.lang.NullPointerException" [50000-197] at > > > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1004) > > at > > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:231) > > at > > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.executeQuery(JdbcThinStatement.java:139) > > at > > com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) > > at > > > com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java... > > > > The sqls work fine while ignite just started.Such error happens after > ignite > > runs a while.And after that,the error seems happen every time. > > > > Do u have any ideas about it? > > > > > > > > > > -- > > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > > > -- Regards Pavel Vinokurov
