[JBoss JIRA] (TEIID-2331) TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
by Mark Addleman (JIRA)
[ https://issues.jboss.org/browse/TEIID-2331?page=com.atlassian.jira.plugin... ]
Mark Addleman commented on TEIID-2331:
--------------------------------------
Just to be clear: The query is already cancelled and then the NPE occurs, so the client is not going to miss any results?
btw, thanks for dogging this
> TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
> ------------------------------------------------------------------------------------------
>
> Key: TEIID-2331
> URL: https://issues.jboss.org/browse/TEIID-2331
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Environment: Windows 7
> Reporter: Sabina Norderhaug
> Assignee: Steven Hawkins
> Priority: Minor
>
> We are getting this exception during continious execution. Looks like client cancelling the execution
> 16:13:16,171 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue902) TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:753)
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:557)
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:191)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:166)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_03]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_03]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-2331) TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2331?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-2331:
-----------------------------------
I was able to reproduce this. It does specifically happen in the continuous case when there is a batch delivered after a cancel has taken effect. The continuous check in the results method is causing the check of the receiver to be skipped.
> TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
> ------------------------------------------------------------------------------------------
>
> Key: TEIID-2331
> URL: https://issues.jboss.org/browse/TEIID-2331
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Environment: Windows 7
> Reporter: Sabina Norderhaug
> Assignee: Steven Hawkins
> Priority: Minor
>
> We are getting this exception during continious execution. Looks like client cancelling the execution
> 16:13:16,171 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue902) TEIID30019 Unexpected exception for request kfhsdoaNXYfM.1: java.lang.NullPointerException
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:753)
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:557)
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:191)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:166)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_03]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_03]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-196) Support creation of temp tables on physical sources.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-196?page=com.atlassian.jira.plugin.... ]
Steven Hawkins commented on TEIID-196:
--------------------------------------
The simplest (lowest effort) design would be an extension of our DDL/temp table syntax:
CREATE FOREIGN TEMPORARY TABLE name (...) ON source [AS 'native sql']
The options clauses would specify the name in source etc as appropriate and the native sql would be executed via the native query procedure facility if applicable. This side-steps any need in our language to add support for additional source constructs, such as alternative index types, additional constraints etc. So this would effectively be a hybrid of our internal temp logic and standard pushdown logic.
We would also likely have to allow a drop to be specified with native sql. We might want to still perform some metadata import from the source as to not make the full metadata specification too onerous. From the perspective of Teiid this will be treated as a temporary table in so much as it will be session scoped, but there would not need to be a restriction on the source side as to the table type.
> Support creation of temp tables on physical sources.
> ----------------------------------------------------
>
> Key: TEIID-196
> URL: https://issues.jboss.org/browse/TEIID-196
> Project: Teiid
> Issue Type: Feature Request
> Components: Connector API, Query Engine
> Affects Versions: 6.0.0
> Reporter: Ken Johnson
> Fix For: 8.3
>
>
> This is a multi-part request.
> First, the system should support creation of temporary tables using a physical backing store rather than buffer manger. Given multi-pass SQL's heavy use of temp tables, buffer manager can easily be overloaded with large interim results stored in temp tables.
> Second, this should be a user-configurable behavior. For example, user might be able to choose a system-level or session-level default from among:
> -- memory/cache
> -- a source represented by a connector binding
> -- a distinct temp source defined with it's own connection parameters (possibly another schema in the repository DB instance)
> Ideally default selectoin should be override-able at temp table creation time through a DDL extension
> In the case where multiple temp tables have been created on a source via connector, the query planner should recognize this and leverage pushdown to the temp store when later query passes access multiple temp tables.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1226?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1226:
----------------------------------
Fix Version/s: (was: 8.3)
Pulling out of the release. The extra language work does not yet seem to be warranted. Another approach would be to just allow for the use of prepared plans implicitly when using dynamic sql with the using clause.
> Reuse dynamic sql plans and allow for prepared statements in procedure logic
> ----------------------------------------------------------------------------
>
> Key: TEIID-1226
> URL: https://issues.jboss.org/browse/TEIID-1226
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 7.1
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Minor
>
> Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse.
> Also procedure logic should have a mechanism to execute prepared statements for further plan reuse.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months