Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 8.4.1, 8.5
Affects Version/s: 8.2
Component/s: Query Engine
Labels:
None

Description

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

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]

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

Attachments

Activity

People

Assignee:: Steven Hawkins

Reporter:: Graeme Gillies (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2013/08/06 7:49 PM

Updated:: 2014/09/02 9:20 AM

Resolved:: 2013/08/07 9:06 AM