repro error log 2: [ec2-user@ip-10-0-3-185 msb_8_0_29]$ grep -i "Assertion failure" data/msandbox.err [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903528736512 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903394338560 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903997662976 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: page0page.cc:144 thread 139762896926464 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: page0page.cc:144 thread 139762662041344 InnoDB: If you get repeated assertion failures or crashes, even Full log: 2022-07-20T22:27:43.891843Z 59 [ERROR] [MY-011855] [InnoDB] Page old data size 15646 new data size 6762, page old max ins size 554 new max ins size 9438 2022-07-20T22:27:43.891872Z 59 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:27:43.891883Z 59 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903528736512 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. 22:27:43 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f3d5c000e80 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 = 7f3dd4220d60 thread_stack 0x100000 2022-07-20T22:27:43.897239Z 55 [ERROR] [MY-011855] [InnoDB] Page old data size 15766 new data size 6882, page old max ins size 434 new max ins size 9318 2022-07-20T22:27:43.897262Z 55 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:27:43.899757Z 57 [ERROR] [MY-011855] [InnoDB] Page old data size 15706 new data size 6822, page old max ins size 494 new max ins size 9378 2022-07-20T22:27:43.899775Z 57 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:27:43.907762Z 60 [ERROR] [MY-011855] [InnoDB] Page old data size 15646 new data size 6762, page old max ins size 554 new max ins size 9438 2022-07-20T22:27:43.907784Z 60 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:27:43.907794Z 60 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903394338560 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. /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x227c25e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry_low(unsigned int, unsigned long, dict_index_t*, unsigned long, dtuple_t*, que_thr_t*, bool)+0x881) [0x21731a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0xbe) [0x2179e8e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_step(que_thr_t*)+0x1a1) [0x217ac61] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180154] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::write_row(unsigned char*)+0x24f) [0x206435f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_write_row(unsigned char*)+0x1d8) [0x113ce48] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x624) [0x13a2f54] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x799) [0x13a41c9] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x2c5) [0xf46e55] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(mysql_execute_command(THD*, bool)+0xab8) [0xee5c18] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xeeaa63] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe40) [0xeebda0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(do_command(THD*)+0x103) [0xeede93] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x1026898] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7f3e02a1c44b] /lib64/libc.so.6(clone+0x3f) [0x7f3e00c8140f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f3d5c0ab4e0): INSERT INTO sbtest1 (id, k, c, pad) VALUES (22805, 15987, '15654308349-52809374945-20485398089-27267166524-21640749180-41356744010-27019902854-65257474405-16843935125-74753508095', '12454825499-10684099422-46839192415-57167377020-76706133029') Connection ID (thread ID): 59 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 22:27:43 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f3d7c014370 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 = 7f3dcc1f4d60 thread_stack 0x100000 2022-07-20T22:27:43.916135Z 61 [ERROR] [MY-011855] [InnoDB] Page old data size 15646 new data size 6762, page old max ins size 554 new max ins size 9438 2022-07-20T22:27:43.916156Z 61 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:27:43.916166Z 61 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 139903997662976 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. /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x227c25e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry_low(unsigned int, unsigned long, dict_index_t*, unsigned long, dtuple_t*, que_thr_t*, bool)+0x881) [0x21731a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0xbe) [0x2179e8e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_step(que_thr_t*)+0x1a1) [0x217ac61] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180154] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::write_row(unsigned char*)+0x24f) [0x206435f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_write_row(unsigned char*)+0x1d8) [0x113ce48] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x624) [0x13a2f54] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x799) [0x13a41c9] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x2c5) [0xf46e55] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(mysql_execute_command(THD*, bool)+0xab8) [0xee5c18] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xeeaa63] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe40) [0xeebda0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(do_command(THD*)+0x103) [0xeede93] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x1026898] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7f3e02a1c44b] /lib64/libc.so.6(clone+0x3f) [0x7f3e00c8140f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f3d7c030b50): INSERT INTO sbtest1 (id, k, c, pad) VALUES (16282, 22650, '79588729852-32358987034-57225665329-57819481684-31141934693-89812979619-11237005344-44727329649-81511156993-37325807777', '52630998472-46363309763-30531689254-46439053003-69962119857') Connection ID (thread ID): 60 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 22:27:43 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f3d78000e80 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 = 7f3df0154d60 thread_stack 0x100000 /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x227c25e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry_low(unsigned int, unsigned long, dict_index_t*, unsigned long, dtuple_t*, que_thr_t*, bool)+0x881) [0x21731a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0xbe) [0x2179e8e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_ins_step(que_thr_t*)+0x1a1) [0x217ac61] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180154] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::write_row(unsigned char*)+0x24f) [0x206435f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_write_row(unsigned char*)+0x1d8) [0x113ce48] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x624) [0x13a2f54] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x799) [0x13a41c9] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x2c5) [0xf46e55] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(mysql_execute_command(THD*, bool)+0xab8) [0xee5c18] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xeeaa63] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe40) [0xeebda0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(do_command(THD*)+0x103) [0xeede93] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x1026898] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7f3e02a1c44b] /lib64/libc.so.6(clone+0x3f) [0x7f3e00c8140f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f3d78244bc0): INSERT INTO sbtest1 (id, k, c, pad) VALUES (14532, 7705, '93685670927-05959582718-28947206537-05618749784-23216999420-29615839579-66720290219-92612985075-65885225415-65875276455', '58239182857-45055690901-85093802257-85307792458-37731108859') Connection ID (thread ID): 61 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2022-07-20T22:27:44.063640Z mysqld_safe Number of processes running now: 0 2022-07-20T22:27:44.067296Z mysqld_safe mysqld restarted 2022-07-20T22:27:44.348102Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 20012 2022-07-20T22:27:44.355734Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:27:44.483286Z 0 [ERROR] [MY-012685] [InnoDB] Probable data corruption on page 31. Original record on that page; (compact record)2022-07-20T22:27:44.483332Z 0 [ERROR] [MY-012686] [InnoDB] Cannot find the dir slot for this record on that page; (compact record)2022-07-20T22:27:44.483353Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: page0page.cc:144 thread 139762896926464 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. 22:27:44 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x0 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... 2022-07-20T22:27:44.484361Z 0 [ERROR] [MY-012685] [InnoDB] Probable data corruption on page 245. Original record on that page; (compact record)2022-07-20T22:27:44.484402Z 0 [ERROR] [MY-012686] [InnoDB] Cannot find the dir slot for this record on that page; (compact record)stack_bottom = 0 thread_stack 0x100000 2022-07-20T22:27:44.484421Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: page0page.cc:144 thread 139762662041344 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. /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_dir_find_owner_slot(unsigned char const*)+0x4ed) [0x2144d4d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_delete_rec_list_end(unsigned char*, buf_block_t*, dict_index_t*, unsigned long, unsigned long, mtr_t*)+0x33a) [0x2145a8a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_parse_delete_rec_list(mlog_id_t, unsigned char*, unsigned char*, buf_block_t*, dict_index_t*, mtr_t*)+0x6f) [0x214641f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x210f1f8] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(recv_recover_page_func(bool, buf_block_t*)+0x827) [0x2111417] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_io_complete(buf_page_t*, bool)+0x4a9) [0x229bf89] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(fil_aio_wait(unsigned long)+0x11a) [0x238f1ea] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21da1e0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(std::thread::_State_impl > >::_M_run()+0xb0) [0x21da3d0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x277a69f] /lib64/libpthread.so.0(+0x744b) [0x7f1d2c22944b] /lib64/libc.so.6(clone+0x3f) [0x7f1d2a48e40f] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 22:27:44 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x0 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 = 0 thread_stack 0x100000 /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_dir_find_owner_slot(unsigned char const*)+0x4ed) [0x2144d4d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_delete_rec_list_end(unsigned char*, buf_block_t*, dict_index_t*, unsigned long, unsigned long, mtr_t*)+0x33a) [0x2145a8a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(page_parse_delete_rec_list(mlog_id_t, unsigned char*, unsigned char*, buf_block_t*, dict_index_t*, mtr_t*)+0x6f) [0x214641f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x210f1f8] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(recv_recover_page_func(bool, buf_block_t*)+0x827) [0x2111417] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_io_complete(buf_page_t*, bool)+0x4a9) [0x229bf89] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(fil_aio_wait(unsigned long)+0x11a) [0x238f1ea] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21da1e0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(std::thread::_State_impl > >::_M_run()+0xb0) [0x21da3d0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x277a69f] /lib64/libpthread.so.0(+0x744b) [0x7f1d2c22944b] /lib64/libc.so.6(clone+0x3f) [0x7f1d2a48e40f] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2022-07-20T22:27:44.579430Z mysqld_safe mysqld from pid file /home/ec2-user/sandboxes/msb_8_0_29/data/mysql_sandbox8029.pid ended ============================== Here I added a instant col between two instant cols created on 8.0.27 # To produce stack from "repro error 3" : # add the instant col between two other instant cols instead of the above # here we are adding pad middle between instant columns pad_2 and pad # which produces a different crash see "repro error 3" /home/ec2-user/sandboxes/msb_8_0_29/use -e "alter table sysbench_2.sbtest1 add column pad_middle varchar(60) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci DEFAULT NULL after pad_2, ALGORITHM=instant;" [ec2-user@ip-10-0-3-185 msb_8_0_29]$ grep "Assertion failure" data/msandbox.err [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:3222:block->page.get_space() != nullptr thread 140467381581568 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:3222:block->page.get_space() != nullptr thread 139667373647616 Full log: [ec2-user@ip-10-0-3-185 msb_8_0_29]$ tail -F data/msandbox.err 2022-07-20T22:43:59.321497Z mysqld_safe Starting mysqld daemon with databases from /home/ec2-user/sandboxes/msb_8_0_29/data 2022-07-20T22:43:59.600981Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 27825 2022-07-20T22:43:59.608317Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:43:59.823704Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-07-20T22:44:02.234037Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80029' started. 2022-07-20T22:44:06.384752Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80029' completed. 2022-07-20T22:44:06.515631Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-07-20T22:44:06.515661Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-07-20T22:44:06.531018Z 0 [System] [MY-010931] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld: ready for connections. Version: '8.0.29' socket: '/tmp/mysql_sandbox8029.sock' port: 8029 MySQL Community Server - GPL. 2022-07-20T22:44:06.531035Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 18030, socket: /tmp/mysqlx-18030.sock 2022-07-20T22:44:53.015080Z 26 [Warning] [MY-013021] [InnoDB] A transaction id in a record of table `sysbench_2`.`sbtest1` is newer than the system-wide maximum. 2022-07-20T22:44:53.015120Z 26 [Warning] [MY-013021] [InnoDB] A transaction id in a record of table `sysbench_2`.`sbtest1` is newer than the system-wide maximum. 2022-07-20T22:44:53.015138Z 26 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:3222:block->page.get_space() != nullptr thread 140467381581568 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. 22:44:53 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fc0bc000e80 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 = 7fc11c61ad60 thread_stack 0x100000 /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x229430c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x229aeab] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_init_for_read(dberr_t*, unsigned long, page_id_t const&, page_size_t const&, bool)+0x2b4) [0x229d7e4] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool)+0x86) [0x22cd266] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_read_page(page_id_t const&, page_size_t const&)+0x37) [0x22cd8d7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch::read_page()+0x26) [0x229b226] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch_normal::get(buf_block_t*&)+0x68) [0x229b438] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch::single_page()+0x46) [0x22a32b6] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, Page_fetch, ut::Location, mtr_t*, bool)+0x1c0) [0x22a3e60] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x220d1e2] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(trx_undo_prev_version_build(unsigned char const*, mtr_t*, unsigned char const*, dict_index_t const*, unsigned long*, mem_block_info_t*, unsigned char**, mem_block_info_t*, dtuple_t const**, unsigned long, lob::undo_vers_t*)+0x256) [0x220d646] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_vers_build_for_consistent_read(unsigned char const*, mtr_t*, dict_index_t*, unsigned long**, ReadView*, mem_block_info_t**, mem_block_info_t*, unsigned char**, dtuple_t const**, lob::undo_vers_t*)+0x22a) [0x21c901a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x39c7) [0x21b55d7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function)+0x301) [0x2063a81] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)+0x399) [0x113d7a9] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::read_range_first(key_range const*, key_range const*, bool, bool)+0x5f) [0x113e06f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::read_range_first(key_range const*, key_range const*, bool, bool)+0x28) [0x2041ab8] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::multi_range_read_next(char**)+0x14d) [0x113e61d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_multi_range_read_next(char**)+0x28) [0x113ae78] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(IndexRangeScanIterator::Read()+0x47) [0x133fda7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(FilterIterator::Read()+0x14) [0x13d9e64] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(MaterializeIterator::MaterializeQueryBlock(MaterializeIterator::QueryBlock const&, unsigned long long*)+0x197) [0x13dc207] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(MaterializeIterator::Init()+0x311) [0x13dcae1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(filesort(THD*, Filesort*, RowIterator*, unsigned long, unsigned long long, Filesort_info*, Sort_result*, unsigned long long*)+0x356) [0x1123e26] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(SortingIterator::DoSort()+0x5f) [0x127b54f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(SortingIterator::Init()+0x21) [0x127b5c1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0x345) [0xfb8175] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Query_expression::execute(THD*)+0x2c) [0xfb83dc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x2c5) [0xf46e55] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(mysql_execute_command(THD*, bool)+0xab8) [0xee5c18] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xeeaa63] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe40) [0xeebda0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(do_command(THD*)+0x103) [0xeede93] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x1026898] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7fc14bdb044b] /lib64/libc.so.6(clone+0x3f) [0x7fc14a01540f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fc0bc0a7560): SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 24491 AND 24590 ORDER BY c Connection ID (thread ID): 26 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2022-07-20T22:44:53.152680Z mysqld_safe Number of processes running now: 0 2022-07-20T22:44:53.156148Z mysqld_safe mysqld restarted 2022-07-20T22:44:53.439415Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 28534 2022-07-20T22:44:53.446922Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:44:55.207064Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-07-20T22:44:55.318942Z 4 [System] [MY-013381] [Server] Server upgrade from '80029' to '80029' started. 2022-07-20T22:45:00.450867Z 4 [System] [MY-013381] [Server] Server upgrade from '80029' to '80029' completed. 2022-07-20T22:45:00.528976Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2022-07-20T22:45:00.554104Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2022-07-20T22:45:00.659192Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-07-20T22:45:00.659221Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-07-20T22:45:00.673037Z 0 [System] [MY-010931] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld: ready for connections. Version: '8.0.29' socket: '/tmp/mysql_sandbox8029.sock' port: 8029 MySQL Community Server - GPL. 2022-07-20T22:45:00.673079Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 18030, socket: /tmp/mysqlx-18030.sock 2022-07-20T22:45:08.451094Z 13 [Warning] [MY-013021] [InnoDB] A transaction id in a record of table `sysbench_2`.`sbtest1` is newer than the system-wide maximum. 2022-07-20T22:45:08.451138Z 13 [Warning] [MY-013021] [InnoDB] A transaction id in a record of table `sysbench_2`.`sbtest1` is newer than the system-wide maximum. 2022-07-20T22:45:08.451153Z 13 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:3222:block->page.get_space() != nullptr thread 139667373647616 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. 22:45:08 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f0660000e80 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 = 7f06d8315d60 thread_stack 0x100000 /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1f80d4e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x103587b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_server_abort()+0x5e) [0x103597e] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(my_abort()+0xa) [0x1f7b4fa] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x223b96c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x229430c] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x229aeab] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_init_for_read(dberr_t*, unsigned long, page_id_t const&, page_size_t const&, bool)+0x2b4) [0x229d7e4] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool)+0x86) [0x22cd266] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_read_page(page_id_t const&, page_size_t const&)+0x37) [0x22cd8d7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch::read_page()+0x26) [0x229b226] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch_normal::get(buf_block_t*&)+0x68) [0x229b438] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Buf_fetch::single_page()+0x46) [0x22a32b6] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, Page_fetch, ut::Location, mtr_t*, bool)+0x1c0) [0x22a3e60] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x220d1e2] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(trx_undo_prev_version_build(unsigned char const*, mtr_t*, unsigned char const*, dict_index_t const*, unsigned long*, mem_block_info_t*, unsigned char**, mem_block_info_t*, dtuple_t const**, unsigned long, lob::undo_vers_t*)+0x256) [0x220d646] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_vers_build_for_consistent_read(unsigned char const*, mtr_t*, dict_index_t*, unsigned long**, ReadView*, mem_block_info_t**, mem_block_info_t*, unsigned char**, dtuple_t const**, lob::undo_vers_t*)+0x22a) [0x21c901a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x39c7) [0x21b55d7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function)+0x301) [0x2063a81] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)+0x399) [0x113d7a9] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::read_range_first(key_range const*, key_range const*, bool, bool)+0x5f) [0x113e06f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::read_range_first(key_range const*, key_range const*, bool, bool)+0x28) [0x2041ab8] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::multi_range_read_next(char**)+0x14d) [0x113e61d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_multi_range_read_next(char**)+0x28) [0x113ae78] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(IndexRangeScanIterator::Read()+0x47) [0x133fda7] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(FilterIterator::Read()+0x14) [0x13d9e64] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0x3c3) [0xfb81f3] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Query_expression::execute(THD*)+0x2c) [0xfb83dc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x2c5) [0xf46e55] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(mysql_execute_command(THD*, bool)+0xab8) [0xee5c18] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xeeaa63] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xe40) [0xeebda0] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(do_command(THD*)+0x103) [0xeede93] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x1026898] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7f070861344b] /lib64/libc.so.6(clone+0x3f) [0x7f070687840f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f066001efe0): SELECT c FROM sbtest1 WHERE id BETWEEN 24514 AND 24613 Connection ID (thread ID): 13 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2022-07-20T22:45:08.595854Z mysqld_safe Number of processes running now: 0 2022-07-20T22:45:08.599302Z mysqld_safe mysqld restarted 2022-07-20T22:45:08.880350Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 29212 2022-07-20T22:45:08.887912Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:45:10.344048Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-07-20T22:45:10.456860Z 4 [System] [MY-013381] [Server] Server upgrade from '80029' to '80029' started. 2022-07-20T22:45:15.716826Z 4 [System] [MY-013381] [Server] Server upgrade from '80029' to '80029' completed. 2022-07-20T22:45:15.769368Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2022-07-20T22:45:15.781515Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2022-07-20T22:45:15.871827Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-07-20T22:45:15.871860Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-07-20T22:45:15.889093Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 18030, socket: /tmp/mysqlx-18030.sock 2022-07-20T22:45:15.889118Z 0 [System] [MY-010931] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld: ready for connections. Version: '8.0.29' socket: '/tmp/mysql_sandbox8029.sock' port: 8029 MySQL Community Server - GPL.