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

["Gao, Rui-Xian (JIRA)" <ji...@apache.org>]

Gao, Rui-Xian created TRAFODION-1728:
----------------------------------------

             Summary: [MTDCS] ODBC: SQLExecute ran into communication link failure when mtdcs is on
                 Key: TRAFODION-1728
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1728
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-dcs
    Affects Versions: 2.0-incubating
         Environment: platform: suse11 
connect info : 10.10.10.176:23400 
esgynDB version :esgynDB-20151223_0900-bin 
driver version: 1223
            Reporter: Gao, Rui-Xian


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.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)