You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Jian Jin (JIRA)" <ji...@apache.org> on 2015/12/31 03:49:49 UTC
[jira] [Updated] (TRAFODION-1728) [MTDCS] ODBC: SQLExecute ran into
communication link failure when mtdcs is on
[ https://issues.apache.org/jira/browse/TRAFODION-1728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jian Jin updated TRAFODION-1728:
--------------------------------
Assignee: Kevin Xu
> [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
> Assignee: Kevin Xu
>
> 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)