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

Server crashes on insert after changing table option to sequence=0 for engine InnoDB

    XMLWordPrintable

Details

    Description

      Server crashes on insert after changing table option to sequence=0 for engine InnoDB with error:

      ../storage/innobase/row/row0ins.cc:295: dberr_t row_ins_clust_index_entry_by_modify(btr_pcur_t*, ulint, ulint, rec_offs**, mem_heap_t**, mem_heap_t*, const dtuple_t*, que_thr_t*, mtr_t*): Assertion `rec_get_deleted_flag(rec, cursor->index()->table->not_redundant())' failed
      

      Case example:

      --source include/have_innodb.inc
       
      create sequence s engine=InnoDB;
      alter table s sequence=0;
      insert into s values (3,1,9223372036854775806,1,1,1000,0,0);
      drop table s;
      

      Stacktrace for v.11.8:

      mysys/stacktrace.c:215(my_print_stacktrace)[0x56c9e6449e34]
      sql/signal_handler.cc:247(handle_fatal_signal)[0x56c9e5a390bb]
      libc_sigaction.c:0(__restore_rt)[0x7c2ef4c42520]
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7c2ef4c969fc]
      posix/raise.c:27(__GI_raise)[0x7c2ef4c42476]
      stdlib/abort.c:81(__GI_abort)[0x7c2ef4c287f3]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7c2ef4c2871b]
      /lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7c2ef4c39e96]
      row/row0ins.cc:299(row_ins_clust_index_entry_by_modify(btr_pcur_t*, unsigned long, unsigned long, unsigned short**, mem_block_info_t**, mem_block_info_t*, dtuple_t const*, que_thr_t*, mtr_t*))[0x56c9e60d7160]
      row/row0ins.cc:2865(row_ins_clust_index_entry_low(unsigned long, btr_latch_mode, dict_index_t*, unsigned long, dtuple_t*, unsigned long, que_thr_t*))[0x56c9e60df619]
      row/row0ins.cc:3267(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, unsigned long))[0x56c9e60e0d7e]
      row/row0ins.cc:3402(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x56c9e60e13eb]
      row/row0ins.cc:3568(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x56c9e60e1d7c]
      row/row0ins.cc:3685(row_ins(ins_node_t*, que_thr_t*))[0x56c9e60e229a]
      row/row0ins.cc:3814(row_ins_step(que_thr_t*))[0x56c9e60e2b13]
      row/row0mysql.cc:1292(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x56c9e610a735]
      handler/ha_innodb.cc:7744(ha_innobase::write_row(unsigned char const*))[0x56c9e5ee5a15]
      sql/handler.cc:8194(handler::ha_write_row(unsigned char const*))[0x56c9e5a56107]
      sql/sql_insert.cc:2321(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x56c9e55aa626]
      sql/sql_insert.cc:1181(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x56c9e55a69ee]
      sql/sql_parse.cc:4471(mysql_execute_command(THD*, bool))[0x56c9e5601346]
      sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x56c9e560cc3c]
      sql/sql_parse.cc:1905(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56c9e55f9134]
      sql/sql_parse.cc:1416(do_command(THD*, bool))[0x56c9e55f7a7a]
      sql/sql_connect.cc:1438(do_handle_one_connection(CONNECT*, bool))[0x56c9e5802868]
      sql/sql_connect.cc:1352(handle_one_connection)[0x56c9e58025dd]
      perfschema/pfs.cc:2200(pfs_spawn_thread)[0x56c9e5dda48f]
      nptl/pthread_create.c:442(start_thread)[0x7c2ef4c94ac3]
      x86_64/clone3.S:83(__clone3)[0x7c2ef4d26850]
      

      Attachments

        Activity

          People

            monty Michael Widenius
            lstartseva Lena Startseva
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.