[TRAFODION-1102] LP Bug: 1437522 - DCS went dead during ODBC SQLCancel testing

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: connectivity-dcs
• External issue URL: https://bugs.launchpad.net/bugs/1437522
• Assignee: Zbigniew Omanski
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:19
• Updated: 31/Aug/15 04:19
• Resolved: 31/Aug/15 04:04

Description

The SQLCancel test was done thru ODBCTEST. In this case, seems the 2nd SQLCancel on a SQL query caused DCS went dead, client couldn't connect to Trafodion servery any more.

Query used in the test:
select count from "MD".columns a, "MD".indexes b, "MD".objects c, "MD".tables d, "MD".columns e, "MD".indexes f, "MD".objects g, "MD".tables h, "MD".columns i, "MD".indexes j, "MD".objects k, "MD".tables l

Test steps:
1. set to Async mode: SQLSetStmtAttr:
In: StatementHandle = 0x000000000020B230, Attribute = SQL_ATTR_ASYNC_ENABLE=4, ValuePtr = SQL_ASYNC_ENABLE_ON=1, StringLength = SQL_NTS=-3,
fAttribute Type = SQL_C_SLONG=-16
Return: SQL_SUCCESS=0
2. SQLPrepare:
In: StatementHandle = 0x000000000020B230, StatementText = "select count from "MD".columns a, "MD".inde...", TextLength = 232
Return: SQL_STILL_EXECUTING=2
3.SQLCancel:
In: StatementHandle = 0x000000000020B230
Return: SQL_SUCCESS=0
4. SQLPrepare:
In: StatementHandle = 0x000000000020B230, StatementText = "select count from "MD".columns a, "MD".inde...", TextLength = 232
Return: SQL_SUCCESS=0

5. SQLExecute:
In: StatementHandle = 0x000000000020B230
Return: SQL_STILL_EXECUTING=2
6.SQLCancel:
In: StatementHandle = 0x000000000020B230
Return: SQL_SUCCESS=0
7. SQLExecute:
In: StatementHandle = 0x000000000020B230
Return: SQL_SUCCESS=0
8. SQLExecute:
In: StatementHandle = 0x000000000020B230
Return: SQL_STILL_EXECUTING=2
9. SQLCancel: ->kept running until driver timed out, and DCS went dead, no more connection can be made.