[jira] [Created] (TRAFODION-1139) LP Bug: 1441311 - JDBC query cancel api sometimes tries to cancel repository query and fails

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1139:
-------------------------------------

             Summary: 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.0-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)