Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4364

LOAD DATA crashes mariadb process

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.4.4
    • Fix Version/s: 5.4.3
    • Component/s: MariaDB Server
    • Labels:
      None

      Description

      Inserting one line of data with load data causes mariadb server to crash with the below stacktrace.

      stack_bottom = 0x7ff7840a3c38 thread_stack 0x49000
      /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c4492bd3ee]
      /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55c448d3daef]
      sigaction.c:0(__restore_rt)[0x7ff7c4b99630]
      :0(__memcpy_ssse3_back)[0x7ff7c2d1ea85]
      /lib64/libstdc++.so.6(_ZNSs15_M_replace_safeEmmPKcm+0x3b)[0x7ff7c33581bb]
      /usr/lib64/mysql/plugin/ha_columnstore.so(_Z28ha_mcs_impl_write_batch_row_PKhP5TABLERN11cal_impl_if19cal_connection_infoE+0x1125)[0x7ff7842683d5]
      /usr/lib64/mysql/plugin/ha_columnstore.so(_Z21ha_mcs_impl_write_rowPKhP5TABLEm+0x2cc)[0x7ff78423f8cc]
      /usr/lib64/mysql/plugin/ha_columnstore.so(_ZN6ha_mcs9write_rowEPKh+0x1f)[0x7ff78423a7cf]
      /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPKh+0x16d)[0x55c448d4903d]
      /usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x69)[0x55c448afa949]
      /usr/sbin/mysqld(_Z10mysql_loadP3THDPK12sql_exchangeP10TABLE_LISTR4ListI4ItemES9_S9_15enum_duplicatesbb+0x1ba0)[0x55c448b23b50]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x59a6)[0x55c448b324c6]
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x36d)[0x55c448b3605d]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2209)[0x55c448b38a39]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0x109)[0x55c448b39e99]
      /usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0xd2)[0x55c448d0f902]
      /usr/sbin/mysqld(+0xa5b3d0)[0x55c448ecc3d0]
      /usr/sbin/mysqld(+0xdfd8ed)[0x55c44926e8ed]
      pthread_create.c:0(start_thread)[0x7ff7c4b91ea5]
      /lib64/libc.so.6(clone+0x6d)[0x7ff7c2cc88dd]
      

      Command used:

      LOAD DATA LOCAL INFILE 'Rick2.txt'  INTO TABLE mytable  FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '#' LINES TERMINATED BY ''
      

      Table structure:

      CREATE TABLE `mytable` (
        `Id` bigint(20) NOT NULL,
        `redacted` bigint(20) unsigned DEFAULT NULL,
        `redacted` int(11) NOT NULL,
        `redacted` int(11) DEFAULT NULL,
        `redacted` int(11) DEFAULT NULL,
        `redacted` bigint(20) DEFAULT NULL,
        `redacted` int(11) NOT NULL,
        `redacted` bigint(20) NOT NULL,
        `redacted` bigint(20) NOT NULL,
        `redacted` int(4) unsigned DEFAULT NULL,
        `redacted` int(4) unsigned DEFAULT NULL,
        `redacted` int(4) unsigned DEFAULT NULL,
        `redacted` int(4) unsigned DEFAULT NULL,
        `redacted` int(4) unsigned DEFAULT NULL,
        `redacted` varchar(63) DEFAULT NULL,
        `redacted` decimal(18,8) NOT NULL,
        `redacted` decimal(18,8) NOT NULL,
        `redacted` tinyint(1) NOT NULL,
        `redacted` int(11) NOT NULL DEFAULT 0,
        `redacted` decimal(18,8) NOT NULL DEFAULT 0.00000000,
        `redacted` decimal(18,8) NOT NULL,
        `redacted` int(11) DEFAULT NULL,
        `redacted` int(11) DEFAULT NULL,
        `redacted` varchar(255) DEFAULT NULL,
        `redacted` decimal(18,8) DEFAULT 0.00000000,
        `redacted` decimal(18,8) DEFAULT NULL,
        `redacted` decimal(18,8) DEFAULT NULL,
        `redacted` decimal(5,2) DEFAULT NULL,
        `redacted` decimal(5,2) DEFAULT NULL,
        `redacted` decimal(8,4) DEFAULT NULL,
        `redacted` decimal(5,2) DEFAULT NULL,
        `redacted` decimal(8,2) DEFAULT NULL,
        `redacted` decimal(6,4) DEFAULT NULL,
        `redacted` int(3) DEFAULT NULL,
        `redacted` int(11) NOT NULL,
        `redacted` text DEFAULT NULL,
        `redacted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
        `redacted` text DEFAULT NULL,
        `redacted` text DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8
      

      Data row that makes it crash:

      3871250004#955385077888386499#131083#249881#171605#3826160523#5003#1577836919000#1577836919000#1#1#2020#0#3#"5141360283FC07BF"#40.54220581#-3.45858359#1#0#0.00001526#1154.44339348#NULL#NULL#""#0.00000000#NULL#NULL#NULL#NULL#NULL#NULL#NULL#NULL#NULL#37#"[]"#"2020-01-01 00:01:59"#NULL#01000000E066454440000000C02DAB0BC0D83B685E6F0100000000000000000000000000E066454440000000C02DAB0BC0604F685E6F0100000000000000000000000000E066454440000000C02DAB0BC0E862685E6F0100000000000000000000000000E066454440000000E02DAB0BC07076685E6F01000000000000000000000000000067454440000000E02DAB0BC0F889685E6F01000000000000000000000000000067454440000000E02DAB0BC0809D685E6F01000000000000000000000000000067454440000000E02DAB0BC008B1685E6F0100000000000000000000
      

      The customer is unable to load data from application because of this bug, hence a blocker. cpimport can't be used because requires data to be on CS server.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              rpizzi Rick Pizzi
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: