[teiid-issues] [JBoss JIRA] (TEIID-2615) Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT

Graeme Gillies (JIRA) jira-events at lists.jboss.org
Tue Aug 6 19:50:25 EDT 2013


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


More information about the teiid-issues mailing list