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

Assertion `btr_cur->rtr_info->thr || !btr_cur->index()->is_committed()' failed in rtr_ins_enlarge_mbr after ALTER table force

    XMLWordPrintable

Details

    Description

      to repeat please run MDEV-30895.test

      11.0

      mariadbd: /11.0/src/storage/innobase/gis/gis0rtree.cc:1471: dberr_t rtr_ins_enlarge_mbr(btr_cur_t*, mtr_t*): Assertion `btr_cur->rtr_info->thr || !btr_cur->index()->is_committed()' failed.
      230321 16:38:56 [ERROR] mysqld got signal 6 ;
       
       
      Server version: 11.0.2-MariaDB-debug-log source revision: f6cb93ba8d24c2e67d396c3dd9ef2b0bb3a3e665
       
      ??:0(gsignal)[0x7f8c905f100b]
      ??:0(abort)[0x7f8c905d0859]
      /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f8c905d0729]
      ??:0(__assert_fail)[0x7f8c905e1fd6]
      gis/gis0rtree.cc:1474(rtr_ins_enlarge_mbr(btr_cur_t*, mtr_t*))[0x55bda321afcb]
      row/row0merge.cc:211(spatial_index_info::insert(unsigned long, btr_pcur_t*, bool&, mem_block_info_t*, mtr_t*))[0x55bda2de5339]
      row/row0merge.cc:1754(row_merge_spatial_rows(unsigned long, spatial_index_info**, unsigned long, mem_block_info_t*, btr_pcur_t*, bool&, mtr_t*))[0x55bda2dc5ffe]
      row/row0merge.cc:2143(row_merge_read_clustered_index(trx_t*, TABLE*, dict_table_t const*, dict_table_t*, bool, dict_index_t**, dict_index_t*, fts_psort_t*, merge_file_t*, unsigned long const*, unsigned long, dtuple_t const*, dict_add_v_col_t const*, unsigned long const*, unsigned long, ib_sequence_t&, unsigned char*, bool, pfs_os_file_t*, ut_stage_alter_t*, double, unsigned char*, TABLE*, bool, std::map<unsigned int, dict_col_t*, std::less<unsigned int>, std::allocator<std::pair<unsigned int const, dict_corow/row0merge.cc:4793(row_merge_build_indexes(trx_t*, dict_table_t*, dict_table_t*, bool, dict_index_t**, unsigned long const*, unsigned long, TABLE*, dtuple_t const*, unsigned long const*, unsigned long, ib_sequence_t&, bool, ut_stage_alter_t*, dict_add_v_col_t const*, TABLE*, bool, std::map<unsigned int, dict_col_t*, std::less<unsigned int>, std::allocator<std::pair<unsigned int const, dict_col_t*> > > const*))[0x55bda2ddc9f8]
      handler/handler0alter.cc:8702(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55bda2b13a17]
      sql/handler.h:4824(handler::ha_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55bda1a98d0a]
      sql/sql_table.cc:7744(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, MDL_request*, st_ddl_log_state*, TRIGGER_RENAME_PARAM*, Alter_table_ctx*, bool&, unsigned long long&, bool))[0x55bda1a72223]
      sql/sql_table.cc:10846(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, TABLE_LIST*, Recreate_info*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55bda1a8982b]
      sql/sql_alter.cc:558(Sql_cmd_alter_table::execute(THD*))[0x55bda1c54bab]
      sql/sql_parse.cc:6003(mysql_execute_command(THD*, bool))[0x55bda1789582]
      sql/sql_parse.cc:7999(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55bda1796848]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55bda176ca9e]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55bda17697da]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55bda1c36c33]
      sql/sql_connect.cc:1320(handle_one_connection)[0x55bda1c36590]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55bda284bd2c]
      nptl/pthread_create.c:478(start_thread)[0x7f8c90afc609]
       
      Query (0x6290001092a8): ALTER  TABLE  t1 FORCE
      
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.