Assertion failures upon using OQGraph table under lock

--source include/have_innodb.inc

INSTALL SONAME 'ha_oqgraph';

CREATE TABLE oq_backing (origid INT UNSIGNED NOT NULL, destid INT UNSIGNED NOT NULL, PRIMARY KEY (origid, destid), KEY (destid)) ENGINE=InnoDB;

CREATE TABLE oq (latch VARCHAR(32) NULL, origid BIGINT UNSIGNED NULL, destid BIGINT UNSIGNED NULL, weight DOUBLE NULL, seq BIGINT UNSIGNED NULL, linkid BIGINT UNSIGNED NULL, KEY (latch, origid, destid) USING HASH, KEY (latch, destid, origid) USING HASH) ENGINE=OQGRAPH data_table='oq_backing' origid='origid' destid='destid';

LOCK TABLE oq WRITE;

SELECT * FROM oq WHERE latch = 0 AND origid = 18265;

UNLOCK TABLES;

# Cleanup

DROP TABLE oq, oq_backing;

UNINSTALL SONAME 'ha_oqgraph';

2023-08-17 14:59:10 0x7f6c6b6ff6c0  InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/trx/trx0trx.cc line 1327

InnoDB: Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0

#7  0x000055e8888faa9c in ut_dbg_assertion_failed (expr=expr@entry=0x55e8894e7900 "UT_LIST_GET_LEN(lock.trx_locks) == 0", file=file@entry=0x55e8894e7278 "/data/src/10.4/storage/innobase/trx/trx0trx.cc", line=line@entry=1327) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60

#8  0x000055e88902517e in trx_t::commit_in_memory (this=<optimized out>, mtr=0x0) at /data/src/10.4/storage/innobase/trx/trx0trx.cc:1327

#9  0x000055e889021e2b in trx_t::commit (this=this@entry=0x7f6c701cd090) at /data/src/10.4/storage/innobase/trx/trx0trx.cc:1549

#10 0x000055e889022033 in trx_commit_for_mysql (trx=trx@entry=0x7f6c701cd090) at /data/src/10.4/storage/innobase/trx/trx0trx.cc:1681

#11 0x000055e888ef0fe8 in innobase_commit_low (trx=0x7f6c701cd090) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:4488

#12 innobase_commit_ordered_2 (trx=0x7f6c701cd090, thd=<optimized out>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:4617

#13 0x000055e888ef2bd3 in innobase_commit (hton=<optimized out>, thd=thd@entry=0x7f6c1c000c58, commit_trx=commit_trx@entry=true) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:4732

#14 0x000055e888f00b99 in ha_innobase::external_lock (this=0x7f6c1c134fd0, thd=0x7f6c1c000c58, lock_type=2) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:15834

#15 0x000055e888c26be9 in handler::ha_external_lock (this=0x7f6c1c134fd0, thd=0x7f6c1c000c58, lock_type=2) at /data/src/10.4/sql/handler.cc:6563

#16 0x000055e888c26d61 in handler::ha_external_lock (this=0x7f6c1c133840, thd=thd@entry=0x7f6c1c000c58, lock_type=lock_type@entry=2) at /data/src/10.4/sql/handler.cc:6563

#17 0x000055e888d1c089 in unlock_external (count=<optimized out>, table=0x7f6c1c1241e8, thd=0x7f6c1c000c58) at /data/src/10.4/sql/lock.cc:713

#18 mysql_unlock_tables (thd=0x7f6c1c000c58, sql_lock=0x7f6c1c1241b8, free_lock=<optimized out>) at /data/src/10.4/sql/lock.cc:434

#19 0x000055e888d1c71e in mysql_unlock_tables (thd=<optimized out>, sql_lock=<optimized out>) at /data/src/10.4/sql/lock.cc:418

#20 0x000055e8889a7f86 in close_thread_tables (thd=thd@entry=0x7f6c1c000c58) at /data/src/10.4/sql/sql_base.cc:1027

#21 0x000055e8889a8cda in Locked_tables_list::unlock_locked_tables (thd=0x7f6c1c000c58, this=0x7f6c1c004820) at /data/src/10.4/sql/sql_base.cc:2491

