[TRAFODION-2679] odb crash when extracting data to xml file

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3
• Component/s: db-utility-odb
• Assignee: Unassigned
• Reporter: 苏锦佩
• Created: 06/Jul/17 07:45
• Updated: 15/Sep/18 07:31
• Resolved: 18/Sep/17 08:20

Description

[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

Issue Links

• links to: GitHub Pull Request #1166