[JBoss JIRA] (TEIID-2675) Ensure that user defined aggregate functions don't require additional syntax
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2675:
-------------------------------------
Summary: Ensure that user defined aggregate functions don't require additional syntax
Key: TEIID-2675
URL: https://issues.jboss.org/browse/TEIID-2675
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 8.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.6
User defined aggregates require additional syntax if they look like simple functions. This is not ideal, but was not addressed initially due to the lack of effective rewrite support in the resolver and all of the logic that is built around the differentiation between Function and AggregateSymbol classes.
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2674) Makedep not honored with aggregate decomposition
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2674:
-------------------------------------
Summary: Makedep not honored with aggregate decomposition
Key: TEIID-2674
URL: https://issues.jboss.org/browse/TEIID-2674
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
A makedep hint on a joined table under aggregation for a source that does not support the grouping will result in the makedep hint being ignored - for example where pm1 does not support join/aggregation:
select count(x.e2), e1 from pm1.g1 x makedep, pm1.g2 where x.e3 = pm1.g2.e3 group by e1
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2672) java.lang.AssertionError: Assertion failed in SourceState
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2672?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2672:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1012540|https://bugzilla.redhat.com/show_bug.cgi?id=1012540] from NEW to ASSIGNED
> java.lang.AssertionError: Assertion failed in SourceState
> ---------------------------------------------------------
>
> Key: TEIID-2672
> URL: https://issues.jboss.org/browse/TEIID-2672
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.5
> Environment: Teiid 8.5 and JBoss EAP6.1.0Alpha
> Reporter: Rakesh Balguri
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
> Attachments: Join_SQL.txt
>
>
> 23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:223)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:109)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:145)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307)
> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
> at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)
> at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]
> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)
> at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)
> at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2672) java.lang.AssertionError: Assertion failed in SourceState
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2672?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-2672:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1012540
> java.lang.AssertionError: Assertion failed in SourceState
> ---------------------------------------------------------
>
> Key: TEIID-2672
> URL: https://issues.jboss.org/browse/TEIID-2672
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.5
> Environment: Teiid 8.5 and JBoss EAP6.1.0Alpha
> Reporter: Rakesh Balguri
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
> Attachments: Join_SQL.txt
>
>
> 23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:223)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:109)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:145)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307)
> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
> at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)
> at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]
> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)
> at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)
> at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2672) java.lang.AssertionError: Assertion failed in SourceState
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2672?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2672.
-----------------------------------
Resolution: Done
This can happen in situations where we attempt a prefetch (which will generally happen due to blocking) and not directly performing a sort of a child that is providing a non-final tuple buffer (should only be a dup-removal). In simple plans the dup remove is combined into the sort operation. But in some plans with intervening nodes or a cross join we will hit this issue.
This does affect 7.7.x as well.
> java.lang.AssertionError: Assertion failed in SourceState
> ---------------------------------------------------------
>
> Key: TEIID-2672
> URL: https://issues.jboss.org/browse/TEIID-2672
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.5
> Environment: Teiid 8.5 and JBoss EAP6.1.0Alpha
> Reporter: Rakesh Balguri
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
> Attachments: Join_SQL.txt
>
>
> 23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:223)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:109)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:145)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307)
> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
> at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)
> at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]
> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)
> at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)
> at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2672) java.lang.AssertionError: Assertion failed in SourceState
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2672?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2672:
----------------------------------
Fix Version/s: 8.4.1
8.6
Component/s: Query Engine
> java.lang.AssertionError: Assertion failed in SourceState
> ---------------------------------------------------------
>
> Key: TEIID-2672
> URL: https://issues.jboss.org/browse/TEIID-2672
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.5
> Environment: Teiid 8.5 and JBoss EAP6.1.0Alpha
> Reporter: Rakesh Balguri
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
> Attachments: Join_SQL.txt
>
>
> 23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:223)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:109)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:145)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307)
> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
> at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)
> at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]
> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)
> at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)
> at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2309) Add support for "conformed" tables in Teiid
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2309?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2309:
---------------------------------------
The initial approach is to add a conformed sources extension property on tables. As mentioned about this could be set at design time, in the vdb.xml, or even at runtime. The property is expected to a comma separated list of physical schema names.
There is no expectation that a metadata entry exists on the other schemas. The drawback of course is that we won't have source specific metadata (just as with multi-source) - which means that all source table/column names must be the same.
We are also making the simplifying assumption that the capabilities are the same across conformed sources. This will likely need to be addressed later if this feature is used when the sources are dissimilar.
The engine will take the list of conformed sources and associated a set of model metadata ids to the corresponding access node. The logic considering joins and subqueries have been altered to also consider the conformed sets when making pushdown decisions. To fit well with the current logic the subquery handling will only check for conformed sources for the subquery - not in the parent. So having a conformed table in the subquery will pushdown as expected, but not vice versa. The logic for select/project/grouping/set pushdown was also updated to narrow the conformed sets as the access node.
In some more complex situations the logic for grouping access for pushdown will likely need to be updated as this approach is entirely greedy at this point - whereas the order in which join sources are grouped for pushdown can matter with conformed tables. For most simplistic situations though this handling should be sufficient.
> Add support for "conformed" tables in Teiid
> -------------------------------------------
>
> Key: TEIID-2309
> URL: https://issues.jboss.org/browse/TEIID-2309
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.6
>
>
> Teiid would support tables from different data sources being marked as "conformed", meaning they are the same (or perhaps a different name). When optimising a query, it would take the conformity into account and choose the appropriate copy of the table (presumably one in the same database as other tables in the query, if available). I would not regard it as a problem if Teiid *required* the dimensions to be strictly the same as opposed to permitting subsets, though as with so many areas, it would be up to the user to ensure this was really true: I would not expect the engine to do anything to verify that the tables really were conformed.
> Usecase:
> In Data Warehousing, it is relatively common to have multiple copies of the same dimensions spread over multiple Data Warehouses or Marts, or in the same Data Warehouse when associated with different Fact Tables. If these copies are either identical or strict subsets of an idealised dimension (and, by extension, share *exactly* the same naming and structure), then they may be said to be "conformed". It is expected that the dimension includes at least the values required to support the facts in the database in which it occurs or the Fact Table to which it is paired.
> Example:
>
> Source S1:
>
> BIGBIGBIG (millions of rows)
> bigkey
> ccy
> other_stuff
>
> CURRENCY (100s of rows) let's call it S1_CCY if we need to distinguish
> ccy
> ccy_name
>
>
> Source S2:
>
> BIGGER (millions of rows)
> biggerkey
> bigkey
> ccy
> more_stuff
>
> CURRENCY (100s of rows) similarly, S2_CCY
> ccy
> ccy_name
>
>
> When executing:
>
> SELECT B.*
> FROM BIGBIGBIG B,
> CURRENCY CCY
> WHERE B.ccy = CCY.ccy
> AND CCY.ccy_name LIKE "%DOLLAR%"
>
> Then it is clearly advantageous to use the copy of CURRENCY in S1 and re-write the query using S1_CCY. In this situation, federation is eliminated completely.
>
--
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
12 years, 2 months