[TRAFODION-1728] [MTDCS] ODBC: SQLExecute ran into communication link failure when mtdcs is on

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0-incubating
• Component/s: connectivity-dcs
• Environment: platform: suse11 ; connect info : 10.10.10.176:23400 ; build : 20151223_0900-bin ; driver version: 1223
• Assignee: Weiqing Xu
• Reporter: Gao, Rui-Xian
• Created: 29/Dec/15 15:12
• Updated: 26/Jan/18 08:26

Description

With MTDCS on, sqlexecute will run into communication link failure.

reproduce steps –
1. create the table with sqlexecdirect –
create table XE2MNWFUZ1 (IERZCDTBNK char(10),H_ELKF5RLQ varchar(10),JDIV8HVNP3 decimal(10,5),SRCYICXAZ0 numeric(10,5),DOG4S9TXE2 smallint,MNWFUZ1BMP integer,TUH_ELKF5R real,LQQY7KOGAJ float,BWJDIV8HVN double precision,VPMHA9UJ0Y date,G6SPJCWBEV time,G3TQAXXDQU timestamp,IWOY8F4SFL bigint,M1KROLHZN7 NUMERIC(19,0),KOGAJBWJDI NUMERIC(19,6),V8HVNP3SRC NUMERIC(128,0),YICXAZ06DO NUMERIC(128,128),G4S9TXE2MN NUMERIC(10,5) UNSIGNED,WFUZ1BMPTU NUMERIC(18,5) UNSIGNED,QY7KOGAJBW NUMERIC(30,10) UNSIGNED) NO PARTITION;

2. prepare the sql statement –
insert into XE2MNWFUZ1 values ('uh_["^El}k','F5R:\Lq$*Q',1234.56789,1234.56789,1200,12000,123.45E2,123.45E3,123.45E4,

{d '1993-07-01'}

,

{t '09:45:30'}

,

{ts '1993-08-02 08:44:31.001'}

,120000,1234567890.56789,1234567890.456789,1234567890.456789,0.01234567890123456789,1234.56789,1234567890.56789,12345678901234567890.0123456789);

3. sqlexecute – error will show up

***ERROR: SQLExecute: Expected: SQL_SUCCESS Actual: SQL_ERROR
File: ../../../../src/coast/coast_unified/src/execute.c Line: 375
State: 08S01
Native Error: 98
Error: [Trafodion ODBC Driver] COMMUNICATION LINK FAILURE. THE SERVER TIMED OUT OR DISAPPEARED. Platform: UNIX, Transport: TCPIP, Api: SQLEXECUTE2, Error type: DRIVER, Process: TCP:10.10.10.176/23401:ODBC, Operation: DO_WRITE_READ, function: RECV, error: 104, error_detail: 0, error text:recv() returned zero bytes.