[MDEV-31784] [draft]Assertion `index->table->is_instant()' failed in btr_cur_upd_rec_in_place Created: 2023-07-27  Updated: 2023-08-01

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 11.1
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alice Sherepa
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-22714 Assertion `index->table->is_instant()... Closed
relates to MDEV-23801 Assertion `index->table->instant' fai... Closed

 Description   

mysqld: /11.1/storage/innobase/btr/btr0cur.cc:2907: void btr_cur_upd_rec_in_place(rec_t*, const dict_index_t*, const rec_offs*, const upd_t*, buf_block_t*, mtr_t*): Assertion `index->table->is_instant()' failed.
 
230727 13:41:28 [ERROR] mysqld got signal 6 ;
 
Server version: 11.1.2-MariaDB-debug-log source revision: c6ac1e39b694568c459bf03e9894b230302f4bfb
 
linux/raise.c:51(__GI_raise)[0x7f5d6f4868eb]
stdlib/abort.c:81(__GI_abort)[0x7f5d6f471535]
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f5d6f47140f]
/lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f5d6f47f1a2]
btr/btr0cur.cc:2908(btr_cur_upd_rec_in_place(unsigned char*, dict_index_t const*, unsigned short const*, upd_t const*, buf_block_t*, mtr_t*))[0x55f1e58385e1]
btr/btr0cur.cc:3163(btr_cur_update_in_place(unsigned long, btr_cur_t*, unsigned short*, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*))[0x55f1e583ab82]
btr/btr0cur.cc:3392(btr_cur_optimistic_update(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*))[0x55f1e583d821]
row/row0upd.cc:2353(row_upd_clust_rec(unsigned long, upd_node_t*, dict_index_t*, unsigned short*, mem_block_info_t**, que_thr_t*, mtr_t*))[0x55f1e5702efa]
row/row0upd.cc:2672(row_upd_clust_step(upd_node_t*, que_thr_t*))[0x55f1e5704b30]
row/row0upd.cc:2735(row_upd(upd_node_t*, que_thr_t*))[0x55f1e5705341]
row/row0upd.cc:2877(row_upd_step(que_thr_t*))[0x55f1e570622e]
row/row0mysql.cc:1998(row_update_cascade_for_mysql(que_thr_t*, upd_node_t*, dict_table_t*))[0x55f1e565be8f]
row/row0ins.cc:1350(row_ins_foreign_check_on_constraint(que_thr_t*, dict_foreign_t*, btr_pcur_t*, dtuple_t*, mtr_t*))[0x55f1e5601c5f]
row/row0ins.cc:1743(row_ins_check_foreign_constraint(unsigned long, dict_foreign_t*, dict_table_t*, dtuple_t*, que_thr_t*))[0x55f1e56037fb]
row/row0upd.cc:252(row_upd_check_references_constraints(upd_node_t*, btr_pcur_t*, dict_table_t*, dict_index_t*, unsigned short*, que_thr_t*, mtr_t*))[0x55f1e56f5bd0]
row/row0upd.cc:1985(row_upd_sec_index_entry(upd_node_t*, que_thr_t*))[0x55f1e56ffe87]
row/row0upd.cc:2038(row_upd_sec_step(upd_node_t*, que_thr_t*))[0x55f1e57006c7]
row/row0upd.cc:2762(row_upd(upd_node_t*, que_thr_t*))[0x55f1e5705753]
row/row0upd.cc:2877(row_upd_step(que_thr_t*))[0x55f1e570622e]
row/row0mysql.cc:1686(row_update_for_mysql(row_prebuilt_t*))[0x55f1e5659e20]
handler/ha_innodb.cc:8706(ha_innobase::delete_row(unsigned char const*))[0x55f1e52b3234]
sql/handler.cc:7943(handler::ha_delete_row(unsigned char const*))[0x55f1e488e766]
sql/sql_delete.cc:289(TABLE::delete_row())[0x55f1e3e6b25c]
sql/sql_delete.cc:824(Sql_cmd_delete::delete_from_single_table(THD*))[0x55f1e3e5e9bb]
sql/sql_delete.cc:1794(Sql_cmd_delete::execute_inner(THD*))[0x55f1e3e6877f]
sql/sql_select.cc:33356(Sql_cmd_dml::execute(THD*))[0x55f1e4130d9b]
sql/sql_parse.cc:4393(mysql_execute_command(THD*, bool))[0x55f1e3f558d3]
sql/sql_parse.cc:7774(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55f1e3f6ccc4]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55f1e3f45918]
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x55f1e3f4260b]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55f1e43fdf36]
sql/sql_connect.cc:1320(handle_one_connection)[0x55f1e43fd88c]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55f1e50afeab]
nptl/pthread_create.c:487(start_thread)[0x7f5d6f93efa3]
x86_64/clone.S:97(clone)[0x7f5d6f54806f]
 
Query (0x6290016f82a8): DELETE FROM `t9` ORDER BY `col_timestamp` LIMIT 4


Generated at Thu Feb 08 10:26:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.