[
https://issues.apache.org/jira/browse/IGNITE-718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergi Vladykin resolved IGNITE-718.
-----------------------------------
Resolution: Fixed
> NPE in query.
> -------------
>
> Key: IGNITE-718
> URL: https://issues.apache.org/jira/browse/IGNITE-718
> Project: Ignite
> Issue Type: Bug
> Components: SQL
> Affects Versions: sprint-3
> Reporter: Vasiliy Sisko
> Assignee: Sergi Vladykin
> Fix For: sprint-3
>
>
> In ignite-692 branch:
> # Run VisorTesterLauncher
> # Run Visor
> # Execute query:
> {code}
> Select * from "c_partitioned2".Car a, "c_partitioned".country,
> "c_partitioned".organization inner join "c_partitioned2".car b
> {code}
> Receive log on node:
> {code}
> [16:16:27,385][WARNING][ignite-#190%rest-visor-tester-DC1%][IgniteH2Indexing]
> Query execution is too long [time=3475 ms, sql='SELECT
> CAST(__C0 AS UUID) _KEY,
> __C1 _VAL,
> CAST(__C2 AS UUID) ID,
> __C3 NAME,
> CAST(__C4 AS UUID),
> __C5,
> CAST(__C6 AS UUID),
> __C7,
> CAST(__C8 AS UUID),
> __C9,
> CAST(__C10 AS UUID),
> __C11,
> CAST(__C12 AS UUID),
> __C13,
> CAST(__C14 AS UUID),
> __C15
> FROM PUBLIC.__Z0()', plan=
> SELECT
> CAST(__C0 AS UUID) AS _KEY,
> __C1 AS _VAL,
> CAST(__C2 AS UUID) AS ID,
> __C3 AS NAME,
> CAST(__C4 AS UUID),
> __C5,
> CAST(__C6 AS UUID),
> __C7,
> CAST(__C8 AS UUID),
> __C9,
> CAST(__C10 AS UUID),
> __C11,
> CAST(__C12 AS UUID),
> __C13,
> CAST(__C14 AS UUID),
> __C15
> FROM PUBLIC.__Z0()
> /* function */
> , parameters=[]]
> {code}
> And NPE on Visor:
> {code}
> javax.cache.CacheException: Failed to run reduce query locally.
> at
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:321)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:714)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:805)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:515)
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:448)
> at
> org.apache.ignite.internal.visor.query.VisorQueryJob.run(VisorQueryJob.java:99)
> at
> org.apache.ignite.internal.visor.query.VisorQueryJob.run(VisorQueryJob.java:39)
> at org.apache.ignite.internal.visor.VisorJob.execute(VisorJob.java:67)
> at
> org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:478)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6107)
> at
> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:472)
> at
> org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:423)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:108)
> at
> org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1052)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(GridTaskWorker.java:1141)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.processMappedJobs(GridTaskWorker.java:535)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.body(GridTaskWorker.java:431)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:108)
> at
> org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(GridTaskProcessor.java:619)
> at
> org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:389)
> at
> org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsyncUnsafe(GridTaskCommandHandler.java:197)
> at
> org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsync(GridTaskCommandHandler.java:134)
> at
> org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:197)
> at
> org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:53)
> at
> org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:107)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:108)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> at
> org.apache.ignite.internal.processors.query.h2.twostep.GridMergeIndex.fetchedAll(GridMergeIndex.java:167)
> at
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:307)
> ... 28 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
