[IGNITE-718] NPE in query.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: sprint-3
• Fix Version/s: sprint-3
• Component/s: sql
• Assignee: Sergei Vladykin
• Reporter: Vasiliy Sisko
• Created: 10/Apr/15 09:30
• Updated: 11/Apr/15 19:15
• Resolved: 11/Apr/15 19:15

Description

In ignite-692 branch:

1. Run VisorTesterLauncher
2. Run Visor
3. Execute query:

   Select * from "c_partitioned2".Car a, "c_partitioned".country, "c_partitioned".organization inner join "c_partitioned2".car b 
   

Receive log on node:

[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=[]]

And NPE on Visor:

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