[teiid-issues] [JBoss JIRA] (TEIID-5186) NPE in QueryResolver when calling virtual procedure
dalex dalex (JIRA)
issues at jboss.org
Wed Dec 20 08:39:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-5186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
dalex dalex updated TEIID-5186:
-------------------------------
Description:
When running query:
{code:sql}
select * from (call procs.pr0()) a
{code}
teiid is throwing out the following stacktrace:
{code:noformat}
2017-12-20 14:28:12,939 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6) hVe+gXzCsZCA TEIID30019 Unexpected exception for request hVe+gXzCsZCA.1: java.lang.NullPointerExcep
tion
at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:387)
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:2080)
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1462)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.query.optimizer.relational.RelationalPlanner.planSubqueries(RelationalPlanner.java:737)
at org.teiid.query.optimizer.relational.RelationalPlanner.connectSubqueryContainers(RelationalPlanner.java:696)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:220)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.query.optimizer.ProcedurePlanner.optimize(ProcedurePlanner.java:86)
at org.teiid.query.optimizer.QueryOptimizer.planProcedure(QueryOptimizer.java:206)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:146)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1719)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedProcedure(RelationalPlanner.java:1181)
at org.teiid.query.optimizer.relational.RelationalPlanner.createStoredProcedurePlan(RelationalPlanner.java:1271)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1037)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1709)
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1532)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:660)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
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)
{code}
was:
When running query:
{code:sql}
select * from (call procs.pr0()) a
{code}
teiid throwing out the following stacktrace:
{code:noformat}
2017-12-20 14:28:12,939 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6) hVe+gXzCsZCA TEIID30019 Unexpected exception for request hVe+gXzCsZCA.1: java.lang.NullPointerExcep
tion
at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:387)
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:2080)
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1462)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.query.optimizer.relational.RelationalPlanner.planSubqueries(RelationalPlanner.java:737)
at org.teiid.query.optimizer.relational.RelationalPlanner.connectSubqueryContainers(RelationalPlanner.java:696)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:220)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.query.optimizer.ProcedurePlanner.optimize(ProcedurePlanner.java:86)
at org.teiid.query.optimizer.QueryOptimizer.planProcedure(QueryOptimizer.java:206)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:146)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1719)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedProcedure(RelationalPlanner.java:1181)
at org.teiid.query.optimizer.relational.RelationalPlanner.createStoredProcedurePlan(RelationalPlanner.java:1271)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1037)
at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1709)
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1532)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:660)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
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)
{code}
> NPE in QueryResolver when calling virtual procedure
> ---------------------------------------------------
>
> Key: TEIID-5186
> URL: https://issues.jboss.org/browse/TEIID-5186
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 10.0.1
> Environment: teiid-10.0.1 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
>
> When running query:
> {code:sql}
> select * from (call procs.pr0()) a
> {code}
> teiid is throwing out the following stacktrace:
> {code:noformat}
> 2017-12-20 14:28:12,939 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6) hVe+gXzCsZCA TEIID30019 Unexpected exception for request hVe+gXzCsZCA.1: java.lang.NullPointerExcep
> tion
> at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:387)
> at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:2080)
> at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1462)
> at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
> at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
> at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
> at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
> at org.teiid.query.optimizer.relational.RelationalPlanner.planSubqueries(RelationalPlanner.java:737)
> at org.teiid.query.optimizer.relational.RelationalPlanner.connectSubqueryContainers(RelationalPlanner.java:696)
> at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:220)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
> at org.teiid.query.optimizer.ProcedurePlanner.optimize(ProcedurePlanner.java:86)
> at org.teiid.query.optimizer.QueryOptimizer.planProcedure(QueryOptimizer.java:206)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:146)
> at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1719)
> at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedProcedure(RelationalPlanner.java:1181)
> at org.teiid.query.optimizer.relational.RelationalPlanner.createStoredProcedurePlan(RelationalPlanner.java:1271)
> at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1037)
> at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1709)
> at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1532)
> at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
> at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
> at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
> at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:660)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list