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

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.0-incubating
• Component/s: connectivity-dcs
• Environment: platform: suse11; connect info : 10.10.10.176:23400; esgynDB version :esgynDB-20151121_0900-bin; driver version: 1119
• Assignee: Kevin Xu
• Reporter: Gao, Rui-Xian
• Created: 01/Dec/15 13:32
• Updated: 02/Dec/15 05:37

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.