Re: With as syntax does not work in ignite 2.9.0?

[yangjiajun]

Hello.Thanks for u reply.

Sorry for that I can't post sqls beacuse they contain sensitive bussiness
info.I'm also sorry that I can't make a reproducer now.

Here is my code to execute query:
ResultSet excuteQuery(Connection conn, String sql) throws SQLException {
Statement stmt = conn.createStatement();
stmt.setQueryTimeout(7200);
ResultSet rs = stmt.executeQuery(sql);
rs.setFetchSize(15000);
return rs;
}

void closeResultSet(ResultSet rs) throws SQLException {
rs.close();
rs.getStatement().close();
rs.getStatement().getConnection().close();
}

try(Connection conn = pool.getConnection()){
try(ResultSet rs = excuteQuery(conn,sql)){
/**
 hadle result set
*/
closeResultSet(rs);
}
}

My hikariCP pool settings:
HikariDataSource ds = new HikariDataSource();
ds.setDriverClassName("org.apache.ignite.IgniteJdbcThinDriver");
ds.setMaximumPoolSize(100);
ds.setLeakDetectionThreshold(60);
ds.setConnectionTimeout(6);
ds.setMinimumIdle(0);
ds.setReadOnly(true);

The reseason I believe with as syntax does not work anymore is I have 5 sqls
got in trouble and all of then contain with as syntax.Another reason is such
error happens at parse step.And we can see error info relates to 'temp
table' which I think with as needs temp table.

But u guys are experts,I will try my best to follow u advices and collect
more info u need.






--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

BaselineTopology branching error

[rakshita04]

Hi Team,

We are using baseline topology concept for our two nodes, running on
separate machines.
We are getting below error when both of these nodes run together-

Caused by: class org.apache.ignite.spi.IgniteSpiException: BaselineTopology
of joining node (DSU_B) is not compatible with BaselineTopology in the
cluster. Branching history of cluster BlT ([65356776]) doesn't contain
branching point hash of joining node BlT (65356777). Consider cleaning
persistent storage of the node and adding it to the cluster again.

After getting this error , when we deleted the nodes and restarted ignite.
it worked fine.
But this way we are loosing our data.
We are using similar configuration.xml file for both of them.
What can we do to avoid this issue?

regards,
Rakshita Chaudhary



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

[Meetup] I have a cool Ignite user story for you on December 8 (and need more of them!)

[Kseniya Romanova]

Hi Igniters!

At tomorrows' Meetup, we welcome Mikhail Antonov from Raiffeisen bank. He
will share his experience of using Ignite in the core banking system for
scaling and reducing backend load. I like this story as it's elegant and
simple. Join us at 8 AM PST / 5 PM CET:
https://www.meetup.com/Apache-Ignite-Virtual-Meetup/events/274647932/

It's time to plan our 2021 meetups and I ask you to share your experience
of going into production with Ignite. It hasn't to be anything exotic or
over-complicated or even super-smooth. If you think your story needs
polishing before presenting it in public - please contact me, and I'll do
my best to help.

More various user stories would help developers new to the product to adopt
it and stay with the community.

Cheers,
Kseniya

Meetup CFP
https://docs.google.com/forms/d/e/1FAIpQLSdiY7movHKvyWg3gOVedHgukJJnNiaejSO_X838vBseL9VmiQ/viewform

Re: With as syntax does not work in ignite 2.9.0?

[Ilya Kasnacheev]

Hello!

Do you happen to run this query on client or server node? Try running it on
a server node for a chance. Clients initialize cached lazily and yield a
crop of NPEs.

Regards,
-- 
Ilya Kasnacheev


пн, 7 дек. 2020 г. в 05:40, yangjiajun <1371549...@qq.com>:

> 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" [5-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" [5-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 

Re: Using different versions of serializable objects

[Ilya Kasnacheev]

Hello!

You can try specifying BinaryConfiguration where you would supply a
BinaryTypeConfiguration for this type name, specifying a custom
BinarySerializer. Then you can try supplying BinaryReflectiveSerializer
there.

See
https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration/BinaryConfiguration.html#setTypeConfigurations-java.util.Collection-

Regards,
-- 
Ilya Kasnacheev


ср, 2 дек. 2020 г. в 19:00, Surkov.Aleksandr :

> no, because we use third party classes and cannot change them
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

[2.9.0]NPE on invoke IgniteCache.destroy()

[38797715]

Hi community,

Call IgniteCache.destroy Method, NPE appears,logs are as follows:

2020-12-0717:32:18.870[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.e.time- Started exchange init 
[topVer=AffinityTopologyVersion [topVer=1, minorTopVer=279], crd=true, 
evt=DISCOVERY_CUSTOM_EVT, evtNode=320935f6-3516-4b0b-9e5f-e80768696522, 
customEvt=DynamicCacheChangeBatch 
[id=1f2a90e2671-562b8f51-fa6a-4094-928c-6976ce87614a, reqs=ArrayList 
[DynamicCacheChangeRequest [cacheName=PksQuota, hasCfg=false, 
nodeId=320935f6-3516-4b0b-9e5f-e80768696522, clientStartOnly=false, 
stop=true, destroy=false, disabledAfterStartfalse]], 
exchangeActions=ExchangeActions [startCaches=null, 
stopCaches=[PksQuota], startGrps=[], stopGrps=[PksQuota, destroy=true], 
resetParts=null, stateChangeRequest=null], startCaches=false], 
allowMerge=false, exchangeFreeSwitch=false]
2020-12-0717:32:18.873[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.p.c.d.d.p.GridDhtPartitionsExchangeFuture- Finished waiting 
for partition release future [topVer=AffinityTopologyVersion [topVer=1, 
minorTopVer=279], waitTime=0ms, futInfo=NA, mode=DISTRIBUTED]
2020-12-0717:32:18.873[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.p.c.d.d.p.GridDhtPartitionsExchangeFuture- Finished waiting 
for partitions release latch: ServerLatch [permits=0, 
pendingAcks=HashSet [], super=CompletableLatch [id=CompletableLatchUid 
[id=exchange, topVer=AffinityTopologyVersion [topVer=1, minorTopVer=279
2020-12-0717:32:18.873[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.p.c.d.d.p.GridDhtPartitionsExchangeFuture- Finished waiting 
for partition release future [topVer=AffinityTopologyVersion [topVer=1, 
minorTopVer=279], waitTime=0ms, futInfo=NA, mode=LOCAL]
2020-12-0717:32:19.037[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.p.c.d.d.p.GridDhtPartitionsExchangeFuture- 
finishExchangeOnCoordinator [topVer=AffinityTopologyVersion [topVer=1, 
minorTopVer=279], resVer=AffinityTopologyVersion [topVer=1, 
minorTopVer=279]]
2020-12-0717:32:19.438[] [exchange-worker-#54%tradecore%] 
INFOo.a.i.i.p.c.d.d.p.GridDhtPartitionsExchangeFuture- Finish exchange 
future [startVer=AffinityTopologyVersion [topVer=1, minorTopVer=279], 
resVer=AffinityTopologyVersion [topVer=1, minorTopVer=279], err=null, 
rebalanced=true, wasRebalanced=true]
2020-12-0717:32:20.870[] [db-checkpoint-thread-#75%tradecore%] 
INFOo.a.i.i.p.c.p.GridCacheDatabaseSharedManager- Checkpoint started 
[checkpointId=f001018a-100e-4154-98c9-547dabf5015f, 
startPtr=FileWALPointer [idx=16, fileOff=1059360696, len=4770137], 
checkpointBeforeLockTime=549ms, checkpointLockWait=0ms, 
checkpointListenersExecuteTime=529ms, checkpointLockHoldTime=853ms, 
walCpRecordFsyncDuration=17ms, writeCheckpointEntryDuration=7ms, 
splitAndSortCpPagesDuration=4ms, pages=10775, reason='caches stop']
2020-12-0717:32:21.255[] [checkpoint-runner-#79%tradecore%] 
WARNo.a.i.i.p.c.p.GridCacheDatabaseSharedManager- 1checkpoint pages were 
not written yet due to unsuccessful page write lock acquisition and will 
be retried
2020-12-0717:32:21.261[] [exchange-worker-#54%tradecore%] 
ERRORo.a.i.i.p.c.GridCacheProcessor- Failed to wait for checkpoint 
finish during cache stop.
org.apache.ignite.IgniteCheckedException: Compound exception for 
CountDownFuture.
at 
org.apache.ignite.internal.util.future.CountDownFuture.addError(CountDownFuture.java:72) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
org.apache.ignite.internal.util.future.CountDownFuture.onDone(CountDownFuture.java:46) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
org.apache.ignite.internal.util.future.CountDownFuture.onDone(CountDownFuture.java:28) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:478) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
org.apache.ignite.internal.processors.cache.persistence.GridCacheDatabaseSharedManager$WriteCheckpointPages.run(GridCacheDatabaseSharedManager.java:4546) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_272]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_272]

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272]
Suppressed: java.lang.NullPointerException
at 
org.apache.ignite.internal.processors.cache.persistence.GridCacheDatabaseSharedManager$WriteCheckpointPages.writePages(GridCacheDatabaseSharedManager.java:4584) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
org.apache.ignite.internal.processors.cache.persistence.GridCacheDatabaseSharedManager$WriteCheckpointPages.run(GridCacheDatabaseSharedManager.java:4540) 
~[ignite-core-2.9.0.jar!/:2.9.0]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_272]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_272]

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272]
2020-12-0717:32:21.265[] [exchange-worker-#54%tradecore%] 

RE: Could not clear historyMap due to WAL reservation on cp

[shivakumar]

Thanks for your reply Alexandr Shapkin

The ticket you shared https://issues.apache.org/jira/browse/IGNITE-13373
more related to preloading
releaseHistoryForPreloading()
But the issue am facing is somehow WAL segments which are not needed for
crash recovery after checkpoint are not getting cleaned, Do you think there
is something fixed in the above jira ticket related to my issue ?

I tried collecting logs, the logs are very huge, i couldn't find any
exceptions or error messages but I saw below warnings: 
"Partition states validation has failed for group"
"Could not clear historyMap due to WAL reservation on cp"

Please find the attached logs files (not full log but part of logs where i
saw above warnings) instance1.log
  
historymap.log
  

Shiva



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: With as syntax does not work in ignite 2.9.0?

[Pavel Vinokurov]

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 :

> 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 <1371549...@qq.com>
> *Sent: *Monday, December 7, 2020 5:40 AM
> *To: *user@ignite.apache.org
> *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" [5-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" [5-197]
>
>   at
> org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
>
>   at org.h2.message.DbException.get(DbException.java:168)
>
>   at 

RE: With as syntax does not work in ignite 2.9.0?

[Alexandr Shapkin]

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: yangjiajunSent: Monday, December 7, 2020 5:40 AMTo: user@ignite.apache.orgSubject: 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 otherpast release versions.After we uprade to 2.9.0,such sqls start to throwexception. 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: Failedto parse query. General error: "java.lang.NullPointerException" [5-197]  atorg.apache.ignite.internal.processors.query.h2.H2Connection.prepareStatementNoCache(H2Connection.java:194)  atorg.apache.ignite.internal.processors.query.h2.H2PooledConnection.prepareStatementNoCache(H2PooledConnection.java:109)  atorg.apache.ignite.internal.processors.query.h2.QueryParser.parseH2(QueryParser.java:355)  atorg.apache.ignite.internal.processors.query.h2.QueryParser.parse0(QueryParser.java:222)  atorg.apache.ignite.internal.processors.query.h2.QueryParser.parse(QueryParser.java:138)  atorg.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1071)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2779)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2775)  atorg.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:3338)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$2(GridQueryProcessor.java:2795)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2833)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2769)  atorg.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2727)  atorg.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:647)  atorg.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:320)  atorg.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:257)  atorg.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:202)  atorg.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:56)  atorg.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)  atorg.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)  atorg.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)  atorg.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)  atorg.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)  atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)  atjava.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" [5-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)  atorg.apache.ignite.internal.processors.query.h2.H2Connection.prepareStatementNoCache(H2Connection.java:191)  ... 26 moreCaused 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)