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

Assertion `!space->stop_new_ops' failed in TRUNCATE TABLE with many indexes

    XMLWordPrintable

Details

    Description

      # Run with --mysqld=--innodb-page-size=4K
       
      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        i INT, d DATE, t TIME, dt DATETIME,
        KEY (d), KEY (t), KEY (dt), KEY (i)
      ) ENGINE=InnoDB;
       
      TRUNCATE TABLE t1;
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 ca3c8d9b58fdc26

      mysqld: /data/src/10.2/storage/innobase/fil/fil0fil.cc:878: void fil_flush_low(fil_space_t*): Assertion `!space->stop_new_ops' failed.
      170924 17:58:48 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc5609cbee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000560f7368be67 in fil_flush_low (space=0x7fc50800c060) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:878
      #9  0x0000560f7368cf98 in fil_space_extend_must_retry (space=0x7fc50800c060, node=0x7fc508031690, size=11, success=0x7fc5544ec72f) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:1236
      #10 0x0000560f7368d5fd in fil_space_extend (space=0x7fc50800c060, size=11) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:1399
      #11 0x0000560f736ab40a in fsp_try_extend_data_file_with_pages (space=0x7fc50800c060, page_no=10, header=0x7fc556281026 "", mtr=0x7fc5544ecd50) at /data/src/10.2/storage/innobase/fsp/fsp0fsp.cc:921
      #12 0x0000560f736b0d25 in fsp_reserve_free_pages (space=0x7fc50800c060, space_header=0x7fc556281026 "", size=10, mtr=0x7fc5544ecd50, n_pages=2) at /data/src/10.2/storage/innobase/fsp/fsp0fsp.cc:2761
      #13 0x0000560f736b0f56 in fsp_reserve_free_extents (n_reserved=0x7fc5544ec8f0, space_id=4, n_ext=2, alloc_type=FSP_NORMAL, mtr=0x7fc5544ecd50, n_pages=2) at /data/src/10.2/storage/innobase/fsp/fsp0fsp.cc:2835
      #14 0x0000560f736aeb93 in fseg_create_general (space_id=4, page=8, byte_offset=74, has_done_reservation=0, mtr=0x7fc5544ecd50) at /data/src/10.2/storage/innobase/fsp/fsp0fsp.cc:2116
      #15 0x0000560f736aefca in fseg_create (space=4, page=8, byte_offset=74, mtr=0x7fc5544ecd50) at /data/src/10.2/storage/innobase/fsp/fsp0fsp.cc:2209
      #16 0x0000560f735b2d99 in btr_create (type=0, space=4, page_size=..., index_id=25, index=0x7fc50814dfc8, btr_redo_create_info=0x0, mtr=0x7fc5544ecd50) at /data/src/10.2/storage/innobase/btr/btr0btr.cc:1196
      #17 0x0000560f73643bbc in dict_recreate_index_tree (table=0x7fc50800ab28, pcur=0x7fc5544ed268, mtr=0x7fc5544ecd50) at /data/src/10.2/storage/innobase/dict/dict0crea.cc:1155
      #18 0x0000560f735137d8 in CreateIndex::operator() (this=0x7fc5544ed3e0, mtr=0x7fc5544ecd50, pcur=0x7fc5544ed268) at /data/src/10.2/storage/innobase/row/row0trunc.cc:1032
      #19 0x0000560f7351b61f in IndexIterator::for_each<CreateIndex> (this=0x7fc5544ecd50, callback=...) at /data/src/10.2/storage/innobase/row/row0trunc.cc:110
      #20 0x0000560f73519c67 in SysIndexIterator::for_each<CreateIndex> (this=0x7fc5544ed3a0, callback=...) at /data/src/10.2/storage/innobase/row/row0trunc.cc:168
      #21 0x0000560f73515738 in row_truncate_table_for_mysql (table=0x7fc50800ab28, trx=0x7fc556921878) at /data/src/10.2/storage/innobase/row/row0trunc.cc:2041
      #22 0x0000560f733a1829 in ha_innobase::truncate (this=0x7fc508034618) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:13666
      #23 0x0000560f7308b0cf in handler::ha_truncate (this=0x7fc508034618) at /data/src/10.2/sql/handler.cc:4078
      #24 0x0000560f73251c3a in Sql_cmd_truncate_table::handler_truncate (this=0x7fc508012b20, thd=0x7fc508000b00, table_ref=0x7fc508012508, is_tmp_table=false) at /data/src/10.2/sql/sql_truncate.cc:245
      #25 0x0000560f73252274 in Sql_cmd_truncate_table::truncate_table (this=0x7fc508012b20, thd=0x7fc508000b00, table_ref=0x7fc508012508) at /data/src/10.2/sql/sql_truncate.cc:441
      #26 0x0000560f732523e6 in Sql_cmd_truncate_table::execute (this=0x7fc508012b20, thd=0x7fc508000b00) at /data/src/10.2/sql/sql_truncate.cc:498
      #27 0x0000560f72e1b99a in mysql_execute_command (thd=0x7fc508000b00) at /data/src/10.2/sql/sql_parse.cc:6203
      #28 0x0000560f72e2024a in mysql_parse (thd=0x7fc508000b00, rawbuf=0x7fc508012438 "TRUNCATE TABLE t1", length=17, parser_state=0x7fc5544ee200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7875
      #29 0x0000560f72e0defb in dispatch_command (command=COM_QUERY, thd=0x7fc508000b00, packet=0x7fc508084bb1 "TRUNCATE TABLE t1", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
      #30 0x0000560f72e0c875 in do_command (thd=0x7fc508000b00) at /data/src/10.2/sql/sql_parse.cc:1360
      #31 0x0000560f72f59ae1 in do_handle_one_connection (connect=0x560f755c4b90) at /data/src/10.2/sql/sql_connect.cc:1354
      #32 0x0000560f72f5986e in handle_one_connection (arg=0x560f755c4b90) at /data/src/10.2/sql/sql_connect.cc:1260
      #33 0x0000560f73376616 in pfs_spawn_thread (arg=0x560f755cf100) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #34 0x00007fc562910494 in start_thread (arg=0x7fc5544ef700) at pthread_create.c:333
      #35 0x00007fc560a8893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            marko Marko Mäkelä
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.