[TRAFODION-2828] Multi-threaded batch loading causes the program to crash

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: client-odbc-linux

Environment

$ hadoop version
Hadoop 2.7.1.2.4.2.0-258
Subversion [e-mail]:hortonworks/hadoop.git -r 13debf893a605e8a88df18a7d8d214f571e05289
Compiled by jenkins on 2016-04-25T05:46Z
Compiled with protoc 2.5.0
From source with checksum 2a2d95f05ec6c3ac547ed58cab713ac
This command was run using /usr/hdp/2.4.2.0-258/hadoop/hadoop-common-2.7.1.2.4.2.0-258.jar
$ sqvers
cat: /opt/hptc/pdsh/nodes: No such file or directory
TRAF_HOME=/home/trafodion/esgynDB_server-2.3.0
who@host=[e-mail]
JAVA_HOME=/usr/java/latest
product_version=EsgynDB Advanced 2.3.0
linux=3.10.0-327.el7.x86_64
redhat=7.2
libarkcmp_dll.so tdm_arkcmp Version 1.0.1 EsgynDB Release 2.3.0 (Build release [EsgynDB-2.3.0-0-g1735964_Bld70], branch a0fcbbe-no_branch, date 20171116_2112)
Tags No tags attached.

• Assignee: 苏锦佩
• Reporter: 苏锦佩
• Created: 05/Dec/17 08:07
• Updated: 23/Jan/19 06:38
• Resolved: 23/Jan/19 06:38

Description

we wrote a multithread ODBC program to test data loading performance. But during data loading, the program crashed. gdb info as below:

(gdb) bt
#0 0x00002aaaacf0d1f7 in raise () from /lib64/libc.so.6
#1 0x00002aaaacf0e8e8 in abort () from /lib64/libc.so.6
#2 0x00002aaaacf4cf47 in __libc_message () from /lib64/libc.so.6
#3 0x00002aaaacf54619 in _int_free () from /lib64/libc.so.6
#4 0x00002aaaaad1bf11 in double_to_char(double, int, char*, short) () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#5 0x00002aaaaad11a0e in ODBC::ConvertCToSQL(int, short, void*, int, short, short, short, void*, int, int, short, short, int, int, ICUConverter*, unsigned char*, short, int, int, int) ()
from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#6 0x00002aaaaacf5bd1 in CDesc::BuildValueList(CStmt*, short, CDesc*, int, short&, unsigned long&, SQLValueList_def_seq_, unsigned char&) () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#7 0x00002aaaaad0733e in CStmt::SendExecute(int) () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#8 0x00002aaaaad077e2 in CStmt::Execute() () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#9 0x00002aaaaad2d4e2 in ODBC::Execute(void*) () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#10 0x00002aaaaad2a246 in NeoExecute(void*) () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#11 0x00002aaaaad72a70 in SQLExecute () from /home/kangyong/lib/lib64/libtrafodbc_l64.so
#12 0x0000000000413986 in rowSetDatathread (args=0x6250e0) at performance.cpp:4362
#13 0x00002aaaab123e25 in start_thread () from /lib64/libpthread.so.0
#14 0x00002aaaacfd034d in clone () from /lib64/libc.so.6

Issue Links

• is related to: TRAFODION-2725 SQL types are REAL, FLOAT, and DOUBLE. Some values are inserted, a stack overflow occurs when SQLGetData is executed.