Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
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