Replica crashed with MY-012869,MY-013183
General
Escalation
General
Escalation
Description
Environment
PROD
Activity
Show:
Aaditya Dubey September 7, 2024 at 12:36 PM
Hi @Hussain
We still haven't heard any news from you. So, I assume the issue no longer persists and will close the ticket. If you disagree, reply and create a follow-up with a new Jira report.
Aaditya Dubey January 15, 2024 at 6:15 AM
Hi @Hussain
Thank you for the report.
Please share the test case which can be helpful to repeat this behaviour. Generally just looking at the stack is sometime hard to debug the issue.
Incomplete
Details
Details
Assignee
Unassigned
UnassignedReporter
Hussain
HussainLabels
Needs Review
Yes
Needs QA
No
Components
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created December 20, 2023 at 3:32 PM
Updated September 7, 2024 at 12:36 PM
Resolved September 7, 2024 at 12:36 PM
2023-12-19T21:09:39.578419Z 698457 [ERROR] [MY-012869] [InnoDB] Record in index
index_views_on_transform_id_and_version
of tableacappella_db
.views
was not found 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 tableacappella_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: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
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