[
https://issues.apache.org/jira/browse/TRAFODION-1139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arvind Narain closed TRAFODION-1139.
------------------------------------
Resolution: Fixed
> 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: Arvind Narain
> 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.4.14#64029)
