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

Crash in innodb when doing recovery of a sequence

    XMLWordPrintable

Details

    Description

      Copy the included script to mysql-test/main and run
      mtr main.skr

      This produces a stack trace similar to the following after restart.
      My guess is that the recovery of the sequence table did not work properly.

      mariadbd: /my/maria-11.8/storage/innobase/lock/lock0lock.cc:1759: dberr_t lock_rec_lock(bool, unsigned int, const buf_block_t*, ulint, dict_index_t*, que_thr_t*): Assertion `((0x7 | 8U) & mode) == LOCK_S || ((0x7 | 8U) & mode) == LOCK_X' failed.
      250206 13:25:16 [ERROR] mysqld got signal 6 ;
      ...
      lock/lock0lock.cc:1761(lock_rec_lock(bool, unsigned int, buf_block_t const*, unsigned long, dict_index_t*, que_thr_t*))[0x13d6c76]
      lock/lock0lock.cc:6385(lock_clust_rec_read_check_and_lock(unsigned long, buf_block_t const*, unsigned char const*, dict_index_t*, unsigned short const*, lock_mode, unsigned int, que_thr_t*))[0x13e7f17]
      row/row0sel.cc:1355(sel_set_rec_lock(btr_pcur_t*, unsigned char const*, dict_index_t*, unsigned short const*, unsigned int, unsigned int, que_thr_t*, mtr_t*))[0x153eb93]
      row/row0sel.cc:4948(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x15489da]
      handler/ha_innodb.cc:8982(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x1341b77]
      handler/ha_innodb.cc:9318(ha_innobase::index_first(unsigned char*))[0x13429f4]
      handler/ha_innodb.cc:9422(ha_innobase::rnd_next(unsigned char*))[0x1342c0a]
      sql/ha_sequence.h:113(ha_sequence::rnd_next(unsigned char*))[0x11a2177]
      sql/handler.cc:3743(handler::ha_rnd_next(unsigned char*))[0xdf5d87]
      sql/handler.cc:4051(handler::read_first_row(unsigned char*, unsigned int))[0xdf8e1d]
      sql/sql_class.h:8006(handler::ha_read_first_row(unsigned char*, unsigned int))[0xaa2a75]
      sql/sql_sequence.cc:740(SEQUENCE::read_stored_values(TABLE*))[0xd004c7]
      sql/sql_sequence.cc:675(SEQUENCE::read_initial_values(TABLE*))[0xd00309]
      sql/ha_sequence.cc:122(ha_sequence::open(char const*, int, unsigned int))[0x11a0d55]
      sql/handler.cc:3627(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0xdf5096]
      sql/table.cc:4635(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0xb6ac86]
      sql/sql_base.cc:2240(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x9208ba]
      sql/sql_base.cc:4180(open_and_process_table(THD*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x924dbb]
      sql/sql_base.cc:4666(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x926008]
      sql/sql_base.h:503(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int))[0x911365]
      sql/sql_show.cc:1264(mysqld_show_create_get_fields(THD*, TABLE_LIST*, List<Item>*, String*))[0xaaba8d]
      sql/sql_show.cc:1370(mysqld_show_create(THD*, TABLE_LIST*))[0xaac1c8]
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              monty Michael Widenius
              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.