[JBoss JIRA] (TEIID-2907) Uncaught exception during rollback
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2907:
-------------------------------------
Summary: Uncaught exception during rollback
Key: TEIID-2907
URL: https://issues.jboss.org/browse/TEIID-2907
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.7
TransactionManager.rollback can throw an illegalstateexception, which if uncaught can mask other issues.
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
by Hisanobu Okuda (JIRA)
[ https://issues.jboss.org/browse/TEIID-2906?page=com.atlassian.jira.plugin... ]
Hisanobu Okuda commented on TEIID-2906:
---------------------------------------
The customers are upset and displaying anger to us. We in Japan need to keep it as a bug to calm down them. Also they believe that the issue will be fixed sooner if it is filed as a bug than an enhancement. I'm asking you not in the point of view of technical aspect, but business matter. At least, for the customer, the current behavior is unexpected.
I will attach the customer comment (originally in Japanese, translated in English)
------------------------------------------------------------------------------------------
1 . For specific details of the business impact will get back to you .
As long as it is not subjected to this modification , we will not be able to release the system.
Detailed number, such as the construction period and corresponding content in the application is unknown at this time .
I am sorry.
However , you have to tell that there is a risk of cutover postponed ,
For projects that are built into the medium-term plan of the customer , there is no option of release postponed.
( Cutover is September 2014 )
That is, for us , it is an issue that must be resolved within six months at the latest, no matter what .
If you can not resolve the issue, you RH and we need to describe the situation to the customer, even those that return forced to contract money ,
It is neither exaggerated nor a joke .
Thank you for your understanding .
2 . Support will be available for you are expecting
We will request a resolution of up to 2014 the end of June .
To enter into a process that is for release since August 2014 ,
By the end of July , you need to solve this problem , and to implement the no-effect confirmation .
Therefore there is the need to have you presented by RH 's a solution in June .
------------------------------------------------------------------------------------------
Now the customers are objecting to the values only, however, I think potentially SQL would be also what they will be objecting.
> bind variables and sql appear when exception thrown
> ---------------------------------------------------
>
> Key: TEIID-2906
> URL: https://issues.jboss.org/browse/TEIID-2906
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Attachments: PreparedStatementTest.java, test.vdb
>
>
> When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
> teiid-command.log:-
> {code}
> 19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
> 'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
> E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
> not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
> Enable more detailed logging to see the entire stacktrace.
> {code}
> printStackTrace() at client side:-
> {code}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
> ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
> `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> {code}
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
by Hisanobu Okuda (JIRA)
[ https://issues.jboss.org/browse/TEIID-2906?page=com.atlassian.jira.plugin... ]
Hisanobu Okuda updated TEIID-2906:
----------------------------------
Attachment: test.vdb
> bind variables and sql appear when exception thrown
> ---------------------------------------------------
>
> Key: TEIID-2906
> URL: https://issues.jboss.org/browse/TEIID-2906
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Attachments: PreparedStatementTest.java, test.vdb
>
>
> When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
> teiid-command.log:-
> {code}
> 19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
> 'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
> E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
> not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
> Enable more detailed logging to see the entire stacktrace.
> {code}
> printStackTrace() at client side:-
> {code}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
> ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
> `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> {code}
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
by Hisanobu Okuda (JIRA)
[ https://issues.jboss.org/browse/TEIID-2906?page=com.atlassian.jira.plugin... ]
Hisanobu Okuda updated TEIID-2906:
----------------------------------
Attachment: PreparedStatementTest.java
> bind variables and sql appear when exception thrown
> ---------------------------------------------------
>
> Key: TEIID-2906
> URL: https://issues.jboss.org/browse/TEIID-2906
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Attachments: PreparedStatementTest.java, test.vdb
>
>
> When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
> teiid-command.log:-
> {code}
> 19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
> 'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
> E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
> not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
> Enable more detailed logging to see the entire stacktrace.
> {code}
> printStackTrace() at client side:-
> {code}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
> ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
> `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> {code}
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2906?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2906:
---------------------------------------
This behavior comes directly from other user requests. Can you modify this issue as an enhancement as to what you don't want in the log or the client to see and why?
> bind variables and sql appear when exception thrown
> ---------------------------------------------------
>
> Key: TEIID-2906
> URL: https://issues.jboss.org/browse/TEIID-2906
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
>
> When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
> teiid-command.log:-
> {code}
> 19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
> 'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
> E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
> not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
> Enable more detailed logging to see the entire stacktrace.
> {code}
> printStackTrace() at client side:-
> {code}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
> ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
> `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> {code}
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
by Hisanobu Okuda (JIRA)
Hisanobu Okuda created TEIID-2906:
-------------------------------------
Summary: bind variables and sql appear when exception thrown
Key: TEIID-2906
URL: https://issues.jboss.org/browse/TEIID-2906
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.4
Environment: - JDV 6.0.0
Reporter: Hisanobu Okuda
Assignee: Steven Hawkins
When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
teiid-command.log:-
{code}
19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
Enable more detailed logging to see the entire stacktrace.
{code}
printStackTrace() at client side:-
{code}
org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
`LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
{code}
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2904) Expose "import" and "extension-metadata" Translator Properties through Admin API
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2904?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2904:
-------------------------------------
Added new Admin API method
{code}
/**
* Get all of the available configuration Properties for the specified translator
* @param translatorName - Name of the translator
* @param type - Type of property definition (import, override, extension-metadata)
* @return
* @throws AdminException
*/
Collection<? extends PropertyDefinition> getTranslatorPropertyDefinitions(String translatorName, TranlatorPropertyType type) throws AdminException;
{code}
* Added a interface called "MetadataProcessor" to "teiid-api" to serve as marker interface for any metadata import process for a translator.
* Extended the @TranslatorProperty annotation to include a property type attribute, to define a "import" property of a translator.
* Any method, that has @TranslatorProperty with "import" type on "ExecutionFactory" or "MetadataProcessror" class of translator will be reported as the "importer" property
* Introduced @ExtensionMetadataProperty annotation for declared fields on class to annotate them as the defined extension properties.
* Any field on "ExecutionFactory" or "MetadataProcessror" class of translator, with @ExtensionMetadataProperty will be reported as the extension metadata property.
* Revised all the translators to report their extension and import properties using the above method.
> Expose "import" and "extension-metadata" Translator Properties through Admin API
> --------------------------------------------------------------------------------
>
> Key: TEIID-2904
> URL: https://issues.jboss.org/browse/TEIID-2904
> Project: Teiid
> Issue Type: Enhancement
> Components: AdminApi
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 8.7
>
>
> Currently only "override" translator properties are exposed through Admin API. Teiid should also expose
> * import properties
> * extension metadata proeprties
> for tooling purposes. Right now Teiid Connection importer in Designer, a user has to manually enter these values.
--
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
10 years, 1 month
[JBoss JIRA] (TEIID-2840) More control over TTL Snapshot Refresh
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2840?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2840.
-----------------------------------
Resolution: Done
Rather than introduce additional hint or table metadata, modified the notion of ttl to be invalidating by default - which seems to match better with user expectations.
To keep the old behavior of lazy invalidation, a vdb property lazy-invalidation=true can be set.
Added a release note to cover this change.
> More control over TTL Snapshot Refresh
> ---------------------------------------
>
> Key: TEIID-2840
> URL: https://issues.jboss.org/browse/TEIID-2840
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 7.7.8
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 8.7
>
>
> The ttl load to may need to be changed to a blocking load or some configuration options provided to prevent stale reads after a certain time limit.
--
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
10 years, 1 month