[teiid-issues] [JBoss JIRA] Updated: (TEIID-1348) Internal Mat View of table with Primary Key gets duplicate key error when populating temporary mat view table

[Paul Nittel (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Nittel updated TEIID-1348:
-------------------------------

    Summary: Internal Mat View of table with Primary Key gets duplicate key error when populating temporary mat view table  (was: Internal Mat View of table with Primary Key gets dpulicate key error when populating temporary mat view table)


> Internal Mat View of table with Primary Key gets duplicate key error when populating temporary mat view table
> -------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1348
>                 URL: https://jira.jboss.org/browse/TEIID-1348
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1.1
>         Environment: Fedora 12, SOA-P ER3, JBDS 4.0 Beta1
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>             Fix For: 7.1.1
>
>         Attachments: MatViewMania_SonOf_MPS.zip, server.log.2010-11-04-10
>
>
> I was testing Internal Materialized Views when I encountered this. I had modeled a bookInfo (books and publishers) view with a PK of the ISBN column. This was cloned to SonOfbookInfo and materialized views set to true. I deployed this in a VDB and queried with SQuirreL:
> select title from BooksInfo.SonOfbookInfo
> This resulted in a duplicate key error (excerpt below... whole log is attached.)
> 2010-11-04 10:50:16,450 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker99_QueryProcessorQueue3659) Failed to load materialized view table #MAT_BOOKSINFO.SONOFBOOKINFO.
> [TeiidProcessingException]Duplicate key
> 	at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:550)
> 	at org.teiid.query.tempdata.TempTable.access$200(TempTable.java:71)
> 	at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:106)
> 	at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:207)
> 	at org.teiid.query.tempdata.TempTable.insert(TempTable.java:446)
> 	at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:513)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170)
> 	at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197)
> 	at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:110)
> 	at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:98)
> 	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134)
> 	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:249)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:183)
> 	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> 	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189)
> 	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> 	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> 	at java.lang.Thread.run(Thread.java:619)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira