Multiple runs can produce multiple different stacks depending on operartions, workload, instant DDLs, schema etc etc repro err log 1: Add instant col to middle of table /home/ec2-user/sandboxes/msb_8_0_29/use -e "select * from information_schema.innodb_tables where INSTANT_COLS>0;" /home/ec2-user/sandboxes/msb_8_0_29/use -e "alter table sysbench_2.sbtest1 add column pad_4 varchar(60) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci DEFAULT NULL, ALGORITHM=instant;" /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 k, ALGORITHM=instant;" [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415369041664 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415373268736 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415367984896 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415102523136 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415100409600 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415370098432 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415101466368 InnoDB: If you get repeated assertion failures or crashes, even [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0dblwr.cc:1031:ib::fatal triggered thread 140335128278784 InnoDB: If you get repeated assertion failures or crashes, even Full log: [ec2-user@ip-10-0-3-185 msb_8_0_29]$ tail -F data/msandbox.err 2022-07-20T22:12:05.731801Z mysqld_safe Starting mysqld daemon with databases from /home/ec2-user/sandboxes/msb_8_0_29/data 2022-07-20T22:12:06.007728Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 12712 2022-07-20T22:12:06.015163Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:12:06.231934Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-07-20T22:12:08.248060Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80029' started. 2022-07-20T22:12:12.536663Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80029' completed. 2022-07-20T22:12:12.722294Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-07-20T22:12:12.722324Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-07-20T22:12:12.737257Z 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:12:12.737277Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 18029, socket: /tmp/mysqlx-18029.sock 2022-07-20T22:12:57.867120Z 28 [ERROR] [MY-011855] [InnoDB] Page old data size 15391 new data size 6942, page old max ins size 809 new max ins size 9258 2022-07-20T22:12:57.867146Z 28 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.867157Z 28 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415369041664 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb494000e80 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:12:57.868663Z 24 [ERROR] [MY-011855] [InnoDB] Page old data size 15391 new data size 6942, page old max ins size 809 new max ins size 9258 2022-07-20T22:12:57.868687Z 24 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.868698Z 24 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415373268736 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. 2022-07-20T22:12:57.868893Z 26 [ERROR] [MY-011855] [InnoDB] Page old data size 15418 new data size 6882, page old max ins size 782 new max ins size 9318 2022-07-20T22:12:57.868912Z 26 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.868927Z 26 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415367984896 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. stack_bottom = 7fb500314d60 thread_stack 0x100000 2022-07-20T22:12:57.873427Z 31 [ERROR] [MY-011855] [InnoDB] Page old data size 15391 new data size 6942, page old max ins size 809 new max ins size 9258 2022-07-20T22:12:57.873449Z 31 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.873460Z 31 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415102523136 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. 2022-07-20T22:12:57.875051Z 25 [ERROR] [MY-011855] [InnoDB] Page old data size 15391 new data size 6942, page old max ins size 809 new max ins size 9258 2022-07-20T22:12:57.875070Z 25 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.875081Z 25 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415100409600 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. 2022-07-20T22:12:57.881378Z 32 [ERROR] [MY-011855] [InnoDB] Page old data size 15418 new data size 6882, page old max ins size 782 new max ins size 9318 2022-07-20T22:12:57.881400Z 32 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.881411Z 32 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415370098432 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. 2022-07-20T22:12:57.884612Z 27 [ERROR] [MY-011855] [InnoDB] Page old data size 15391 new data size 6942, page old max ins size 809 new max ins size 9258 2022-07-20T22:12:57.884634Z 27 [ERROR] [MY-011856] [InnoDB] Submit a detailed bug report to http://bugs.mysql.com 2022-07-20T22:12:57.884644Z 27 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:3654:rec thread 140415101466368 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() [0x21bb36a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21bf1a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_upd_step(que_thr_t*)+0xc1c) [0x21c16cc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180941] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_update_for_mysql(unsigned char const*, row_prebuilt_t*)+0x30) [0x2182c40] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::update_row(unsigned char const*, unsigned char*)+0x2a2) [0x2077c72] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_update_row(unsigned char const*, unsigned char*)+0x1eb) [0x113d05b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::update_single_table(THD*)+0x2e2d) [0xfc488d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xb5) [0xfc5185] /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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4940a5140): UPDATE sbtest1 SET c='66653370850-13648981758-45088036319-58659150883-30979329100-64005600601-70753959620-03896653203-19282769831-81882576947' WHERE id=256 Connection ID (thread ID): 28 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb488000e80 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 = 7fb500212d60 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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4880a7980): INSERT INTO sbtest1 (id, k, c, pad) VALUES (19751, 9865, '82591862223-12532509383-29375965519-17841529450-72419291543-88464759249-58211883115-33267514220-45897972353-39590816934', '35183306666-30780515392-56134758595-86641677025-82509302448') 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. 22:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb4a4000e80 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 = 7fb50071cd60 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() [0x21bb36a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21bf1a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_upd_step(que_thr_t*)+0xc1c) [0x21c16cc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180941] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_update_for_mysql(unsigned char const*, row_prebuilt_t*)+0x30) [0x2182c40] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::update_row(unsigned char const*, unsigned char*)+0x2a2) [0x2077c72] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_update_row(unsigned char const*, unsigned char*)+0x1eb) [0x113d05b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::update_single_table(THD*)+0x2e2d) [0xfc488d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xb5) [0xfc5185] /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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4a42de8e0): UPDATE sbtest1 SET c='27960652264-37087589034-18934282970-90668332900-42930253745-17644954850-91721261051-16157748851-66430041462-45774732095' WHERE id=11245 Connection ID (thread ID): 24 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb480000e80 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 = 7fb4f04e8d60 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() [0x21bb36a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21bf1a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_upd_step(que_thr_t*)+0xc1c) [0x21c16cc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180941] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_update_for_mysql(unsigned char const*, row_prebuilt_t*)+0x30) [0x2182c40] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::update_row(unsigned char const*, unsigned char*)+0x2a2) [0x2077c72] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_update_row(unsigned char const*, unsigned char*)+0x1eb) [0x113d05b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::update_single_table(THD*)+0x2e2d) [0xfc488d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xb5) [0xfc5185] /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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4800a7980): UPDATE sbtest1 SET c='15156797815-59057781618-68938051804-09110293562-42020819361-84175450377-41926583386-51949209560-76780467098-75491073268' WHERE id=1147 Connection ID (thread ID): 31 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb478000e80 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 = 7fb4f02e4d60 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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4780a7b10): INSERT INTO sbtest1 (id, k, c, pad) VALUES (14328, 11205, '65289274753-36192671107-06430695827-26052264810-14612946352-67548247646-90817595786-70863103359-24991050705-49959039728', '98704285331-41154849290-66183916722-70353807658-10263992728') Connection ID (thread ID): 25 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb490000e80 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 = 7fb500416d60 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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4900a7980): INSERT INTO sbtest1 (id, k, c, pad) VALUES (17023, 20463, '94012434431-78967149024-17177081772-81621086322-68161768036-95617249453-59476841638-71729154645-05111770205-20151777332', '05205478971-85058363643-12964993884-33766277102-08675418245') Connection ID (thread ID): 32 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:12:57 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fb484000e80 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 = 7fb4f03e6d60 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() [0x21bb36a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x21bf1a1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_upd_step(que_thr_t*)+0xc1c) [0x21c16cc] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2180941] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(row_update_for_mysql(unsigned char const*, row_prebuilt_t*)+0x30) [0x2182c40] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(ha_innobase::update_row(unsigned char const*, unsigned char*)+0x2a2) [0x2077c72] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(handler::ha_update_row(unsigned char const*, unsigned char*)+0x1eb) [0x113d05b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::update_single_table(THD*)+0x2e2d) [0xfc488d] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xb5) [0xfc5185] /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) [0x7fb53123d44b] /lib64/libc.so.6(clone+0x3f) [0x7fb52f4a240f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb4840aab50): UPDATE sbtest1 SET c='39320225114-77182821239-20477099694-26830495270-56289191414-80023569035-04576748446-31689902381-97707836793-84403453983' WHERE id=13933 Connection ID (thread ID): 27 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:12:58.091204Z mysqld_safe Number of processes running now: 0 2022-07-20T22:12:58.094700Z mysqld_safe mysqld restarted 2022-07-20T22:12:58.379339Z 0 [System] [MY-010116] [Server] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 13133 2022-07-20T22:12:58.386815Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-20T22:12:59.104360Z 1 [ERROR] [MY-012711] [InnoDB] Wrong owned count 4, 1, rec 15479 len 16384; hex e5f2e105000000de000000dd000000df . . . PAGE DUMP CONTENTS . . 980009379-31348194868-29869081920-94925877319 13196436909-73413296583-70261265888-26564895920-42999658381 p7 2s0'- + )C& $ "_ { / K g 7 c U o; InnoDB: End of page dump InnoDB: Page may be an index page where index id is 173 2022-07-20T22:12:59.157526Z 1 [ERROR] [MY-011937] [InnoDB] [FATAL] Apparent corruption of an index page [page id: space=12, page number=222] to be written to data file. We intentionally crash the server to prevent corrupt data from ending up in data files. 2022-07-20T22:12:59.157543Z 1 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0dblwr.cc:1031:ib::fatal triggered thread 140335128278784 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:12:59 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x6cbb1c0 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 = 7fa251786cd0 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(ib::fatal::~fatal()+0x98) [0x223e208] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Double_write::croak(buf_block_t const*)+0xa8) [0x22a7198] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Double_write::prepare(buf_page_t const*, void**, unsigned int*)+0x144) [0x22a7474] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(Double_write::enqueue(buf_flush_t, buf_page_t*, file::Block const*)+0x74) [0x22ac0a4] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dblwr::write(buf_flush_t, buf_page_t*, bool)+0x1f5) [0x22ac8c5] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool)+0x22d) [0x22b58ad] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x22b6797] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*)+0x43b) [0x22b6f9b] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_flush_lists(unsigned long, unsigned long, unsigned long*)+0xaf) [0x22b7f4f] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(buf_flush_sync_all_buf_pools()+0x42) [0x22b7fe2] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(srv_start(bool)+0x2f95) [0x21e75f5] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x2056906] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dd::bootstrap::DDSE_dict_init(THD*, dict_init_mode_t, unsigned int)+0x81) [0x1d0c4b1] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld(dd::upgrade_57::do_pre_checks_and_initialize_dd(THD*)+0x18a) [0x1f55d8a] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x10ee0e6] /home/ec2-user/opt/mysql/8.0.29/bin/mysqld() [0x24c068a] /lib64/libpthread.so.0(+0x744b) [0x7fa25fc2b44b] /lib64/libc.so.6(clone+0x3f) [0x7fa25de9040f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 1 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:12:59.234394Z mysqld_safe mysqld from pid file /home/ec2-user/sandboxes/msb_8_0_29/data/mysql_sandbox8029.pid ended