[MDEV-32648] InnoDB: Failing assertion: old_rec in storage/innobase/btr/btr0pcur.cc line 366 Created: 2023-11-01  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s: 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Thirunarayanan Balathandayuthapani
Resolution: Unresolved Votes: 0
Labels: regression

Issue Links:
Relates
relates to MDEV-515 innodb bulk insert Closed

 Description   

--source include/have_innodb.inc
 
SET unique_checks=0;
SET foreign_key_checks=0;
SET @@pseudo_slave_mode=1;
CREATE TABLE t (a INT,b CHAR,KEY(a)) engine=InnoDB;
XA START '1';
INSERT INTO t VALUES();
XA END '1';
XA PREPARE '1';
HANDLER t OPEN AS t;
HANDLER t READ NEXT;
HANDLER t READ NEXT;

Leads to:

10.6.16 6f091434f313996436b4f01d7e7d62a9f3786958 (Debug)

InnoDB: Failing assertion: old_rec

10.6.16 6f091434f313996436b4f01d7e7d62a9f3786958 (Debug)

Core was generated by `/test/MD311023-mariadb-10.6.16-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'.
Program terminated with signal SIGABRT, Aborted.
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x145b2cafe700 (LWP 1228624))]
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x0000145b35f6f859 in __GI_abort () at abort.c:79
#2  0x000055f9584713df in ut_dbg_assertion_failed (expr=expr@entry=0x55f958aafad4 "old_rec", file=file@entry=0x55f958acceb8 "/test/10.6_dbg/storage/innobase/btr/btr0pcur.cc", line=line@entry=366) at /test/10.6_dbg/storage/innobase/ut/ut0dbg.cc:60
#3  0x000055f9584c3708 in btr_pcur_t::restore_position (this=this@entry=0x145aec02aea8, restore_latch_mode=restore_latch_mode@entry=BTR_SEARCH_LEAF, mtr=mtr@entry=0x145b2cafc740) at /test/10.6_dbg/storage/innobase/btr/btr0pcur.cc:366
#4  0x000055f9583e55f3 in sel_restore_position_for_mysql (same_user_rec=same_user_rec@entry=0x145b2cafc0ab, latch_mode=latch_mode@entry=BTR_SEARCH_LEAF, pcur=pcur@entry=0x145aec02aea8, moves_up=moves_up@entry=true, mtr=mtr@entry=0x145b2cafc740) at /test/10.6_dbg/storage/innobase/row/row0sel.cc:3643
#5  0x000055f9583f1320 in row_search_mvcc (buf=buf@entry=0x145aec01fed8 "\377", mode=PAGE_CUR_G, mode@entry=PAGE_CUR_UNSUPP, prebuilt=0x145aec02acd8, match_mode=match_mode@entry=0, direction=direction@entry=1) at /test/10.6_dbg/storage/innobase/row/row0sel.cc:4734
#6  0x000055f958238a95 in ha_innobase::general_fetch (this=0x145aec02a440, buf=0x145aec01fed8 "\377", direction=direction@entry=1, match_mode=match_mode@entry=0) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9387
#7  0x000055f958238e1a in ha_innobase::rnd_next (this=0x145aec02a440, buf=<optimized out>) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9590
#8  0x000055f957e7a1c7 in handler::ha_rnd_next (this=0x145aec02a440, buf=0x145aec01fed8 "\377") at /test/10.6_dbg/sql/handler.cc:3460
#9  0x000055f957b5447e in mysql_ha_read (thd=thd@entry=0x145aec000d48, tables=tables@entry=0x145aec013488, mode=RNEXT, keyname=0x0, key_expr=<optimized out>, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /test/10.6_dbg/sql/sql_handler.cc:910
#10 0x000055f957ba7653 in mysql_execute_command (thd=thd@entry=0x145aec000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_limit.h:96
#11 0x000055f957b904fe in mysql_parse (thd=thd@entry=0x145aec000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x145b2cafd2c0) at /test/10.6_dbg/sql/sql_parse.cc:8050
#12 0x000055f957b9e492 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145aec000d48, packet=packet@entry=0x145aec00af99 "", packet_length=packet_length@entry=19, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1403
#13 0x000055f957ba0bba in do_command (thd=0x145aec000d48, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1409
#14 0x000055f957cf6e37 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55f95a5d0728, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1416
#15 0x000055f957cf73ec in handle_one_connection (arg=arg@entry=0x55f95a5d0728) at /test/10.6_dbg/sql/sql_connect.cc:1318
#16 0x000055f95816bace in pfs_spawn_thread (arg=0x55f95a5be6d8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
#17 0x0000145b36480609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#18 0x0000145b3606c133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 10.6.16 (dbg), 10.6.16 (opt), 10.9.8 (dbg), 10.9.8 (opt), 10.10.7 (dbg), 10.10.7 (opt), 10.11.6 (dbg),10.11.6 (opt), 11.0.4 (dbg), 11.0.4 (opt), 11.1.3 (dbg), 11.1.3 (opt), 11.2.2 (dbg), 11.2.2 (opt), 11.3.0 (dbg), 11.3.0 (opt)

Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.32 (dbg), 10.4.32 (opt), 10.5.23 (dbg), 10.5.23 (opt)


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