Assertion `"invalid state" == 0' failure or error 168 "Unknown (generic) error from engine"

--source include/have_log_bin.inc

--source include/have_innodb.inc

call mtr.add_suppression(".*This transaction was rolled back and cannot be committed.*");

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b INT, KEY(a DESC)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1,7,2014),(2,4,1922),(3,9,1944),

  (4,7,1941),(5,7,1918),(6,6,1976),(7,1,1939),(8,5,1963);

CREATE TABLE t2 (c INT) ENGINE=InnoDB;

CREATE TABLE t3 (d INT) ENGINE=InnoDB;

INSERT INTO t3 VALUES (1),(2),(3),(4),(5),(6);

--connect (con1,localhost,root,,)

--send

  DELETE IGNORE FROM t1_1.*, t2.* USING t1 AS t1_1 LEFT JOIN t2 ON (t1_1.b = t2.c) LEFT JOIN t1 AS t1_2 ON (t1_1.a = t1_2.a);

--connection default

START TRANSACTION;

DELETE FROM t3;

--error 0,ER_LOCK_DEADLOCK

DELETE FROM t1_2.* USING t1 AS t1_1 LEFT JOIN t1 AS t1_2 ON (t1_1.a = t1_2.a);

ROLLBACK;

--connection con1

--error 0,ER_LOCK_DEADLOCK,ER_ROLLBACK_ONLY

--reap

--disconnect con1

--connection default

DROP TABLE t1, t2, t3;

mariadbd: /data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc:17189: int innobase_xa_prepare(THD*, bool): Assertion `"invalid state" == 0' failed.

250727 20:05:00 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007f9101653eb2 in __GI___assert_fail (assertion=0x55cc3e2eb440 "\"invalid state\" == 0", file=0x55cc3e2d8880 "/data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc", line=17189, function=0x55cc3e2f4ec0 "int innobase_xa_prepare(THD*, bool)") at ./assert/assert.c:101

#11 0x000055cc3c957521 in innobase_xa_prepare (thd=0x62c000240218, prepare_trx=true) at /data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc:17189

#12 0x000055cc3b5e7e2b in prepare_or_error (ht=ht@entry=0x615000002398, thd=thd@entry=0x62c000240218, all=all@entry=false) at /data/bld/11.8-asan-ubsan/sql/handler.cc:1506

#13 0x000055cc3b652230 in ha_commit_trans (thd=thd@entry=0x62c000240218, all=all@entry=false) at /data/bld/11.8-asan-ubsan/sql/handler.cc:2008

#14 0x000055cc3ab164b9 in trans_commit_stmt (thd=thd@entry=0x62c000240218) at /data/bld/11.8-asan-ubsan/sql/transaction.cc:496

#15 0x000055cc3a239959 in mysql_execute_command (thd=thd@entry=0x62c000240218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:5970

#16 0x000055cc3a23d089 in mysql_parse (thd=thd@entry=0x62c000240218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f90ee0aaa20) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7906

#17 0x000055cc3a24639f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c000240218, packet=packet@entry=0x6290005c3219 "DELETE IGNORE FROM t1_1.*, t2.* USING t1 AS t1_1 LEFT JOIN t2 ON (t1_1.b = t2.c) LEFT JOIN t1 AS t1_2 ON (t1_1.a = t1_2.a)", packet_length=packet_length@entry=122, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1902

#18 0x000055cc3a2532ad in do_command (thd=thd@entry=0x62c000240218, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1415

#19 0x000055cc3aa95364 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x60800000d138, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1415

#20 0x000055cc3aa964cd in handle_one_connection (arg=0x60800000d138) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327

#21 0x000055cc3c52914c in pfs_spawn_thread (arg=0x617000008c98) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198

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

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

CURRENT_TEST: bug.r18

mysqltest: At line 26: query 'reap' failed with wrong errno ER_GET_ERRNO (1030): 'Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB', instead of  (0)...