February 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1455) CTC Query Testing - query exception error message not consistant - changes from one run to the next (only happens on RHEL6)

by Warren Gibson (JIRA)

CTC Query Testing - query exception error message not consistant - changes from one run to the next (only happens on RHEL6) --------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1455 URL: https://issues.jboss.org/browse/TEIID-1455 Project: Teiid Issue Type: Bug Components: Integration Tests Reporter: Warren Gibson Assignee: Steven Hawkins Priority: Minor This problem is not consistent in that it can happen on any source, the number of queries vary, and it eventually goes away with enough executions. I am not sure what is triggering the problem. As an example I ran the full query suite against Ora11, Ora10, SqlSer2008 in a single test execution and each of them received 41 failures because the exception error message changed. I then immediately reran the test and this time Ora11, Ora10 and SqlSer2008 all passed but MySql51 had 32 of the same type of failure. I reran the same test a 3rd time and this time everything passed. This has only happened on RHEL6. Below is an example of one of the failing queries in the latest MySql run. This example has the actual exception from the run and the expected exception. I have also included the exception from the server log and it matches the expected exception. <?xml version="1.0" encoding="UTF-8"?> <root> <queryResults name="RDBMS_Test_Queries_9000_TestQuery255" value="SELECT BQT1.MediumA.ByteNum, BQT2.MediumB.ObjectValue FROM BQT1.MediumA, BQT2.MediumB WHERE BQT1.MediumA.ByteNum = convert(BQT2.MediumB.ObjectValue, byte) AND (BQT1.MediumA.IntKey >= 0 AND BQT1.MediumA.IntKey < 256) AND (BQT2.MediumB.IntKey >= 0 AND BQT2.MediumB.IntKey < 256) ORDER BY BQT1.MediumA.ByteNum"> THIS IS THE ACTUAL EXCEPTION: <actual_exception> <exceptionType>TeiidSQLException</exceptionType> <message>Error trying to execute a statement SELECT BQT1.MediumA.ByteNum, BQT2.MediumB.ObjectValue FROM BQT1.MediumA, BQT2.MediumB WHERE BQT1.MediumA.ByteNum = convert(BQT2.MediumB.ObjectValue, byte) AND (BQT1.MediumA.IntKey >= 0 AND BQT1.MediumA.IntKey < 256) AND (BQT2.MediumB.IntKey >= 0 AND BQT2.MediumB.IntKey < 256) ORDER BY BQT1.MediumA.ByteNum.</message> <class>org.teiid.jdbc.TeiidSQLException</class> </actual_exception> THIS IS THE EXPECTED EXCEPTION <expected_exception> <exceptionType>TeiidSQLException</exceptionType> <message>Error Code:ERR.015.001.0003 Message:Unable to evaluate convert(convert(Source.MEDIUMB.OBJECTVALUE, object), byte): Error Code:ERR.015.001.0003 Message: Error while evaluating function convert</message> <class>org.teiid.jdbc.TeiidSQLException</class> </expected_exception> </queryResults> </root> THIS IS THE EXCEPTION AS STATED IN THE SERVER LOG WHICH MATCHES THE EXPECTED EXCEPTION 2011-01-28 11:17:52,779 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue157992) Processing exception 'Error Code:ERR.015.001.0003 Message:Unable to evaluate convert(convert(Source.MediumB.ObjectValue, object), byte): Error Code:ERR.015.001.0003 Message:Error while evaluating function convert' for request tnuf/C2ODO8c.2685. Exception type org.teiid.api.exception.query.ExpressionEvaluationException thrown from org.teiid.core.types.basic.StringToByteTransform.transformDirect(StringToByteTransform.java:43). Enable more detailed logging to see the entire stacktrace. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 8 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-889) 2 CommonTransactionTests Hang, commented out for now

by Van Halbert (JIRA)

2 CommonTransactionTests Hang, commented out for now ---------------------------------------------------- Key: TEIID-889 URL: https://jira.jboss.org/jira/browse/TEIID-889 Project: Teiid Issue Type: Bug Components: Integration Tests Affects Versions: 7.0 Reporter: Van Halbert Assignee: Steven Hawkins 2 CommonTransactionTests hang and do not complete. Not sure why at the moment, but commenting them out for now and documenting to know to go back and investigate. - xtestMultipleSourcePartialProcessingUsingLimit - xtestMultipleSourcePartialProcessingUsingMakedep -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 8 months

4
13
0 / 0

[JBoss JIRA] Created: (TEIID-513) Make the commandcontext available to the evaluatablevisitor

by Steven Hawkins (JIRA)

Make the commandcontext available to the evaluatablevisitor ----------------------------------------------------------- Key: TEIID-513 URL: https://jira.jboss.org/jira/browse/TEIID-513 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x If the commandcontext is available to the evaluatablevisitor, then we can make a better decision about what determinism level to accept for planning function evaluation. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-776) Enhancem multisource planning with aggregate pushdown

