[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan updated TEIID-1868: ---------------------------- Description: We have about 20 tables translated to 20 materialized view (internal with cache hint - /*+ cache(ttl:14400000) */). 2 dreaded behaviours: 1. On start up with application (application starts hitting app), certain query will cause ASSERTION FAILED 2. On reloading cache, teiid starts to fails with same behaviour. 2011-12-14 18:26:40,201 WARN [org.teiid.CONNECTOR] (Worker2228_QueryProcessorQueue1132419) Connector worker process failed for atomic-request=mCMnhhZ9fLcU.100.3.334092 [JDBCExecutionException] 0: Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s):[....] 1 [TeiidSQLException]ASSERTION FAILED: expected reference to be not null 2 [TeiidException]ASSERTION FAILED: expected reference to be not null 3 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) 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:662) Caused by: org.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:497) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:214) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86) ... 12 more Caused by: [TeiidException]ASSERTION FAILED: expected reference to be not null 1 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:177) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:557) at org.teiid.dqp.internal.process.RequestWorkItem.attemptClose(RequestWorkItem.java:335) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:218) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) ... 6 more Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:366) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:141) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:130) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:410) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:402) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:437) 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.JoinStrategy.openLeft(JoinStrategy.java:95) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:152) 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.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:129) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:445) at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:218) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203) at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) 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.nextTuple(AbstractTupleSource.java:48) at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214) at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168) at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96) at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) 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:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) ... 7 more 2011-12-14 18:26:40,201 WARN [org.teiid.PROCESSOR] (Worker2205_QueryProcessorQueue1132421) Processing exception 'Error Code:0 Message:Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s): [....] for request mCMnhhZ9fLcU.100. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.core.util.Assertion.failed(Assertion.java:73). Enable more detailed logging to see the entire stacktrace. was: We have about 20 tables in materialized view (internal with cache hint - /*+ cache(ttl:14400000) */). 2 dreaded behaviours: 1. On start up with application (application starts hitting app), certain query will cause ASSERTION FAILED 2. On reloading cache, teiid starts to fails with same behaviour. 2011-12-14 18:26:40,201 WARN [org.teiid.CONNECTOR] (Worker2228_QueryProcessorQueue1132419) Connector worker process failed for atomic-request=mCMnhhZ9fLcU.100.3.334092 [JDBCExecutionException] 0: Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s):[....] 1 [TeiidSQLException]ASSERTION FAILED: expected reference to be not null 2 [TeiidException]ASSERTION FAILED: expected reference to be not null 3 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) 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:662) Caused by: org.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:497) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:214) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86) ... 12 more Caused by: [TeiidException]ASSERTION FAILED: expected reference to be not null 1 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:177) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:557) at org.teiid.dqp.internal.process.RequestWorkItem.attemptClose(RequestWorkItem.java:335) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:218) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) ... 6 more Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:366) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:141) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:130) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:410) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:402) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:437) 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.JoinStrategy.openLeft(JoinStrategy.java:95) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:152) 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.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:129) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:445) at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:218) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203) at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) 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.nextTuple(AbstractTupleSource.java:48) at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214) at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168) at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96) at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) 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:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) ... 7 more 2011-12-14 18:26:40,201 WARN [org.teiid.PROCESSOR] (Worker2205_QueryProcessorQueue1132421) Processing exception 'Error Code:0 Message:Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s): [....] for request mCMnhhZ9fLcU.100. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.core.util.Assertion.failed(Assertion.java:73). Enable more detailed logging to see the entire stacktrace. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1868: --------------------------------------- I think this will still occur on later 7.x versions. There is probably a mismatch between how a mat view is being initially defined and subsequent access. Are you using alter view statements? Can you provide more details on what the view definition that is failing? Or possibly even provide a paired down vdb? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- Same issue with 7.6. Assertion failed after ttl expires and user hits the next query (teiid will try to load about 3-4 tables before throwing Assertion failed) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- Try different means to refresh using refresh materialize view method on a routine basis, it will work for a while; however, when ASSERTION FAILED happens, there is no way to refresh the view. Is there a work around? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1868: --------------------------------------- It doesn't appear that there are indexes involved here just from the stacktrace. Also after trying to reproduce this I think the issue has to do with performing a join that has an implicit type conversion. In my scenario if I either make the view not matierialized or make the type conversion explicit, then the error goes away. Can you see if you have an implicit type conversion occurring in a join against a materialized view? I'll have a fix shortly for this scenario shortly. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- could not test on 7.6 as when views are loading, the same happens for 7.6.0 final as well: 2011-12-24 23:43:54,395 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue962) Unexpected exception for request k95WjlCHh//z.10 java.lang.NullPointerException at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.setColStatEstimates(NewCalculateCostUtil.java:427) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.setCardinalityEstimate(NewCalculateCostUtil.java:328) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.estimateSetOpCost(NewCalculateCostUtil.java:274) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeNodeCost(NewCalculateCostUtil.java:226) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:158) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeCostForTree(NewCalculateCostUtil.java:144) at org.teiid.query.optimizer.relational.rules.JoinRegion.initializeCostingInformation(JoinRegion.java:399) at org.teiid.query.optimizer.relational.rules.RulePlanJoins.execute(RulePlanJoins.java:170) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:490) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:249) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:512) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1868: --------------------------------------- Did you apply the patch from my previous comment? Can you supply more context for the next exception - is it happening with the same query, or is it an unrelated issue? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- re run on 7.6 with patch : 2011-12-29 01:05:00,962 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8037) Loaded materialized view table 2011-12-29 01:05:00,977 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8050) Loading materialized view table 2011-12-29 01:05:01,368 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8050) Loaded materialized view table 2011-12-29 01:05:01,368 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8096) Loading materialized view table 2011-12-29 01:05:07,274 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8096) Loaded materialized view table 2011-12-29 01:05:07,274 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker11_QueryProcessorQueue8916) Loading materialized view table 2011-12-29 01:05:18,853 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker19_QueryProcessorQueue8924) Loading materialized view table 2011-12-29 01:05:18,868 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker15_QueryProcessorQueue8926) Loading materialized view table 2011-12-29 01:05:18,931 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker15_QueryProcessorQueue8926) Loaded materialized view table 2011-12-29 01:05:18,978 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker19_QueryProcessorQueue8924) Loaded materialized view table 2011-12-29 01:05:19,462 ERROR [org.teiid.PROCESSOR] (Worker19_QueryProcessorQueue8934) Unexpected exception for request sY67VugAnV/u.100 java.lang.IndexOutOfBoundsException: Index: 3, Size: 3 at java.util.ArrayList.RangeCheck(Unknown Source) at java.util.ArrayList.get(Unknown Source) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.filterVirtualElements(RuleAssignOutputElements.java:474) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:193) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:277) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:277) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:188) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.execute(RuleAssignOutputElements.java:114) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:490) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:249) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:512) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) Also notice some warnings: 2011-12-29 01:03:26,662 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue2992) Not performing dependent join using source $dsc/id3, since the number of distinct rows for expression XXXXXXXX exceeds 922.356. You should ensure that your source statistics, including column distinct value counts, accurately reflect the source or use a MAKE_DEP hint to force the join. 2011-12-29 01:04:00,100 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue6225) Not performing dependent join using source $dsc/id3, since the number of distinct rows for expression XXXXXXXX exceeds 922.356. You should ensure that your source statistics, including column distinct value counts, accurately reflect the source or use a MAKE_DEP hint to force the join. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- It seems that original error has been addressed in the patch as I let it run and refresh and it hasn't show error yet. However, we cannot upgrade to 7.6.x due to RuleAssignOutputElements error and "there are alot of warning WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue2992) Not performing dependent join using source $dsc/id3, since the number of distinct rows for expression XXXXXXXX exceeds 922.356. You should ensure that your source statistics, including column distinct value counts, accurately reflect the source or use a MAKE_DEP hint to force the join." -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] John Tan commented on TEIID-1868: --------------------------------- Steve, 1. I have a number of vdb in which this is the most complicated. Others I do not see such error. 2. We have tried to approach red hat earlier on last year and also a few months ago but EDS is not yet "in service" which is disappointing and also I understand from the team that there is some "control" on EDS eval. In my previous organisation we used mm quite extensively. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1868: --------------------------------------- The fix for TEIID-1893 addresses the NPE seen when calculating costs. That should just leave the RuleAssignOutputElements error. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-1868: ------------------------------------------- Bugzilla Update: Perform -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-1868: ------------------------------------------------ Len DiMaggio <ldimaggi(a)redhat.com&gt; made a private comment on [bug 807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-1868: ------------------------------------------------ jolee(a)redhat.com made a private comment on [bug 807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-1868: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870] from NEW to MODIFIED -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin... ] Paul Nittel commented on TEIID-1868: ------------------------------------ I successfully tested this with the Roll up patch EDS_5.2_20120501 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira