[teiid-issues] [JBoss JIRA] (TEIID-5260) TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
Steven Hawkins (JIRA)
issues at jboss.org
Wed Feb 14 16:13:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5260.
-----------------------------------
Fix Version/s: 10.1.1
10.0.4
10.2
Resolution: Done
Removed the call to remove the inline view in the case of an insert into - as this does not work given that there is an intermediate source node representing the into group and the actual inline view node is not removed. We can address this later if needed, but for now the inline view will simply be included in the source insert.
> TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
> ---------------------------------------------------------------------------------------
>
> Key: TEIID-5260
> URL: https://issues.jboss.org/browse/TEIID-5260
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 10.1
> Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1.1, 10.0.4, 10.2
>
>
> Follow up ticket for https://issues.jboss.org/browse/TEIID-5153 issue.
> When running the following query:
> {code:sql}
> select * into test_pg.test_rank_copy from views.v ;;
> {code}
> teiid throws out the following error message:
> {code:noformat}
> 2018-02-14 17:43:06,838 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue8) snRPeUo3G+nS TEIID30020 Processing exception for request snRPeUo3G+nS.0 'TEIID30504 test_pg: 0 TEII
> D11013:TEIID11004 Error executing statement(s): [SQL: INSERT INTO "public"."test_rank_copy" ("expr1") SELECT g_0.expr1 FROM v AS g_0]'. Originally TeiidProcessingException 'ERROR:
> relation "v" doesn't exist
> Position: 72' QueryExecutorImpl.java:2157.: org.teiid.core.TeiidProcessingException: TEIID30504 test_pg: 0 TEIID11013:TEIID11004 Error executing statement(s): [SQL: INSERT INTO "pub
> lic"."test_rank_copy" ("expr1") SELECT g_0.expr1 FROM v AS g_0]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:398)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)
> 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)
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11013:TEIID11004 Error executing statement(s): [SQL: INSERT INTO "public"."test_rank_copy" ("expr1") SELECT g_0.e
> xpr1 FROM v AS g_0]
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:345)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:82)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:396)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)
> at com.sun.proxy.$Proxy36.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)
> ... 6 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation "v" doesn't exist
> Position: 72
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list