[JBoss JIRA] Created: (TEIID-1617) Incorrect rewrite of subquery
by Steven Hawkins (JIRA)
Incorrect rewrite of subquery
-----------------------------
Key: TEIID-1617
URL: https://issues.jboss.org/browse/TEIID-1617
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 7.4.1
when performing a semi-join against a query with a key preserved in the semi join criteria and a non-distinct subquery the planner will incorrectly created an unnested query that does not preserve the semi-join. This can happen with either the explicit mj hint or with the query unnesting property set.
e.g.
select col2 from tbl where keyCol IN (select dupCol from tbl2)
will become
select col2 from tbl, tbl2 where keyCol = tbl2
rather than
select col2 from tbl, (select distinct dupCol from tbl2) x where keyCol = tbl2
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1591) Error thrown when attempting to use clustered cache in teiid 7.4
by Graeme Gillies (JIRA)
Error thrown when attempting to use clustered cache in teiid 7.4
----------------------------------------------------------------
Key: TEIID-1591
URL: https://issues.jboss.org/browse/TEIID-1591
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.4
Environment: teiid 7.4 deployed in jboss eap 5.1 on rhel 5 x86_64 using java
OpenJDK Runtime Environment (IcedTea6 1.7.10) (rhel-1.20.b17.el5-x86_64)
OpenJDK 64-Bit Server VM (build 14.0-b16, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
I recently upgraded one of our teiid development environments from teiid 7.3 to teiid 7.4, and now I get the following error when trying to deploy the teiid clustered cache (using the file deploy/teiid/teiid-cache-manager-jboss-beans.xml)
{code}
2011-05-18 11:32:25,672 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Configured: name=EventDistributorFactory state=Instantiated
java.lang.RuntimeException: Error configuring property: channelFactory for EventDistributorFactory
at org.jboss.kernel.plugins.dependency.ConfigureAction.dispatchSetProperty(ConfigureAction.java:112)
at org.jboss.kernel.plugins.dependency.ConfigureAction.setAttributes(ConfigureAction.java:85)
at org.jboss.kernel.plugins.dependency.ConfigureAction.installActionInternal(ConfigureAction.java:44)
at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)
at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:125)
at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:52)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.lang.IllegalArgumentException: Wrong arguments. setChannelFactory for target org.teiid.events.jboss.JGroupsEventDistributor@376d7103 expected=[org.jgroups.JChannelFactory] actual=[org.jboss.ha.framework.server.JChannelFactory]
at org.jboss.reflect.plugins.introspection.ReflectionUtils.handleErrors(ReflectionUtils.java:395)
at org.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:69)
at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)
at org.jboss.beans.info.plugins.DefaultPropertyInfo.set(DefaultPropertyInfo.java:143)
at org.jboss.beans.info.plugins.BeanInfoUtil.set(BeanInfoUtil.java:177)
at org.jboss.beans.info.plugins.AbstractBeanInfo.setProperty(AbstractBeanInfo.java:289)
at org.jboss.kernel.plugins.dependency.PropertyDispatchWrapper.execute(PropertyDispatchWrapper.java:113)
at org.jboss.kernel.plugins.dependency.ExecutionWrapper.execute(ExecutionWrapper.java:47)
at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchExecutionWrapper(KernelControllerContextAction.java:111)
at org.jboss.kernel.plugins.dependency.ConfigureAction.dispatchSetProperty(ConfigureAction.java:107)
... 49 more
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1663) Local Transactions not working
by Ramesh Reddy (JIRA)
Local Transactions not working
------------------------------
Key: TEIID-1663
URL: https://issues.jboss.org/browse/TEIID-1663
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1, 7.5
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Priority: Blocker
Fix For: 7.4.1, 7.5
while turning off the verbose comment of the suspend call, legitimate suspend call was also ignored to call, thus leading to
23:44:10,573 ERROR [PROCESSOR] Unexpected exception for request iQcf7D9ZVQ8h.0
java.lang.IllegalStateException: BaseTransaction.checkTransactionState - [com.arjuna.ats.internal.jta.transaction.arjunacore.alreadyassociated] [com.arjuna.ats.internal.jta.transaction.arjunacore.alreadyassociated] thread is already associated with a transaction!
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1609) Delay required when get connection to admin deployed VDB
by Andriy Rokhmanov (JIRA)
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml", ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Chorus");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1599) Event based cache invalidation
by Mark Addleman (JIRA)
Event based cache invalidation
------------------------------
Key: TEIID-1599
URL: https://issues.jboss.org/browse/TEIID-1599
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
Priority: Minor
In addition to invalidating cached results by time, I'd like the ability to invalidate cache based on an event. I think this is the moral equivalent of the existing functionality to reset a materialized view. I would like to scope the invalidation to particular tables or sets of tables. For example, suppose I cached the results of the following statements:
SELECT * FROM A
SELECT * FROM B
SELECT * FROM A,B
A call to invalidate A would invalidate the cached result sets from the first and third statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months