commit ddd7d5d8e34c3edd7ebf4790eec2c4e4d9141e94

Author: Marko Mäkelä

Date:   Thu Dec 12 18:02:00 2024 +0200

    MDEV-24035 Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0 causing disruption and replication failure

--source include/have_binlog_format_statement.inc

--source include/have_innodb.inc

call mtr.add_suppression("Unsafe statement written to the binary log using statement");

INSTALL SONAME 'ha_oqgraph';

SET innodb_snapshot_isolation= ON;

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';

INSERT INTO oq_backing (origid, destid) VALUES (170, 241);

XA START 'x';

SELECT * FROM oq_backing;

--connect (con2,localhost,root,,)

INSERT INTO oq_backing (origid, destid) VALUES (23632, 49079);

--connection default

INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq;

# Cleanup

XA END 'x';

XA ROLLBACK 'x';

DROP TABLE oq, oq_backing;

UNINSTALL SONAME 'ha_oqgraph';

mysqltest: At line 17: query 'INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq' failed: ER_ERROR_DURING_COMMIT (1180): Got error 168 "Unknown (generic) error from engine" during COMMIT

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

250216 22:57:45 [ERROR] /share8t/bld/10.11-asan/sql/mariadbd got signal 6 ;

#9  0x00007f6fffe53eb2 in __GI___assert_fail (assertion=0x564afa466960 "\"invalid state\" == 0", file=0x564afa460600 "/data/bld/10.11-asan/storage/innobase/handler/ha_innodb.cc", line=17213, function=0x564afa4773a0 "int innobase_xa_prepare(handlerton*, THD*, bool)") at ./assert/assert.c:101

#10 0x0000564af8a8463a in innobase_xa_prepare (thd=0x62c000200218, prepare_trx=false) at /data/bld/10.11-asan/storage/innobase/handler/ha_innodb.cc:17213

#11 0x0000564af803878a in prepare_or_error (ht=0x615000002398, thd=0x62c000200218, all=false) at /data/bld/10.11-asan/sql/handler.cc:1450

#12 0x0000564af803aad9 in ha_commit_trans (thd=0x62c000200218, all=false) at /data/bld/10.11-asan/sql/handler.cc:1927

#13 0x0000564af7c34fb6 in trans_commit_stmt (thd=0x62c000200218) at /data/bld/10.11-asan/sql/transaction.cc:501

#14 0x0000564af7743738 in mysql_execute_command (thd=0x62c000200218, is_called_from_prepared_stmt=false) at /data/bld/10.11-asan/sql/sql_parse.cc:6225

#15 0x0000564af774fdb2 in mysql_parse (thd=0x62c000200218, rawbuf=0x62d0000b4438 "INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq", length=76, parser_state=0x7f6fefce2a80) at /data/bld/10.11-asan/sql/sql_parse.cc:8188

#16 0x0000564af77253ea in dispatch_command (command=COM_QUERY, thd=0x62c000200218, packet=0x629000276219 "INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq", packet_length=76, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1905

#17 0x0000564af7722117 in do_command (thd=0x62c000200218, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1418

#18 0x0000564af7bed569 in do_handle_one_connection (connect=0x60800001d738, put_in_cache=true) at /data/bld/10.11-asan/sql/sql_connect.cc:1386

#19 0x0000564af7bed0c8 in handle_one_connection (arg=0x60800001d6b8) at /data/bld/10.11-asan/sql/sql_connect.cc:1298

#20 0x0000564af881c430 in pfs_spawn_thread (arg=0x617000008598) at /data/bld/10.11-asan/storage/perfschema/pfs.cc:2201

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

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