[JBoss JIRA] (TEIID-2615) Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2615?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-2615 at 8/6/13 8:16 PM:
---------------------------------------------------------------
The central question is whether the data does have a duplicate entry or whether there is something problematic happening with the materialized view load.
Can you run the view query:
{code}select pg_class.oid as attrelid, attnum, attname, relname, nspname, IsAutoIncremented as autoinc, cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) as typoid from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname{code}
or
{code}select count(*) from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname group by attname, relname, nspname having count(*) > 1{code}
to see if there are duplicate attname, relname, nspname combinations?
was (Author: shawkins):
The central question is whether the data does have a duplicate entry or whether there is something problematic happening with the materialized view load.
Can you run the view query:
select pg_class.oid as attrelid, attnum, attname, relname, nspname, IsAutoIncremented as autoinc, cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) as typoid from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname
or
select count(*) from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname group by attname, relname, nspname having count(*) > 1
to see if there are duplicate attname, relname, nspname combinations?
> Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
> ------------------------------------------------------------------
>
> Key: TEIID-2615
> URL: https://issues.jboss.org/browse/TEIID-2615
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.5
> Environment: Teiid 8.5 from git master, running on jboss eap 6.1 using java 7 openjdk
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
>
> Hi,
> We are deploying a few dynamic vbs into our teiid environment and when we've deployed current versions of teiid from git master, we get the following error
> {noformat}
> 09:44:31,467 ERROR [org.teiid.PROCESSOR.MATVIEWS] (New I/O worker #1) TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.MATPG_RELATT.: org.teiid.core.TeiidProcessingException: TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
> at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:788) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:150) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:257) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:627) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:526) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:497) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:376) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254) [teiid-jboss-integration-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:633) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:258) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1012) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:432) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:201) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:555) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:107) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty.jar:3.6.2.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {noformat}
> When we try and run queries against it. Sometimes it happens once and goes away, other times it happens over and over.
> I can supply the vdbs themselves if needed to help debug.
> Regards,
> Graeme
--
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, 5 months
[JBoss JIRA] (TEIID-2615) Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2615?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2615:
---------------------------------------
The central question is whether the data does have a duplicate entry or whether there is something problematic happening with the materialized view load.
Can you run the view query:
select pg_class.oid as attrelid, attnum, attname, relname, nspname, IsAutoIncremented as autoinc, cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) as typoid from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname
or
select count(*) from pg_catalog.pg_attribute, pg_catalog.pg_class, pg_catalog.pg_namespace, SYS.Columns where pg_attribute.attrelid = pg_class.oid and pg_namespace.oid = relnamespace and SchemaName = nspname and TableName = relname and Name = attname group by attname, relname, nspname having count(*) > 1
to see if there are duplicate attname, relname, nspname combinations?
> Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
> ------------------------------------------------------------------
>
> Key: TEIID-2615
> URL: https://issues.jboss.org/browse/TEIID-2615
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.5
> Environment: Teiid 8.5 from git master, running on jboss eap 6.1 using java 7 openjdk
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
>
> Hi,
> We are deploying a few dynamic vbs into our teiid environment and when we've deployed current versions of teiid from git master, we get the following error
> {noformat}
> 09:44:31,467 ERROR [org.teiid.PROCESSOR.MATVIEWS] (New I/O worker #1) TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.MATPG_RELATT.: org.teiid.core.TeiidProcessingException: TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
> at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:788) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:150) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:257) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:627) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:526) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:497) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:376) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254) [teiid-jboss-integration-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:633) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:258) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1012) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:432) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) [:1.7.0_25]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:201) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
> at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:555) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:107) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty.jar:3.6.2.Final-redhat-1]
> at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty.jar:3.6.2.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {noformat}
> When we try and run queries against it. Sometimes it happens once and goes away, other times it happens over and over.
> I can supply the vdbs themselves if needed to help debug.
> Regards,
> Graeme
--
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, 5 months
[JBoss JIRA] (TEIID-2615) Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
by Graeme Gillies (JIRA)
Graeme Gillies created TEIID-2615:
-------------------------------------
Summary: Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
Key: TEIID-2615
URL: https://issues.jboss.org/browse/TEIID-2615
Project: Teiid
Issue Type: Bug
Affects Versions: 8.5
Environment: Teiid 8.5 from git master, running on jboss eap 6.1 using java 7 openjdk
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
We are deploying a few dynamic vbs into our teiid environment and when we've deployed current versions of teiid from git master, we get the following error
{noformat}
09:44:31,467 ERROR [org.teiid.PROCESSOR.MATVIEWS] (New I/O worker #1) TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.MATPG_RELATT.: org.teiid.core.TeiidProcessingException: TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:788) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:150) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:257) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:627) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:526) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:497) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:106) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:376) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254) [teiid-jboss-integration-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:135) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:133) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:633) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:258) [teiid-client-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1012) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:432) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:201) [teiid-runtime-8.5.0.Beta2-SNAPSHOT.jar:8.5.0.Beta2-SNAPSHOT]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:555) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:107) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:88) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty.jar:3.6.2.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty.jar:3.6.2.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
{noformat}
When we try and run queries against it. Sometimes it happens once and goes away, other times it happens over and over.
I can supply the vdbs themselves if needed to help debug.
Regards,
Graeme
--
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, 5 months
[JBoss JIRA] (TEIID-2207) RHQ Plugin gets NPE when getting requests for a VDB
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2207?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2207.
-----------------------------------
Fix Version/s: 8.0
Resolution: Out of Date
This turns out to be straight-forward. Prior to 8.0 our admin connections were through the Teiid comm layer and used a vdb-less session - thus the npe. This no longer occurs in 8.x as all clients must be through a vdb. I went ahead and reversed the filtering check though just so it could be better code.
A similar change should be made on 7.7.x as it's an active issue there.
> RHQ Plugin gets NPE when getting requests for a VDB
> ---------------------------------------------------
>
> Key: TEIID-2207
> URL: https://issues.jboss.org/browse/TEIID-2207
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.7.1
> Environment: SOA-P 5.3 with BZ842760 (9/13) patch applied
> Reporter: Paul Nittel
> Assignee: Johnathon Lee
> Fix For: 8.0
>
> Attachments: server.log
>
>
> Using RHQ while a long query was executing, I used the VDB's "View VDB Requests" and received no information in the UI. The server log contained the attached exception and stack trace.
> java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getRequestsUsingVDB' on component 'RuntimeEngineDeployer' with parameters [SimpleMetaType:java.lang.String:TpcrVdb, SimpleMetaType:int:1].
> at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:201)
> at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:103)
> at sun.reflect.GeneratedMethodAccessor661.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121)
--
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, 5 months
[JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1377.
-----------------------------------
Resolution: Deferred
Marking as deferred:
* this has been addressed for DTP
* this is not standard behavior (some databases support it, others do not)
* the change to support multiple result sets would be quite extensive as we have quite a bit of built in assumptions in the RequestWorkItem (and even in the driver client/server messaging).
A somewhat related issue is TEIID-2614 - but the statements need to be called in a block and can only return a single resultset.
> Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
> --------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1377
> URL: https://issues.jboss.org/browse/TEIID-1377
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Priority: Minor
>
> When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle).
> At present, no exceptions are thrown, but the queries fail to execute.
--
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, 5 months
[JBoss JIRA] (TEIID-2614) Allow anonymous procedure blocks
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2614?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2614.
-----------------------------------
Resolution: Done
Allowing the parser to treat a compound statement as a valid user command.
In parameters are supported with prepared/callable statement parameters. out is not yet supported as the driver logic would have to change to collect the out registrations - the workaround would be to use session variables. Return is not supported as well. A single result set may be returned if any of the statements returns a result set. As per the standard validation logic all returnable results must match or a validation exception will be thrown.
Also since TEIID-2103 in 8.1 it has been optional for designer procedures to be prefixed with CREATE VIRTUAL PROCEDURE. This change goes further so that the expected string form no longer includes that declaration - which is only a concern if the vdb would be deployed on a pre-8.1 server.
> Allow anonymous procedure blocks
> --------------------------------
>
> Key: TEIID-2614
> URL: https://issues.jboss.org/browse/TEIID-2614
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.5
>
>
> In some cases it is beneficial to submit a block of sql for processing rather than performing partial result processing in the client.
> Given that we are effectively using anon blocks internally, we should expose this feature for general use.
--
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, 5 months
[JBoss JIRA] (TEIID-2614) Allow anonymous procedure blocks
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2614:
-------------------------------------
Summary: Allow anonymous procedure blocks
Key: TEIID-2614
URL: https://issues.jboss.org/browse/TEIID-2614
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.5
In some cases it is beneficial to submit a block of sql for processing rather than performing partial result processing in the client.
Given that we are effectively using anon blocks internally, we should expose this feature for general use.
--
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, 5 months