#22 Locked_tables_list::unlock_locked_tables (this=this@entry=0x7f6c1c004820, thd=thd@entry=0x7f6c1c000c58) at /data/src/10.4/sql/sql_base.cc:2463

#23 0x000055e888a137cf in mysql_execute_command (thd=thd@entry=0x7f6c1c000c58) at /data/src/10.4/sql/sql_parse.cc:5075

#24 0x000055e888a15b31 in mysql_parse (thd=0x7f6c1c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.4/sql/sql_parse.cc:8010

#25 0x000055e888a181ad in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f6c1c000c58, packet=packet@entry=0x7f6c1c007d69 "UNLOCK TABLES", packet_length=packet_length@entry=13, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1958

#26 0x000055e888a1a52f in do_command (thd=0x7f6c1c000c58) at /data/src/10.4/sql/sql_parse.cc:1378

#27 0x000055e888b13dbe in do_handle_one_connection (connect=connect@entry=0x55e88b746fa8) at /data/src/10.4/sql/sql_connect.cc:1420

#28 0x000055e888b13edd in handle_one_connection (arg=arg@entry=0x55e88b746fa8) at /data/src/10.4/sql/sql_connect.cc:1324

#29 0x000055e888ea6ffb in pfs_spawn_thread (arg=0x55e88b46e318) at /data/src/10.4/storage/perfschema/pfs.cc:1869

#30 0x00007f6c765c8fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#31 0x00007f6c766495bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

