[ https://issues.apache.org/jira/browse/TRAFODION-2679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16076788#comment-16076788 ]
ASF GitHub Bot commented on TRAFODION-2679: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/1166 > 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)