Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[ERROR] [MY-013183] [InnoDB] Assertion failure: mtr0mtr.cc:310:ib::fatal triggered thread 140581378340608

Description

Percona Server Debug build crashes with the following assertion:

/mysqld: ready for connections. Version: '
8.0.35-27-debug' socket: '/tmp/mysql.satya.sock' port: 33090 Source distribution.
2024-03-19T15:51:50.279874Z 254 [ERROR] [MY-013779] [InnoDB] [FATAL] Debug_check_no_latching failed, slot->type=1
2024-03-19T15:51:50.280024Z 254 [ERROR] [MY-013183] [InnoDB] Assertion failure: mtr0mtr.cc:310:ib::fatal triggered thread 140581378340608
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

The bug is reproducible with the cnf and the script provided in PS-9107

Environment

None

Activity

Show:

Satya Bodapati March 19, 2024 at 4:10 PM

(gdb) bt
#0 0x00007ffff5eb9387 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:55
#1 0x00007ffff5ebaa78 in __GI_abort () at abort.c:90
#2 0x000000000385335f in my_server_abort () at /home/satya.bodapati/percona-server/sql/signal_handler.cc:311
#3 0x00000000049d1cc8 in my_abort () at /home/satya.bodapati/percona-server/mysys/my_init.cc:264
#4 0x0000000004ddc85f in ut_dbg_assertion_failed (expr=0x6e72538 "ib::fatal triggered",
file=0x6db7be8 "/home/satya.bodapati/percona-server/storage/innobase/mtr/mtr0mtr.cc", line=310)
at /home/satya.bodapati/percona-server/storage/innobase/ut/ut0dbg.cc:99
#5 0x0000000004de97e5 in ib::fatal::~fatal (this=0x7ffec1099010, __in_chrg=<optimized out>) at /home/satya.bodapati/percona-server/storage/innobase/ut/ut0ut.cc:522
#6 0x0000000004c00a51 in Debug_check_no_latching::operator() (this=0x7ffec109923f, slot=0x7ffec109c4f8)
at /home/satya.bodapati/percona-server/storage/innobase/mtr/mtr0mtr.cc:310
#7 0x0000000004c01fe7 in Iterate<Debug_check_no_latching>::operator() (this=0x7ffec1099230, block=0x7ffec109c4d8)
at /home/satya.bodapati/percona-server/storage/innobase/mtr/mtr0mtr.cc:84
#8 0x0000000004c014f5 in dyn_buf_t<512ul>::for_each_block_in_reverse<Iterate<Debug_check_no_latching> > (this=0x7ffec109c4a8, functor=...)
at /home/satya.bodapati/percona-server/storage/innobase/include/dyn0buf.h:313
#9 0x0000000004bfd824 in mtr_t::check_is_not_latching (this=0x7ffec109c4a0) at /home/satya.bodapati/percona-server/storage/innobase/mtr/mtr0mtr.cc:700
#10 0x0000000004b7f9f8 in mtr_t::check_my_thread_mtrs_are_not_latching () at /home/satya.bodapati/percona-server/storage/innobase/include/mtr0mtr.h:641
#11 0x0000000004b7e121 in log_free_check_validate () at /home/satya.bodapati/percona-server/storage/innobase/log/log0chkp.cc:1301
#12 0x0000000004b1b156 in log_free_check (log=...) at /home/satya.bodapati/percona-server/storage/innobase/include/log0chkp.h:260
#13 0x0000000004b1b1c7 in log_free_check () at /home/satya.bodapati/percona-server/storage/innobase/include/log0chkp.h:312
#14 0x0000000004b121cd in ibuf_merge_pages (n_pages=0x7ffec1099b28, sync=false) at /home/satya.bodapati/percona-server/storage/innobase/ibuf/ibuf0ibuf.cc:2251
#15 0x0000000004b129c7 in ibuf_contract (sync=false) at /home/satya.bodapati/percona-server/storage/innobase/ibuf/ibuf0ibuf.cc:2389
#16 0x0000000004b12be6 in ibuf_contract_after_insert (entry_size=115) at /home/satya.bodapati/percona-server/storage/innobase/ibuf/ibuf0ibuf.cc:2477
#17 0x0000000004b14c25 in ibuf_insert_low (mode=32801, op=IBUF_OP_INSERT, no_counter=false, entry=0x7ffdf00a2998, entry_size=115, index=0x7ffd40007b88, page_id=...,
page_size=..., thr=0x7ffdf004ccc8) at /home/satya.bodapati/percona-server/storage/innobase/ibuf/ibuf0ibuf.cc:3262
#18 0x0000000004b150f5 in ibuf_insert (op=IBUF_OP_INSERT, entry=0x7ffdf00a2998, index=0x7ffd40007b88, page_id=..., page_size=..., thr=0x7ffdf004ccc8)
at /home/satya.bodapati/percona-server/storage/innobase/ibuf/ibuf0ibuf.cc:3393
#19 0x0000000004e581ec in btr_cur_search_to_nth_level (index=0x7ffd40007b88, level=0, tuple=0x7ffdf00a2998, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7ffec109c9a0,
has_search_latch=0, file=0x6def440 "/home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc", line=2918, mtr=0x7ffec109c4a0)
at /home/satya.bodapati/percona-server/storage/innobase/btr/btr0cur.cc:1007
#20 0x0000000004c8ee69 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7ffd40007b88, offsets_heap=0x7ffdf0077e80, heap=0x7ffdf0078350,
entry=0x7ffdf00a2998, trx_id=0, thr=0x7ffdf004ccc8, dup_chk_only=false) at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:2917
#21 0x0000000004c8fce1 in row_ins_sec_index_entry (index=0x7ffd40007b88, entry=0x7ffdf00a2998, thr=0x7ffdf004ccc8, dup_chk_only=false)
at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:3228
#22 0x0000000004c900fd in row_ins_index_entry (index=0x7ffd40007b88, entry=0x7ffdf00a2998, multi_val_pos=@0x7ffdf00a1310: 0, thr=0x7ffdf004ccc8)
at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:3328
#23 0x0000000004c906df in row_ins_index_entry_step (node=0x7ffdf00a1258, thr=0x7ffdf004ccc8)
at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:3460
#24 0x0000000004c90a61 in row_ins (node=0x7ffdf00a1258, thr=0x7ffdf004ccc8) at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:3578
#25 0x0000000004c90f09 in row_ins_step (thr=0x7ffdf004ccc8) at /home/satya.bodapati/percona-server/storage/innobase/row/row0ins.cc:3702
#26 0x0000000004c9d993 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdf00a68a0 "\370\333\002", prebuilt=0x7ffdf00a0778)
at /home/satya.bodapati/percona-server/storage/innobase/row/row0mysql.cc:2056
#27 0x0000000004c9e001 in row_insert_for_mysql (mysql_rec=0x7ffdf00a68a0 "\370\333\002", prebuilt=0x7ffdf00a0778)
at /home/satya.bodapati/percona-server/storage/innobase/row/row0mysql.cc:2204
#28 0x0000000004a49e1a in ha_innobase::write_row (this=0x7ffdf0028750, record=0x7ffdf00a68a0 "\370\333\002")
at /home/satya.bodapati/percona-server/storage/innobase/handler/ha_innodb.cc:9631
#29 0x0000000003189087 in handler::ha_write_row (this=0x7ffdf0028750, buf=0x7ffdf00a68a0 "\370\333\002") at /home/satya.bodapati/percona-server/sql/handler.cc:8332
#30 0x00000000035a66b9 in write_record (thd=0xb25edf0, table=0x7ffdf0015f60, info=0x7ffec109de20, update=0x7ffec109dda0)
at /home/satya.bodapati/percona-server/sql/sql_insert.cc:2168
#31 0x00000000035a217c in Sql_cmd_insert_values::execute_inner (this=0x7ffdf8067818, thd=0xb25edf0) at /home/satya.bodapati/percona-server/sql/sql_insert.cc:631
#32 0x000000000368e30d in Sql_cmd_dml::execute (this=0x7ffdf8067818, thd=0xb25edf0) at /home/satya.bodapati/percona-server/sql/sql_select.cc:793
#33 0x0000000003607250 in mysql_execute_command (thd=0xb25edf0, first_level=true) at /home/satya.bodapati/percona-server/sql/sql_parse.cc:3856
#34 0x000000000360cdfe in dispatch_sql_command (thd=0xb25edf0, parser_state=0x7ffec109f6e0, update_userstat=false)
at /home/satya.bodapati/percona-server/sql/sql_parse.cc:5635
#35 0x00000000036021ac in dispatch_command (thd=0xb25edf0, com_data=0x7ffec10a08f0, command=COM_QUERY) at /home/satya.bodapati/percona-server/sql/sql_parse.cc:2147
#36 0x00000000035fffc5 in do_command (thd=0xb25edf0) at /home/satya.bodapati/percona-server/sql/sql_parse.cc:1501
#37 0x00000000037c64b5 in threadpool_process_request (thd=0xb25edf0) at /home/satya.bodapati/percona-server/sql/threadpool_common.cc:232
#38 0x00000000037ea5eb in handle_event (connection=0xaf67610) at /home/satya.bodapati/percona-server/sql/threadpool_unix.cc:1409
#39 0x00000000037ea7af in worker_main (param=0x8579e80 <all_groups+23552>) at /home/satya.bodapati/percona-server/sql/threadpool_unix.cc:1453
#40 0x00000000051a1e60 in pfs_spawn_thread (arg=0x7ffdf8006b50) at /home/satya.bodapati/percona-server/storage/perfschema/pfs.cc:3043
#41 0x00007ffff7bc6ea5 in start_thread (arg=0x7ffec10a1700) at pthread_create.c:307
#42 0x00007ffff5f819fd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Details

Assignee

Reporter

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created March 19, 2024 at 3:54 PM
Updated March 19, 2024 at 4:11 PM
Configure