You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/05/20 01:20:17 UTC
[jira] [Updated] (TRAFODION-1139) LP Bug: 1441311 - JDBC query
cancel api sometimes tries to cancel repository query and fails
[ https://issues.apache.org/jira/browse/TRAFODION-1139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller updated TRAFODION-1139:
-----------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> LP Bug: 1441311 - JDBC query cancel api sometimes tries to cancel repository query and fails
> --------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1139
> URL: https://issues.apache.org/jira/browse/TRAFODION-1139
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Aruna Sadashiva
> Assignee: Selvaganesan Govindarajan
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> JDBC (and ODBC too) Cancel query api sometimes tries to cancel a repository query instead of the user query.
> org.trafodion.jdbc.t4.HPT4Exception: The message id: ids_program_error With parameters: *** ERROR[8031] Server declined cancel request for query ID MXID11003020671212295160273495476000000000306U3333300_29_STMT_PUBLICATION. The query is not in OPEN or FETCH or EXECUTE state.
> SQLState HY018
> Error Code -8031
> at org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:304)
> at org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:238)
> at org.trafodion.jdbc.t4.odbc_Dcs_StopSrvr_exc_.extractFromByteArray(odbc_Dcs_StopSrvr_exc_.java:74)
> at org.trafodion.jdbc.t4.CancelReply.<init>(CancelReply.java:33)
> at org.trafodion.jdbc.t4.T4_Dcs_Cancel.cancel(T4_Dcs_Cancel.java:89)
> at org.trafodion.jdbc.t4.InterfaceConnection.cancel(InterfaceConnection.java:478)
> at org.trafodion.jdbc.t4.InterfaceStatement.cancel(InterfaceStatement.java:1044)
> at org.trafodion.jdbc.t4.TrafT4Statement.cancel(TrafT4Statement.java:104)
> at qc1$cancelThread.run(qc1.java:139)
> SQLMessage The message id: ids_program_error With parameters: *** ERROR[8031] Server declined cancel request for query ID MXID11003020671212295160273495476000000000306U3333300_29_STMT_PUBLICATION. The query is not in OPEN or FETCH or EXECUTE state.
> SQLState HY018
> Error Code -8031
> SQLState HY000
> Error Code -1
> Got SQLException in queryThread.....
> org.trafodion.jdbc.t4.HPT4Exception: The message id: invalid_cursor_state
> at org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:304)
> at org.trafodion.jdbc.t4.TrafT4ResultSet.getType(TrafT4ResultSet.java:2369)
> at org.trafodion.jdbc.t4.TrafT4ResultSet.setFetchOutputs(TrafT4ResultSet.java:4597)
> at org.trafodion.jdbc.t4.InterfaceResultSet.setExecute2FetchOutputs(InterfaceResultSet.java:729)
> at org.trafodion.jdbc.t4.InterfaceResultSet.fetch(InterfaceResultSet.java:796)
> at org.trafodion.jdbc.t4.TrafT4ResultSet.next(TrafT4ResultSet.java:2870)
> at qc1$queryThread.run(qc1.java:76)
> SQLMessage The message id: invalid_cursor_state
> SQLState HY000
> Error Code -1
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)