by Steven Hawkins (JIRA)

Enhancem multisource planning with aggregate pushdown ----------------------------------------------------- Key: TEIID-776 URL: https://jira.jboss.org/jira/browse/TEIID-776 Project: Teiid Issue Type: Feature Request Affects Versions: 6.2.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x Multisource modification happens after all rules have been fired, which means that aggregate and other sort/distinct pushdown optimizations do not happen. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 8 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-417) Add REST Support to Data Services

by Ted Jones (JIRA)

Add REST Support to Data Services --------------------------------- Key: TEIID-417 URL: https://jira.jboss.org/jira/browse/TEIID-417 Project: Teiid Issue Type: Feature Request Components: SOAP Services Reporter: Ted Jones Assignee: Ted Jones Need to add support for REST to data services. REST needs be enabled in Axis2 and a REST endpoint should be added to the data services WSDL. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 8 months

4
13
0 / 0

[JBoss JIRA] Created: (TEIID-1164) Getting the Procedure Parameter metadata is not supported in ODBC

by Ramesh Reddy (JIRA)

Getting the Procedure Parameter metadata is not supported in ODBC ----------------------------------------------------------------- Key: TEIID-1164 URL: https://jira.jboss.org/browse/TEIID-1164 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1 Reporter: Ramesh Reddy Currently postgreSQL uses the JDBC array types in issuing the query to read the Procedure parameters. However, Teiid does not support the Array types yet in the JDBC layer, thus this is currently not implemented. This needs to be fixed to correctly return the metadata about the procedures. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

2
7
0 / 0

[JBoss JIRA] Created: (TEIID-1474) Add query hint to limit parallel execution of union members

by Howard Abrams (JIRA)

Add query hint to limit parallel execution of union members ----------------------------------------------------------- Key: TEIID-1474 URL: https://issues.jboss.org/browse/TEIID-1474 Project: Teiid Issue Type: Feature Request Reporter: Howard Abrams Assignee: Steven Hawkins We would like a new query hint to limit the number of parallel executions of union members. This is useful in two situations: 1. When the queries are expensive, but the overall union contains a limit that is most likely to be fulfilled by the first member of the union 2. When the queries are backed by a common resource which may be overloaded by multiple queries The addition of a hint would make this manageable by the client; perhaps something like "/*+ parallel=2*/"? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

2
7
0 / 0

[JBoss JIRA] Created: (TEIID-1445) ConcurrentModificationException during the startup of the Server

by Ramesh Reddy (JIRA)

ConcurrentModificationException during the startup of the Server ---------------------------------------------------------------- Key: TEIID-1445 URL: https://issues.jboss.org/browse/TEIID-1445 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.2 Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Minor Fix For: 7.3 Seems like this is some timing issue. java.util.ConcurrentModificationException at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372) at java.util.AbstractList$Itr.next(AbstractList.java:343) at org.teiid.adminapi.impl.ModelMetaData.getValidationErrors(ModelMetaData.java:222) at org.teiid.adminapi.impl.ModelMetaData.getErrors(ModelMetaData.java:210) at org.teiid.adminapi.impl.VDBMetaData.getValidityErrors(VDBMetaData.java:249) at org.teiid.adminapi.impl.VDBMetaData.isValid(VDBMetaData.java:264) at org.teiid.deployers.VDBDeployer.loadMetadata(VDBDeployer.java:355) at org.teiid.deployers.VDBDeployer.access$2(VDBDeployer.java:315) at org.teiid.deployers.VDBDeployer$1.run(VDBDeployer.java:308) 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:619) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

4
14
0 / 0

[JBoss JIRA] Created: (TEIID-1327) API request: Fine grained security

by Mark Addleman (JIRA)

API request: Fine grained security ----------------------------------- Key: TEIID-1327 URL: https://jira.jboss.org/browse/TEIID-1327 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins I'd like an API to implement fine grained security checks. The use case is to create a permission from each table+column requested, each stored procedure and other database objects and validate the user id and permission against an external security manager. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

3
23
0 / 0

[JBoss JIRA] Created: (TEIID-1367) Add VDB Level Clear Cache Operation in Jopr/JON

by Ted Jones (JIRA)

Add VDB Level Clear Cache Operation in Jopr/JON ----------------------------------------------- Key: TEIID-1367 URL: https://jira.jboss.org/browse/TEIID-1367 Project: Teiid Issue Type: Feature Request Components: Jopr Plugin Affects Versions: 7.1 Reporter: Ted Jones Assignee: Ted Jones Priority: Critical Fix For: 7.1.1 Need to add an operation to clear the Prepared Plan and/or Result Set caches. This should be a VDB level operation. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

2
2
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2011