Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1102

LP Bug: 1437522 - DCS went dead during ODBC SQLCancel testing

    XMLWordPrintableJSON

    Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              omanski Zbigniew Omanski
              Reporter:
              zhangjie JiepingZhang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: