You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:19:45 UTC
[jira] [Created] (TRAFODION-1102) LP Bug: 1437522 - DCS went dead
during ODBC SQLCancel testing
Alice Chen created TRAFODION-1102:
-------------------------------------
Summary: LP Bug: 1437522 - DCS went dead during ODBC SQLCancel testing
Key: TRAFODION-1102
URL: https://issues.apache.org/jira/browse/TRAFODION-1102
Project: Apache Trafodion
Issue Type: Bug
Components: connectivity-dcs
Reporter: JiepingZhang
Assignee: Zbigniew Omanski
Priority: Critical
Fix For: 1.1 (pre-incubation)
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)