Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-1660

[MTDCS] ODBC: with MultiThread DCS on, API GetCatalogs will cause dcsserver down

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 2.0-incubating
    • None
    • connectivity-dcs
    • None
    • platform: suse11
      connect info : 10.10.10.176:23400
      esgynDB version :esgynDB-20151121_0900-bin
      driver version: 1119

    Description

      ODBC test GetTypeInfo will cause dcsserver down when MTDCS is on, the root cause is API GETCATALOGS.

      Here is the test code that can reproduce the problem(no matter what the data type is, it always fails at the second time) –

      j = 0;
      while (j < 2)
      {
      _stprintf(Heading,_T("Test Positive functionality of SQLGetTypeInfo for data type: %s\n"),SQLTypeToChar(TypeInfo[j].DATA_TYPE,TempBuf));
      TESTCASE_BEGINW(Heading);

      returncode = SQLGetTypeInfo(hstmt,TypeInfo[j].DATA_TYPE);
      LogMsg(NONE,_T("SQLGetTypeInfo(hstmt,j=%d\n"),j);
      if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetTypeInfo"))

      { LogMsg(SHORTTIMESTAMP,_T("SQLGetTypeInfo Failed !\n")); TEST_FAILED; LogAllErrors(henv,hdbc,hstmt); }

      TESTCASE_END;
      j++;
      }

      Error info in test log (Api: GETCATALOGS) –

      13:14:31 Test Positive functionality of SQLGetTypeInfo for data type: SQL_WCHAR
      SQLGetTypeInfo(hstmt,j=1
      13:14:31 ***ERROR: SQLGetTypeInfo: Expected: SQL_SUCCESS Actual: SQL_ERROR
      File: ../../../../src/coast/coast_unified/src/gettypei.c Line: 166
      13:14:31 SQLGetTypeInfo Failed !
      State: 08S01
      Native Error: 98
      Error: [Trafodion ODBC Driver] COMMUNICATION LINK FAILURE. THE SERVER TIMED OUT OR DISAPPEARED. Platform: UNIX, Transport: TCPIP, Api: GETCATALOGS, Error type: DRIVER, Process: TCP:suse-9.novalocal/23405:ODBC, Operation: DO_WRITE_READ, function: RECV, error: 104, error_detail: 0, error text:recv() returned zero bytes.

      Attachments

        1. hs_err_pid58858.log
          154 kB
          Gao, Rui-Xian
        2. gettypei.c
          8 kB
          Gao, Rui-Xian

        Activity

          People

            kevinxu021 Kevin Xu
            rachelgao Gao, Rui-Xian
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: