Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
None
-
None
Description
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
Attachments
Issue Links
- is duplicated by
-
TRAFODION-1153 LP Bug: 1442730 - SQLCancel should avoid to use publication Qid in SQL Cancel operation
- Closed