mysqld: /data/src/10.4/storage/innobase/lock/lock0lock.cc:3573: ib_lock_t* lock_table_create(dict_table_t*, ulint, trx_t*, ib_lock_t*): Assertion `!trx->auto_commit || trx->will_lock' failed.

#9  0x00007fd81c053df2 in __GI___assert_fail (assertion=0x55c758abcaa0 "!trx->auto_commit || trx->will_lock", file=0x55c758abb280 "/data/src/10.4/storage/innobase/lock/lock0lock.cc", line=3573, function=0x55c758abf980 "ib_lock_t* lock_table_create(dict_table_t*, ulint, trx_t*, ib_lock_t*)") at ./assert/assert.c:101

#10 0x000055c7576f4dc5 in lock_table_create (table=0x618000033508, type_mode=1, trx=0x7fd813fc2908, c_lock=0x0) at /data/src/10.4/storage/innobase/lock/lock0lock.cc:3573

#11 0x000055c7576f7c41 in lock_table (flags=0, table=0x618000033508, mode=LOCK_IX, thr=0x62000003d840) at /data/src/10.4/storage/innobase/lock/lock0lock.cc:4003

#12 0x000055c75797934a in row_search_mvcc (buf=0x6190000de3b8 '\276' <repeats 40 times>, mode=PAGE_CUR_G, prebuilt=0x62000003d108, match_mode=0, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:4647

#13 0x000055c75757afff in ha_innobase::index_read (this=0x61d00024cca8, buf=0x6190000de3b8 '\276' <repeats 40 times>, key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9403

#14 0x000055c75757e2e8 in ha_innobase::index_first (this=0x61d00024cca8, buf=0x6190000de3b8 '\276' <repeats 40 times>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9785

#15 0x000055c75757e820 in ha_innobase::rnd_next (this=0x61d00024cca8, buf=0x6190000de3b8 '\276' <repeats 40 times>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9878

#16 0x000055c756bc0b4b in handler::ha_rnd_next (this=0x61d00024cca8, buf=0x6190000de3b8 '\276' <repeats 40 times>) at /data/src/10.4/sql/handler.cc:2905

#17 0x00007fd8071bc0b3 in oqgraph3::cursor::seek_to (this=0x60c000030ac0, origid=..., destid=...) at /data/src/10.4/storage/oqgraph/oqgraph_thunk.cc:509

#18 0x00007fd8071b6395 in oqgraph3::edge_iterator::seek (this=0x7fd8073dcc10) at /data/src/10.4/storage/oqgraph/oqgraph_shim.cc:35

#19 0x00007fd8071b685e in oqgraph3::edge_iterator::operator!= (this=0x7fd8073dcc10, x=...) at /data/src/10.4/storage/oqgraph/oqgraph_shim.cc:71

#20 0x00007fd8071737dc in open_query::edges_cursor::fetch_row (this=0x6060000bc9c0, row_info=..., result=...) at /data/src/10.4/storage/oqgraph/graphcore.cc:1183

#21 0x00007fd807171df7 in open_query::oqgraph::fetch_row (this=0x60800000c920, result=...) at /data/src/10.4/storage/oqgraph/graphcore.cc:1039

#22 0x00007fd807163401 in ha_oqgraph::rnd_next (this=0x62300001c128, buf=0x6190000dcab8 "\377") at /data/src/10.4/storage/oqgraph/ha_oqgraph.cc:1095

#23 0x000055c756bc0a4b in handler::ha_rnd_next (this=0x62300001c128, buf=0x6190000dcab8 "\377") at /data/src/10.4/sql/handler.cc:2905

#24 0x000055c756fe5c74 in rr_sequential (info=0x62b0000a5e88) at /data/src/10.4/sql/records.cc:485

#25 0x000055c75625dd2e in READ_RECORD::read_record (this=0x62b0000a5e88) at /data/src/10.4/sql/records.h:70

#26 0x000055c756558edd in join_init_read_record (tab=0x62b0000a5dc0) at /data/src/10.4/sql/sql_select.cc:21837

#27 0x000055c75655218d in sub_select (join=0x62b0000a3338, join_tab=0x62b0000a5dc0, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20886

#28 0x000055c756550198 in do_select (join=0x62b0000a3338, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:20412

#29 0x000055c7564df027 in JOIN::exec_inner (this=0x62b0000a3338) at /data/src/10.4/sql/sql_select.cc:4605

#30 0x000055c7564dc62e in JOIN::exec (this=0x62b0000a3338) at /data/src/10.4/sql/sql_select.cc:4387

#31 0x000055c7564e06c0 in mysql_select (thd=0x62b00009a208, tables=0x62b0000a1948, wild_num=1, fields=..., conds=0x62b0000a2898, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2149845760, result=0x62b0000a3308, unit=0x62b00009e140, select_lex=0x62b0000a1300) at /data/src/10.4/sql/sql_select.cc:4826

#32 0x000055c7564b12ff in handle_select (thd=0x62b00009a208, lex=0x62b00009e080, result=0x62b0000a3308, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:442

#33 0x000055c756420827 in execute_sqlcom_select (thd=0x62b00009a208, all_tables=0x62b0000a1948) at /data/src/10.4/sql/sql_parse.cc:6473

#34 0x000055c75640dd3c in mysql_execute_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:3976

#35 0x000055c756429a77 in mysql_parse (thd=0x62b00009a208, rawbuf=0x62b0000a1228 "SELECT * FROM oq WHERE latch = 0 AND origid = 18265", length=51, parser_state=0x7fd8073df860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8010

#36 0x000055c7563ffd42 in dispatch_command (command=COM_QUERY, thd=0x62b00009a208, packet=0x62900029e209 "", packet_length=51, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857

#37 0x000055c7563fc8b1 in do_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:1378

#38 0x000055c7567fbe10 in do_handle_one_connection (connect=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1420

#39 0x000055c7567fb727 in handle_one_connection (arg=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1324

#40 0x000055c75746be20 in pfs_spawn_thread (arg=0x615000006208) at /data/src/10.4/storage/perfschema/pfs.cc:1869

#41 0x00007fd81c0a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#42 0x00007fd81c1285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

2023-08-17 15:01:20 0x7f56515546c0  InnoDB: Assertion failure in file /data/src/10.6/storage/innobase/trx/trx0trx.cc line 1252

InnoDB: Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0

mariadbd: /data/src/10.6/storage/innobase/lock/lock0lock.cc:3319: ib_lock_t* lock_table_create(dict_table_t*, unsigned int, trx_t*, ib_lock_t*): Assertion `!trx->is_autocommit_non_locking()' failed.

230817 15:01:58 [ERROR] mysqld got signal 6 ;