[
https://issues.apache.org/jira/browse/TRAFODION-1728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gao, Rui-Xian updated TRAFODION-1728:
-------------------------------------
Environment:
platform: suse11
connect info : 10.10.10.176:23400
build : 20151223_0900-bin
driver version: 1223
was:
platform: suse11
connect info : 10.10.10.176:23400
esgynDB version :esgynDB-20151223_0900-bin
driver version: 1223
> [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
> build : 20151223_0900-bin
> driver version: 1223
> Reporter: Gao, Rui-Xian
> Assignee: Weiqing Xu
> Priority: Major
>
> 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
(v7.6.3#76005)
