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

[draft]Assertion `index->table->is_instant()' failed in btr_cur_upd_rec_in_place

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.1(EOL)
    • None
    • None
    • None

    Description

      mysqld: /11.1/storage/innobase/btr/btr0cur.cc:2907: void btr_cur_upd_rec_in_place(rec_t*, const dict_index_t*, const rec_offs*, const upd_t*, buf_block_t*, mtr_t*): Assertion `index->table->is_instant()' failed.
       
      230727 13:41:28 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.1.2-MariaDB-debug-log source revision: c6ac1e39b694568c459bf03e9894b230302f4bfb
       
      linux/raise.c:51(__GI_raise)[0x7f5d6f4868eb]
      stdlib/abort.c:81(__GI_abort)[0x7f5d6f471535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f5d6f47140f]
      /lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f5d6f47f1a2]
      btr/btr0cur.cc:2908(btr_cur_upd_rec_in_place(unsigned char*, dict_index_t const*, unsigned short const*, upd_t const*, buf_block_t*, mtr_t*))[0x55f1e58385e1]
      btr/btr0cur.cc:3163(btr_cur_update_in_place(unsigned long, btr_cur_t*, unsigned short*, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*))[0x55f1e583ab82]
      btr/btr0cur.cc:3392(btr_cur_optimistic_update(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*))[0x55f1e583d821]
      row/row0upd.cc:2353(row_upd_clust_rec(unsigned long, upd_node_t*, dict_index_t*, unsigned short*, mem_block_info_t**, que_thr_t*, mtr_t*))[0x55f1e5702efa]
      row/row0upd.cc:2672(row_upd_clust_step(upd_node_t*, que_thr_t*))[0x55f1e5704b30]
      row/row0upd.cc:2735(row_upd(upd_node_t*, que_thr_t*))[0x55f1e5705341]
      row/row0upd.cc:2877(row_upd_step(que_thr_t*))[0x55f1e570622e]
      row/row0mysql.cc:1998(row_update_cascade_for_mysql(que_thr_t*, upd_node_t*, dict_table_t*))[0x55f1e565be8f]
      row/row0ins.cc:1350(row_ins_foreign_check_on_constraint(que_thr_t*, dict_foreign_t*, btr_pcur_t*, dtuple_t*, mtr_t*))[0x55f1e5601c5f]
      row/row0ins.cc:1743(row_ins_check_foreign_constraint(unsigned long, dict_foreign_t*, dict_table_t*, dtuple_t*, que_thr_t*))[0x55f1e56037fb]
      row/row0upd.cc:252(row_upd_check_references_constraints(upd_node_t*, btr_pcur_t*, dict_table_t*, dict_index_t*, unsigned short*, que_thr_t*, mtr_t*))[0x55f1e56f5bd0]
      row/row0upd.cc:1985(row_upd_sec_index_entry(upd_node_t*, que_thr_t*))[0x55f1e56ffe87]
      row/row0upd.cc:2038(row_upd_sec_step(upd_node_t*, que_thr_t*))[0x55f1e57006c7]
      row/row0upd.cc:2762(row_upd(upd_node_t*, que_thr_t*))[0x55f1e5705753]
      row/row0upd.cc:2877(row_upd_step(que_thr_t*))[0x55f1e570622e]
      row/row0mysql.cc:1686(row_update_for_mysql(row_prebuilt_t*))[0x55f1e5659e20]
      handler/ha_innodb.cc:8706(ha_innobase::delete_row(unsigned char const*))[0x55f1e52b3234]
      sql/handler.cc:7943(handler::ha_delete_row(unsigned char const*))[0x55f1e488e766]
      sql/sql_delete.cc:289(TABLE::delete_row())[0x55f1e3e6b25c]
      sql/sql_delete.cc:824(Sql_cmd_delete::delete_from_single_table(THD*))[0x55f1e3e5e9bb]
      sql/sql_delete.cc:1794(Sql_cmd_delete::execute_inner(THD*))[0x55f1e3e6877f]
      sql/sql_select.cc:33356(Sql_cmd_dml::execute(THD*))[0x55f1e4130d9b]
      sql/sql_parse.cc:4393(mysql_execute_command(THD*, bool))[0x55f1e3f558d3]
      sql/sql_parse.cc:7774(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55f1e3f6ccc4]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55f1e3f45918]
      sql/sql_parse.cc:1405(do_command(THD*, bool))[0x55f1e3f4260b]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55f1e43fdf36]
      sql/sql_connect.cc:1320(handle_one_connection)[0x55f1e43fd88c]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55f1e50afeab]
      nptl/pthread_create.c:487(start_thread)[0x7f5d6f93efa3]
      x86_64/clone.S:97(clone)[0x7f5d6f54806f]
       
      Query (0x6290016f82a8): DELETE FROM `t9` ORDER BY `col_timestamp` LIMIT 4
      

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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