Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2679

odb crash when extracting data to xml file

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.3
    • db-utility-odb
    • None

    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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sujinpei 苏锦佩
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Slack

                  Issue deployment