Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-8303

MySQL 8.0.29 - Assertion failure: dict0mem.h:2498:pos < n_def

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.29-21 (Q2 2022)
    • 8.0.29-21 (Q2 2022)
    • None
    • None

    Description

      MySQL crash on ALTER TABLE

      2022-06-22T19:12:24.533671Z 18 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0mem.h:2498:pos < n_def thread 140639784101632
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
      InnoDB: about forcing recovery.
      19:12:24 UTC - mysqld got signal 6 ;
      Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Build ID: 780edf68eec9d40e1a3e5b14fa9eee86ee46803c
      Server Version: 8.0.29-21-debug Percona Server (GPL), Revision 865615b8912-DebugThread pointer: 0x7fe89490c8b0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 7fe9405f5b98 thread_stack 0x100000
      /work/ps/ins/8.0/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x59) [0x56307f4a8232]
      /work/ps/ins/8.0/bin/mysqld(print_fatal_signal(int)+0x2bc) [0x56307e1fcd54]
      /work/ps/ins/8.0/bin/mysqld(my_server_abort()+0x78) [0x56307e1fd0b6]
      /work/ps/ins/8.0/bin/mysqld(my_abort()+0x11) [0x56307f49e071]
      /work/ps/ins/8.0/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1e7) [0x56307f996d7a]
      /work/ps/ins/8.0/bin/mysqld(dict_table_t::get_col(unsigned int) const+0x4e) [0x56307f62df94]
      /work/ps/ins/8.0/bin/mysqld(dict_mem_table_add_col(dict_table_t*, mem_block_info_t*, char const*, unsigned long, unsigned long, unsigned long, bool, unsigned int, unsigned char, unsigned char)+0x247) [0x56307f9aa415]
      /work/ps/ins/8.0/bin/mysqld(+0x5382455) [0x56307fb39455]
      /work/ps/ins/8.0/bin/mysqld(fill_dict_dropped_columns(dd::Table const*, dict_table_t*, unsigned int&, mem_block_info_t*)+0x187) [0x56307fb39c1b]
      /work/ps/ins/8.0/bin/mysqld(+0x53a3a9c) [0x56307fb5aa9c]
      /work/ps/ins/8.0/bin/mysqld(+0x53a0dac) [0x56307fb57dac]
      /work/ps/ins/8.0/bin/mysqld(dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::deque<char const*, ut::allocator<char const*, ut::detail::allocator_base_pfs<char const*> > >&)+0x1d2) [0x56307fb5238b]
      /work/ps/ins/8.0/bin/mysqld(dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*)+0x8b) [0x56307fb51bd0]
      /work/ps/ins/8.0/bin/mysqld(ha_innobase::open(char const*, int, unsigned int, dd::Table const*)+0x5ab) [0x56307f5f6dbf]
      /work/ps/ins/8.0/bin/mysqld(handler::ha_open(TABLE*, char const*, int, int, dd::Table const*)+0x23d) [0x56307dad126d]
      /work/ps/ins/8.0/bin/mysqld(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*)+0x14af) [0x56307e154bdf]
      /work/ps/ins/8.0/bin/mysqld(open_table(THD*, TABLE_LIST*, Open_table_context*)+0x1831) [0x56307dea9602]
      /work/ps/ins/8.0/bin/mysqld(+0x38e2d57) [0x56307e099d57]
      /work/ps/ins/8.0/bin/mysqld(mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*)+0x3ed7) [0x56307e0a6f57]
      /work/ps/ins/8.0/bin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5e5) [0x56307de9bd81]
      /work/ps/ins/8.0/bin/mysqld(mysql_execute_command(THD*, bool)+0x5cbe) [0x56307dfabaf6]
      /work/ps/ins/8.0/bin/mysqld(dispatch_sql_command(THD*, Parser_state*, bool)+0x7d5) [0x56307dfade77]
      /work/ps/ins/8.0/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1686) [0x56307dfa301b]
      /work/ps/ins/8.0/bin/mysqld(do_command(THD*)+0x5d2) [0x56307dfa0f01]
      /work/ps/ins/8.0/bin/mysqld(+0x3a2e3f1) [0x56307e1e53f1]
      /work/ps/ins/8.0/bin/mysqld(+0x55d64ae) [0x56307fd8d4ae]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7fe957d0a609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fe957386133]Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7fe8947363f0): ALTER TABLE test.tb3 ADD COLUMN col_last INT, ALGORITHM=INSTANT
      Connection ID (thread ID): 18
      Status: NOT_KILLEDPlease help us make Percona Server better by reporting any
      bugs at https://bugs.percona.com/You may download the Percona Server operations manual by visiting
      http://www.percona.com/software/percona-server/. You may find information
      in the manual which will help you identify the cause of the crash.
      Writing a core file 

      Attachments

        Activity

          People

            marcelo.altmann Marcelo Altmann
            marcelo.altmann Marcelo Altmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist