[JBoss JIRA] Created: (TEIID-1583) importer.useFullSchemaName property default value is incorrectly documented
by Scott Dawson (JIRA)
importer.useFullSchemaName property default value is incorrectly documented
---------------------------------------------------------------------------
Key: TEIID-1583
URL: https://issues.jboss.org/browse/TEIID-1583
Project: Teiid
Issue Type: Bug
Affects Versions: 7.3
Environment: JBoss AS 5.1
Teiid 7.3
Reporter: Scott Dawson
Assignee: Steven Hawkins
In the Teiid Reference Document, table 10.4 'Importer Properties' in section 10.2.2 'JDBC Translator', specifies the default value for the useFullSchemaName property as 'true' which is incorrect, it defaults to 'false'. As Ramesh Reddy says in the forum thread (see forum link), it may be preferable to change the code to match the documentation.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months
[JBoss JIRA] Created: (TEIID-1588) Failover does not work correctly when server nodes are behind proxy
by Boris Belovic (JIRA)
Failover does not work correctly when server nodes are behind proxy
-------------------------------------------------------------------
Key: TEIID-1588
URL: https://issues.jboss.org/browse/TEIID-1588
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.1.1
Environment: Fedora 14, JDK1.6
Reporter: Boris Belovic
Assignee: Steven Hawkins
I wrote simple proxy which simply send data from one port to another. I've put 2 node cluster behind this proxy.
Proxy works like this: Client connects to the interface of a proxy and then proxy send all data to cluster. When I stop the proxy, the proxy stops sending data from client to server - this is used as a simulation of cluster node failure.
Then I ran this scenario:
1. Query data from cluster, data retrieved without any problems.
2. Then, on the proxy I tried to turn off (block access to) each node of a cluster.
When I stop the proxy I've got following exception:
May 16, 2011 1:50:04 PM org.teiid.jdbc.StatementImpl executeSql
[testng] WARNING: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE.
[testng] org.teiid.jdbc.TeiidSQLException: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
[testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
[testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:917)
[testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:479)
[testng] at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:324)
[testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.select(TeiidClusteringTest.java:141)
[testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.testFailover(TeiidClusteringTest.java:72)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[testng] at java.lang.reflect.Method.invoke(Method.java:597)
[testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:641)
[testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:677)
[testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:850)
[testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1154)
[testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:137)
[testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121)
[testng] at org.testng.TestRunner.runWorkers(TestRunner.java:1108)
[testng] at org.testng.TestRunner.privateRun(TestRunner.java:737)
[testng] at org.testng.TestRunner.run(TestRunner.java:596)
[testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:315)
[testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:310)
[testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:272)
[testng] at org.testng.SuiteRunner.run(SuiteRunner.java:221)
[testng] at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
[testng] at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
[testng] at org.testng.TestNG.runSuitesSequentially(TestNG.java:1027)
[testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:964)
[testng] at org.testng.TestNG.run(TestNG.java:896)
[testng] at org.testng.TestNG.privateMain(TestNG.java:1193)
[testng] at org.testng.TestNG.main(TestNG.java:1153)
[testng] Caused by: java.util.concurrent.ExecutionException: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:317)
[testng] at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:348)
[testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:915)
[testng] ... 28 more
[testng] Caused by: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[testng] at java.lang.reflect.Method.invoke(Method.java:597)
[testng] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:107)
[testng] at $Proxy12.read(Unknown Source)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)
[testng] ... 29 more
[testng] Caused by: java.io.EOFException
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:166)
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147)
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81)
[testng] at java.io.ObjectInputStream.readObject(ObjectInputStream.java:344)
[testng] at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253)
[testng] ... 36 more
[testng] org.teiid.jdbc.TeiidSQLException: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE.
[testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:102)
[testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:483)
[testng] at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:324)
[testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.select(TeiidClusteringTest.java:141)
[testng] at org.jboss.soa.clustering.teiid.TeiidClusteringTest.testFailover(TeiidClusteringTest.java:72)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[testng] at java.lang.reflect.Method.invoke(Method.java:597)
[testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:641)
[testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:677)
[testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:850)
[testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1154)
[testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:137)
[testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121)
[testng] at org.testng.TestRunner.runWorkers(TestRunner.java:1108)
[testng] at org.testng.TestRunner.privateRun(TestRunner.java:737)
[testng] at org.testng.TestRunner.run(TestRunner.java:596)
[testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:315)
[testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:310)
[testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:272)
[testng] at org.testng.SuiteRunner.run(SuiteRunner.java:221)
[testng] at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
[testng] at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
[testng] at org.testng.TestNG.runSuitesSequentially(TestNG.java:1027)
[testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:964)
[testng] at org.testng.TestNG.run(TestNG.java:896)
[testng] at org.testng.TestNG.privateMain(TestNG.java:1193)
[testng] at org.testng.TestNG.main(TestNG.java:1153)
[testng] Caused by: org.teiid.jdbc.TeiidSQLException: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
[testng] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
[testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:917)
[testng] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:479)
[testng] ... 27 more
[testng] Caused by: java.util.concurrent.ExecutionException: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:317)
[testng] at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:348)
[testng] at org.teiid.jdbc.StatementImpl.sendRequestMessageAndWait(StatementImpl.java:915)
[testng] ... 28 more
[testng] Caused by: [SingleInstanceCommunicationException]
[testng] 1 [EOFException]
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[testng] at java.lang.reflect.Method.invoke(Method.java:597)
[testng] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:107)
[testng] at $Proxy12.read(Unknown Source)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)
[testng] ... 29 more
[testng] Caused by: java.io.EOFException
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:166)
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147)
[testng] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81)
[testng] at java.io.ObjectInputStream.readObject(ObjectInputStream.java:344)
[testng] at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114)
[testng] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253)
[testng] ... 36 more
[testng] @@ Message: Error trying to execute a statement SELECT name, CLUSTER_NAME FROM ClusterTable OPTION NOCACHE.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months
[JBoss JIRA] Created: (TEIID-1627) within execution factory: hanging while executing query against same teiid instance
by Mark Addleman (JIRA)
within execution factory: hanging while executing query against same teiid instance
------------------------------------------------------------------------------------
Key: TEIID-1627
URL: https://issues.jboss.org/browse/TEIID-1627
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Mark Addleman
Assignee: Steven Hawkins
I have an execution factory that derives from TeiidExecutionFactory. Its job is to connect to the same Teiid instance, and execute a rewritten query. We use this to support dynamic view definitions. Below is the createResultSetExecution method:
@Override
public ResultSetExecution createResultSetExecution(final QueryExpression command,
final ExecutionContext executionContext,
final RuntimeMetadata metadata,
final Connection conn) throws TranslatorException
{
// TODO: This is not correct; this should be only called once for
// connection creation
obtainedConnection(conn);
return new ResultSetExecution()
{
private final List<Tuple> gatherResults = new ArrayList<Tuple>();
int i = 0;
@Override
public void execute() throws TranslatorException
{
try
{
ViewExecutionFactory.this.logger.info("execute() start");
ViewExecutionFactory.this.logger.info("before prepareStatement");
final PreparedStatement prepareStatement =
conn.prepareStatement("SELECT alert_id, alert_msg, lpar_id FROM demoalertdata.chorus.public.demo_alert");
ViewExecutionFactory.this.logger.info("beofre executeQuery");
final ResultSet resultSet = prepareStatement.executeQuery();
while (resultSet.next())
{
this.gatherResults.add(new Tuple(resultSet));
}
ViewExecutionFactory.this.logger.info("before reuslt set close");
resultSet.close();
ViewExecutionFactory.this.logger.info("before prepare statement close");
prepareStatement.close();
} catch (final Exception e)
{
ViewExecutionFactory.this.logger.error("Error during execute", e);
throw new TranslatorException(e);
} finally
{
ViewExecutionFactory.this.logger.info("execute() end");
}
}
@Override
public void close()
{
//
}
@Override
public void cancel() throws TranslatorException
{
//
}
@Override
public List<?> next() throws TranslatorException, DataNotAvailableException
{
if (this.i < this.gatherResults.size())
{
final List<?> asList = this.gatherResults.get(this.i++).asList();
ViewExecutionFactory.this.logger.info("RESULT " + asList);
return asList;
}
else
{
return null;
}
}
};
}
Under 7.4, when we issue a query against this translator, the thread hangs during the executeQuery() method. It works under 7.3.
Not sure if it's relevant but we connect to the local Teiid instance in the getConnection() method:
@Override
synchronized final public Connection getConnection(final DataSource ds) throws TranslatorException
{
if (this.metadataInitialized)
{
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Chorus");
teiidDataSource.setUser("admin");
teiidDataSource.setPassword("teiid");
try
{
return teiidDataSource.getConnection();
} catch (final SQLException e)
{
throw new TranslatorException(e);
}
}
else
{
return null;
}
}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months
[JBoss JIRA] Created: (TEIID-1559) Dynamic VDB deployed in inactive state on Oracle11g
by Boris Belovic (JIRA)
Dynamic VDB deployed in inactive state on Oracle11g
---------------------------------------------------
Key: TEIID-1559
URL: https://issues.jboss.org/browse/TEIID-1559
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.1.1
Environment: Oracle 11g R2, driver version: 11.2.0.1.0
Teiid 7.1.1 in SOA-P 5.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Dynamic VDB is deployed in inactive state on SOA-P 5.1 server configured with Oracle 11g R2 database. First I deploy both datasources required by VDB and then dynamic VDB itself. But the VDB remains in inactive state, despite all datasources referred by this VDB are in place (= deployed correctly). Few seconds after deployment of VDB I got this exception from the server.
08:42:24,335 INFO [RUNTIME] VDB "myvdb-1" - "Employees" model metadata is currently being loaded. Start Time: 4/19/11 8:42 AM
08:42:24,355 INFO [PROCESSOR] Clearing prepared plan cache
08:42:24,358 INFO [RUNTIME] VDB "myvdb.1[Employees[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state.
08:42:50,307 WARN [RunnableTaskWrapper] Unhandled throwable for runnable: org.teiid.deployers.VDBDeployer$1@13bf30c
java.lang.AssertionError: Duplicate Table APEX_ACTIVITY_LOG
at org.teiid.metadata.Schema.addTable(Schema.java:42)
at org.teiid.metadata.MetadataFactory.addTable(MetadataFactory.java:82)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:195)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:110)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:268)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:80)
at org.teiid.dqp.internal.datamgr.ConnectorManager.getMetadata(ConnectorManager.java:125)
at org.teiid.deployers.VDBDeployer.loadMetadata(VDBDeployer.java:310)
at org.teiid.deployers.VDBDeployer.access$000(VDBDeployer.java:59)
at org.teiid.deployers.VDBDeployer$1.run(VDBDeployer.java:293)
at org.jboss.util.threadpool.RunnableTaskWrapper.run(RunnableTaskWrapper.java:147)
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)
I also tried deploying this VDB on MySQL 5.1 and PostgreSQL 8.3 and the VDB was deployed without any problems or exceptions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months
[JBoss JIRA] Created: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
by Warren Gibson (JIRA)
Teiid not qualifying returned result data element when AS used in query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE (BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND (BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months
[JBoss JIRA] Created: (TEIID-1566) More complex join: ORDER BY and LIMIT not pushed down
by Mark Addleman (JIRA)
More complex join: ORDER BY and LIMIT not pushed down
------------------------------------------------------
Key: TEIID-1566
URL: https://issues.jboss.org/browse/TEIID-1566
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Mark Addleman
Assignee: Steven Hawkins
Query: SELECT B."SYSID", B."USERID", J0.APPNAME as "SYSOFUSER@APPNAME", B."NAME", B."PROC", B."SUSPEND", B."UID", (select count(*) from (select * from notes.RETRIEVE_NOTES where OBJECT_PKEY = xmlserialize(xmlelement("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B left join security.sysinfo J0 on J0.sysid=B.sysid ORDER BY J0.APPNAME ASC LIMIT 9990,10; args: []
I think there are two problems with the plan for this query: First, neither the ORDER BY nor the LIMIT clause are pushed down to DB2. However, if it is was pushed down, the plan should apply the ORDER & LIMIT before it tries to join to the notes table.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 8 months