Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29913

Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init upon bulk load

    XMLWordPrintable

Details

    Description

      --source include/have_sequence.inc
      --source include/have_innodb.inc
       
      SELECT * INTO OUTFILE 'numbers' FROM seq_1_to_20165;
       
      CREATE TABLE t (
        pk int,
        f1 varchar(4) DEFAULT 'foo',
        f2 varchar(16) DEFAULT 'foobarqux',
        f3 bigint default 0,
        f4 timestamp default '2000-01-01',
        f5 tinyint default 0,
        KEY(pk)
      ) ENGINE=InnoDB;
       
      SET FOREIGN_KEY_CHECKS=0, UNIQUE_CHECKS=0, AUTOCOMMIT=0;
      LOAD DATA INFILE 'numbers' INTO TABLE t (pk);
       
      # Cleanup
      --let $datadir= `select @@datadir`
      --remove_file $datadir/test/numbers
      DROP TABLE t;
      

      10.7 dd9da61d

      mariadbd: /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_class.cc:4730: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
      221029 22:11:09 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f9ebc70d662 in __GI___assert_fail (assertion=0x55fa5248f3c0 "thd->stmt_arena != thd->progress.arena", file=0x55fa5248ac40 "/home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_class.cc", line=4730, function=0x55fa5248f420 "void thd_progress_init(THD*, uint)") at assert.c:101
      #8  0x000055fa5044ca27 in thd_progress_init (thd=0x62b00017a218, max_stage=1) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_class.cc:4730
      #9  0x000055fa51b159f4 in row_merge_sort (trx=0x7f9eb326b340, dup=0x7f9ea91e6e90, file=0x608000012c38, block=0x7f9ea7fa3000 "\004\t\003", tmpfd=0x60d0000101e8, update_progress=true, pct_progress=0, pct_cost=0, crypt_block=0x0, space=5, stage=0x0) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0merge.cc:3577
      #10 0x000055fa51b21fa1 in row_merge_bulk_t::write_to_index (this=0x60d0000101d0, index_no=0, trx=0x7f9eb326b340) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0merge.cc:5352
      #11 0x000055fa51b222ef in row_merge_bulk_t::write_to_table (this=0x60d0000101d0, table=0x61800004b920, trx=0x7f9eb326b340) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0merge.cc:5379
      #12 0x000055fa517e1ab1 in trx_mod_table_time_t::write_bulk (this=0x608000012be0, table=0x61800004b920, trx=0x7f9eb326b340) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/include/trx0trx.h:522
      #13 0x000055fa517e2cad in trx_t::bulk_insert_apply (this=0x7f9eb326b340) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/include/trx0trx.h:1163
      #14 0x000055fa517bf07a in ha_innobase::extra (this=0x61d0002ec2b8, operation=HA_EXTRA_NO_IGNORE_DUP_KEY) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/handler/ha_innodb.cc:15721
      #15 0x000055fa50550852 in mysql_load (thd=0x62b00017a218, ex=0x629000109328, table_list=0x6290001093d0, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_ERROR, ignore=false, read_file_from_client=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_load.cc:704
      #16 0x000055fa5057f844 in mysql_execute_command (thd=0x62b00017a218, is_called_from_prepared_stmt=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:5021
      #17 0x000055fa5059361d in mysql_parse (thd=0x62b00017a218, rawbuf=0x629000109238 "LOAD DATA INFILE 'numbers' INTO TABLE t (pk)", length=44, parser_state=0x7f9ea91e8990) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:8014
      #18 0x000055fa50569fb7 in dispatch_command (command=COM_QUERY, thd=0x62b00017a218, packet=0x62900028f219 "", packet_length=44, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1894
      #19 0x000055fa50566d8a in do_command (thd=0x62b00017a218, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1407
      #20 0x000055fa509f9522 in do_handle_one_connection (connect=0x6080000032b8, put_in_cache=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1416
      #21 0x000055fa509f8eb8 in handle_one_connection (arg=0x608000003238) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1318
      #22 0x000055fa515a57a2 in pfs_spawn_thread (arg=0x617000007418) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/perfschema/pfs.cc:2201
      #23 0x00007f9ebcbebea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #24 0x00007f9ebc7d8aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.