Replica crashed with MY-012869,MY-013183

Replica crashed with below error in error log:

Server Version: 8.0.32-24 Percona Server (GPL), Release 24, Revision e5c6e9d2

2023-12-19T21:09:39.578419Z 698457 [ERROR] [MY-012869] [InnoDB] Record in index index_views_on_transform_id_and_version of table acappella_db.views was not fou
nd on update: TUPLE (info_bits=0, 3 n_cmp=3, fields): {[36]26679886-ed95-4073-a885-e3d365560514(0x32363637393838362d656439352d343037332d613838352d6533643336353536303
53134),[4]Swit(0x53776974),[8] { (0x8000000000007ba5)} at: COMPACT RECORD(info_bits=0, 3 fields): {[24]2667711a-4934-4e83-84f0-3553382db066(0x32363637373131612d
343933342d346538332d383466302d333535333338326462303636),[4] (0x80000003),[8] (0x8000000000000d1e)}
2023-12-19T21:09:39.578485Z 698457 [ERROR] [MY-012869] [InnoDB] Record in index index_views_on_transform_id of table acappella_db.views was not found on update
: TUPLE (info_bits=0, 2 n_cmp=2, fields): {[36]26679886-ed95-4073-a885-e3d365560514(0x32363637393838362d656439352d343037332d613838352d653364333635353630353134),[8]
{ (0x8000000000007ba5)} at: COMPACT RECORD(info_bits=0, 2 fields): {[24]2667711a-4934-4e83-84f0-3553382db066(0x32363637373131612d343933342d346538332d383466302d33
3535333338326462303636),[8] (0x8000000000000d1e)}
2023-12-19T21:09:39.578512Z 698457 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0ins.cc:268:!cursor->index->is_committed() thread 139794205497088
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: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery
InnoDB: about forcing recovery.
2023-12-19T21:09:39Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=371d582c0b5834709278cbc9f37d82c93a582526
Server Version: 8.0.32-24 Percona Server (GPL), Release 24, Revision e5c6e9d2

Thread pointer: 0x7f230800e000
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 = 7f245ff5caf8 thread_stack 0x100000
/home/mysqld/sys/8.0.32_percona/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x2153fed]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(print_fatal_signal(int)+0x39f) [0x11f020f]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(my_server_abort()+0x7e) [0x11f03be]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(my_abort()+0xa) [0x214dfaa]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x31f) [0x24158cf]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(row_ins_sec_index_entry_low(unsigned int, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, u
nsigned long, que_thr_t*, bool)+0x1325) [0x2365e75]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0x16a) [0x2369bba]
/home/mysqld/sys/8.0.32_percona/bin/mysqld() [0x23abe05]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(row_upd_step(que_thr_t*)+0x63d) [0x23acc8d]
/home/mysqld/sys/8.0.32_percona/bin/mysqld() [0x23799d1]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(ha_innobase::update_row(unsigned char const*, unsigned char*)+0x3a0) [0x2260e80]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(handler::ha_update_row(unsigned char const*, unsigned char*)+0x213) [0xd6f393]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(Update_rows_log_event::do_exec_row(Relay_log_info const*)+0xc0) [0x1d9bad0]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(Rows_log_event::do_apply_row(Relay_log_info const*)+0x26) [0x1d7cbd6]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(Rows_log_event::do_index_scan_and_update(Relay_log_info const*)+0x12b) [0x1d9b14b]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(Rows_log_event::do_apply_event(Relay_log_info const*)+0x8b4) [0x1d9f5e4]
/home/mysqld/sys/8.0.32_percona/bin/mysqld(slave_worker_exec_job_group(Slave_worker*, Relay_log_info*)+0x231) [0x1e2e941]
/home/mysqld/sys/8.0.32_percona/bin/mysqld() [0x1e3503b]
/home/mysqld/sys/8.0.32_percona/bin/mysqld() [0x2620705]
/lib64/libpthread.so.0(+0x7ea5) [0x7f24b0acaea5]
/lib64/libc.so.6(clone+0x6d) [0x7f24aee13b2d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 698457
Status: NOT_KILLED

Hello @Hussain_Patel,

At first this looks like a bug.
Can you confirm the table definition?
Is this repeating?
Is there availability of logs that shows us what the thread was doing (Connection ID (thread ID): 698457) by any chance?
I see a couple of bug reports in later versions which might be relevant but you need to see if you can repeat this. Trying a minor version upgrade is not a bad idea.

Thanks,
K

1 Like