You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "苏锦佩 (JIRA)" <ji...@apache.org> on 2017/07/06 07:46:00 UTC
[jira] [Created] (TRAFODION-2679) odb crash when extracting data to
xml file
苏锦佩 created TRAFODION-2679:
------------------------------
Summary: odb crash when extracting data to xml file
Key: TRAFODION-2679
URL: https://issues.apache.org/jira/browse/TRAFODION-2679
Project: Apache Trafodion
Issue Type: Bug
Components: db-utility-odb
Affects Versions: 2.2-incubating
Reporter: 苏锦佩
Fix For: 2.3-incubating
[sujinpei@sujinpeipc bin]$ odb64luo -u trafodion -p traf123 -d gyvm-4 -e src=trafodion.odb_test_extract.person_e:tgt=output_data/ext_xml_%t.csv:rows=m10:fs=,:trim:sq=\":xml
Connected to Trafodion
odb [2017-07-05 13:58:39]: starting ODBC connection(s)... 0
[0] 1,000 records extracted
[0] odb version 1.1.0 Extract statistics:
[0] Source: TRAFODION.ODB_TEST_EXTRACT.PERSON_E
[0] Target: output_data/ext_xml_%t.csv
[0] Record buffer size: 353 bytes
[0] Rowset size: 29,704
[0] Rowset buffer size: 10,239.76 KiB
[0] Pre-extract time: 0.528 s (00:00:00.528)
[0] Extract time: 0.107 s (00:00:00.107)
[0] Total records extracted: 1,000 (9.346 krec/s)
[0] Total data bytes written: 350,059 (3,194.902 KiB/s)
*** glibc detected *** odb64luo: free(): corrupted unsorted chunks: 0x0000000000b8c100 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x75dee)[0x7fc4b7a7edee]
/lib64/libc.so.6(+0x78c80)[0x7fc4b7a81c80]
odb64luo[0x422352]
odb64luo[0x434e0a]
/lib64/libc.so.6(__libc_start_main+0xfd)[0x7fc4b7a27d1d]
odb64luo[0x403389]
======= Memory map: ========
00400000-0044a000 r-xp 00000000 fd:01 2375217 /home/sujinpei/esgyn/incubator-trafodion/core/conn/odb/bin/odb64luo
00649000-0064a000 rw-p 00049000 fd:01 2375217 /home/sujinpei/esgyn/incubator-trafodion/core/conn/odb/bin/odb64luo
0064a000-0064c000 rw-p 00000000 00:00 0
00b2f000-00bad000 rw-p 00000000 00:00 0 [heap]
7fc4ac000000-7fc4ac021000 rw-p 00000000 00:00 0
7fc4ac021000-7fc4b0000000 ---p 00000000 00:00 0
7fc4b1e61000-7fc4b1e62000 ---p 00000000 00:00 0
7fc4b1e62000-7fc4b2862000 rw-p 00000000 00:00 0
7fc4b2862000-7fc4b287f000 r-xp 00000000 fd:01 655778 /lib64/libselinux.so.1
7fc4b287f000-7fc4b2a7e000 ---p 0001d000 fd:01 655778 /lib64/libselinux.so.1
7fc4b2a7e000-7fc4b2a7f000 r--p 0001c000 fd:01 655778 /lib64/libselinux.so.1
7fc4b2a7f000-7fc4b2a80000 rw-p 0001d000 fd:01 655778 /lib64/libselinux.so.1
7fc4b2a80000-7fc4b2a81000 rw-p 00000000 00:00 0
7fc4b2a81000-7fc4b2a83000 r-xp 00000000 fd:01 655540 /lib64/libkeyutils.so.1.3
7fc4b2a83000-7fc4b2c82000 ---p 00002000 fd:01 655540 /lib64/libkeyutils.so.1.3
7fc4b2c82000-7fc4b2c83000 r--p 00001000 fd:01 655540 /lib64/libkeyutils.so.1.3
7fc4b2c83000-7fc4b2c84000 rw-p 00002000 fd:01 655540 /lib64/libkeyutils.so.1.3
7fc4b2c84000-7fc4b2c8e000 r-xp 00000000 fd:01 655549 /lib64/libkrb5support.so.0.1
7fc4b2c8e000-7fc4b2e8d000 ---p 0000a000 fd:01 655549 /lib64/libkrb5support.so.0.1
7fc4b2e8d000-7fc4b2e8e000 r--p 00009000 fd:01 655549 /lib64/libkrb5support.so.0.1
7fc4b2e8e000-7fc4b2e8f000 rw-p 0000a000 fd:01 655549 /lib64/libkrb5support.so.0.1
7fc4b2e8f000-7fc4b2ec8000 r-xp 00000000 fd:01 655538 /lib64/libnspr4.so
7fc4b2ec8000-7fc4b30c8000 ---p 00039000 fd:01 655538 /lib64/libnspr4.so
7fc4b30c8000-7fc4b30c9000 r--p 00039000 fd:01 655538 /lib64/libnspr4.so
7fc4b30c9000-7fc4b30cb000 rw-p 0003a000 fd:01 655538 /lib64/libnspr4.so
7fc4b30cb000-7fc4b30cd000 rw-p 00000000 00:00 0
7fc4b30cd000-7fc4b30d1000 r-xp 00000000 fd:01 655802 /lib64/libplc4.so
7fc4b30d1000-7fc4b32d0000 ---p 00004000 fd:01 655802 /lib64/libplc4.so
7fc4b32d0000-7fc4b32d1000 r--p 00003000 fd:01 655802 /lib64/libplc4.so
7fc4b32d1000-7fc4b32d2000 rw-p 00004000 fd:01 655802 /lib64/libplc4.so
7fc4b32d2000-7fc4b32d5000 r-xp 00000000 fd:01 655803 /lib64/libplds4.so
7fc4b32d5000-7fc4b34d4000 ---p 00003000 fd:01 655803 /lib64/libplds4.so
7fc4b34d4000-7fc4b34d5000 r--p 00002000 fd:01 655803 /lib64/libplds4.so
7fc4b34d5000-7fc4b34d6000 rw-p 00003000 fd:01 655803 /lib64/libplds4.so
7fc4b34d6000-7fc4b34fc000 r-xp 00000000 fd:01 2104262 /usr/lib64/libnssutil3.so
7fc4b34fc000-7fc4b36fb000 ---p 00026000 fd:01 2104262 /usr/lib64/libnssutil3.so
7fc4b36fb000-7fc4b3702000 r--p 00025000 fd:01 2104262 /usr/lib64/libnssutil3.so
7fc4b3702000-7fc4b3703000 rw-p 0002c000 fd:01 2104262 /usr/lib64/libnssutil3.so
7fc4b3703000-7fc4b383d000 r-xp 00000000 fd:01 2104697 /usr/lib64/libnss3.so
7fc4b383d000-7fc4b3a3c000 ---p 0013a000 fd:01 2104697 /usr/lib64/libnss3.so
7fc4b3a3c000-7fc4b3a42000 r--p 00139000 fd:01 2104697 /usr/lib64/libnss3.so
7fc4b3a42000-7fc4b3a44000 rw-p 0013f000 fd:01 2104697 /usr/lib64/libnss3.so
7fc4b3a44000-7fc4b3a46000 rw-p 00000000 00:00 0
7fc4b3a46000-7fc4b3a6e000 r-xp 00000000 fd:01 2104699 /usr/lib64/libsmime3.so
7fc4b3a6e000-7fc4b3c6d000 ---p 00028000 fd:01 2104699 /usr/lib64/libsmime3.so
7fc4b3c6d000-7fc4b3c71000 r--p 00027000 fd:01 2104699 /usr/lib64/libsmime3.so
7fc4b3c71000-7fc4b3c72000 rw-p 0002b000 fd:01 2104699 /usr/lib64/libsmime3.so
7fc4b3c72000-7fc4b3cb9000 r-xp 00000000 fd:01 2104700 /usr/lib64/libssl3.so
7fc4b3cb9000-7fc4b3eb9000 ---p 00047000 fd:01 2104700 /usr/lib64/libssl3.so
7fc4b3eb9000-7fc4b3ebd000 r--p 00047000 fd:01 2104700 /usr/lib64/libssl3.so
7fc4b3ebd000-7fc4b3ebe000 rw-p 0004b000 fd:01 2104700 /usr/lib64/libssl3.so
7fc4b3ebe000-7fc4b3ebf000 rw-p 00000000 00:00 0
7fc4b3ebf000-7fc4b3ed5000 r-xp 00000000 fd:01 655401 /lib64/libresolv-2.12.so
7fc4b3ed5000-7fc4b40d5000 ---p 00016000 fd:01 655401 /lib64/libresolv-2.12.so
7fc4b40d5000-7fc4b40d6000 r--p 00016000 fd:01 655401 /lib64/libresolv-2.12.so
7fc4b40d6000-7fc4b40d7000 rw-p 00017000 fd:01 655401 /lib64/libresolv-2.12.so
7fc4b40d7000-7fc4b40d9000 rw-p 00000000 00:00 0
7fc4b40d9000-7fc4b4293000 r-xp 00000000 fd:01 2099318 /usr/lib64/libcrypto.so.1.0.1e
7fc4b4293000-7fc4b4493000 ---p 001ba000 fd:01 2099318 /usr/lib64/libcrypto.so.1.0.1e
7fc4b4493000-7fc4b44ae000 r--p 001ba000 fd:01 2099318 /usr/lib64/libcrypto.so.1.0.1e
7fc4b44ae000-7fc4b44ba000 rw-p 001d5000 fd:01 2099318 /usr/lib64/libcrypto.so.1.0.1e
7fc4b44ba000-7fc4b44be000 rw-p 00000000 00:00 0 Aborted (core dumped)
*Step to reproduce:*
1.create table
CREATE TABLE TRAFODION.ODB_TEST_EXTRACT.PERSON_E
(
PID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
NOT SERIALIZED
, FNAME CHAR(20) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, LNAME CHAR(20) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, COUNTRY VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, CITY VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, BDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, SEX CHAR(1) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, EMAIL VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, SALARY NUMERIC(9, 2) NO DEFAULT NOT NULL NOT
DROPPABLE NOT SERIALIZED
, EMPL VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, NOTES VARCHAR(80) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT NULL NOT SERIALIZED
, LOADTS TIMESTAMP(0) DEFAULT NULL NOT SERIALIZED
, PRIMARY KEY (PID ASC)
)
ATTRIBUTES ALIGNED FORMAT
;
2. insert 1000 rows data.
3.mkidr output_data
4. run command:
odb64luo -u trafodion -p traf123 -d gyvm-4 -e src=trafodion.odb_test_extract.person_e:tgt=output_data/ext_xml_%t.csv:rows=m10:fs=,:trim:sq=\":xml
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)