[teiid-issues] [JBoss JIRA] (TEIID-2358) NullPointer in EnhancedSortMergeJoinStrategy

Wed May 22 19:06:06 EDT 2013

    [ https://issues.jboss.org/browse/TEIID-2358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12776180#comment-12776180 ] 

Steven Hawkins edited comment on TEIID-2358 at 5/22/13 7:05 PM:
----------------------------------------------------------------

In both 8.4 (trunk) and 8.1 (8.1.x) I just get:
{code}
############### Got Connection
############### Timer Result: [2013-05-22 15:56:20.585]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
############### Timer Result: [2013-05-22 15:56:50.585]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
############### Timer Result: [2013-05-22 15:57:20.586]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29  
{code}
with a similar result repeated every 30 seconds.

You should try to reproduce in a stock 8.1.  If it doesn't occur, then there's a patching issue for you.  If it for some reason does occur (which doesn't match my experience) try to reproduce against latest.

      was (Author: shawkins):
    In both 8.4 (trunk) and 8.1 (8.1.x) I just get:

############### Got Connection
############### Timer Result: [2013-05-22 15:56:20.585]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
############### Timer Result: [2013-05-22 15:56:50.585]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
############### Timer Result: [2013-05-22 15:57:20.586]
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29    
@@@@@@ Row returnedDE29  

with a similar result repeated every 30 seconds.

You should try to reproduce in a stock 8.1.  If it doesn't occur, then there's a patching issue for you.  If it for some reason does occur (which doesn't match my experience) try to reproduce against latest.

> NullPointer in EnhancedSortMergeJoinStrategy
> --------------------------------------------
>
>                 Key: TEIID-2358
>                 URL: https://issues.jboss.org/browse/TEIID-2358
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.1
>            Reporter: RAKESH BALGURI
>            Assignee: Steven Hawkins
>         Attachments: EnhancedSortMergeJoinStrategyTestCases_Updated.zip
>
>
> java.lang.NullPointerException
> 	at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy$SingleTupleSource.get(EnhancedSortMergeJoinStrategy.java:79)
> 	at org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:149)
> 	at org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:59)
> 	at java.util.Collections.indexedBinarySearch(Collections.java:377)
> 	at java.util.Collections.binarySearch(Collections.java:365)
> 	at org.teiid.common.buffer.SPage.search(SPage.java:140)
> 	at org.teiid.common.buffer.STree.find(STree.java:245)
> 	at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:144)
> 	at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:203)
> 	at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:377)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> 	at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> 	at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> 	at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91)
> 	at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> 	at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:174)
> 	at org.teiid.query.processor.relational.SourceState.getRowCount(SourceState.java:127)
> 	at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.shouldIndex(EnhancedSortMergeJoinStrategy.java:306)
> 	at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMergeJoinStrategy.java:253)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:198)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> 	at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> 	at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> 	at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91)
> 	at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89)
> 	at org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:374)
> 	at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:318)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> 	at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:174)
> 	at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:186)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> 	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)
> 	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
> 	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> 	... 8 more

--
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