[JBoss JIRA] (TEIID-5260) TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5260?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5260:
------------------------------------
[~shawkins] thx a lot for the quick fix!
> 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)
8 years, 1 month
[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-5259?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-5259:
------------------------------------
I said that incorrect. Yes, it's the cache name defined for infinispan. However, the cache name is then used to define all its related properties for configuring the cache. Its that process in the bash script of using the value as part of a variable name that's the issue. And as they've indicated in CLOUD-2299, they substitute all '-' for '_' to solve the issue. But this can't be done for the teiid-alias cache name, because there's no way to override the name.
> Add the ability to override the teiid-alias-naming-cache
> --------------------------------------------------------
>
> Key: TEIID-5259
> URL: https://issues.jboss.org/browse/TEIID-5259
> Project: Teiid
> Issue Type: Enhancement
> Components: JDG Connector
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-5259?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-5259:
-------------------------------
Description: Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names. (was: Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable values. )
> Add the ability to override the teiid-alias-naming-cache
> --------------------------------------------------------
>
> Key: TEIID-5259
> URL: https://issues.jboss.org/browse/TEIID-5259
> Project: Teiid
> Issue Type: Enhancement
> Components: JDG Connector
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5260) TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5260?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5260:
---------------------------------------
Made an additional commit on master to remove the inline view in the case of having window functions specifically.
> 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)
8 years, 1 month
[JBoss JIRA] (TEIID-5260) TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5260?page=com.atlassian.jira.plugin... ]
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)
8 years, 1 month