Assertion `entry' failed in Active_tranx::assert_thd_is_waiter

--source include/have_log_bin.inc

call mtr.add_suppression("Timeout waiting for reply of binlog");

set @semisync.save= @@rpl_semi_sync_master_enabled;

CREATE TABLE t (a INT);

START TRANSACTION;

SET GLOBAL RPL_SEMI_SYNC_MASTER_ENABLED= 1;

INSERT INTO t VALUES (NULL);

SET GLOBAL RPL_SEMI_SYNC_MASTER_ENABLED= 0;

SET GLOBAL RPL_SEMI_SYNC_MASTER_ENABLED= 1;

COMMIT;

# Cleanup

DROP TABLE t;

SET GLOBAL RPL_SEMI_SYNC_MASTER_ENABLED= @semisync.save;

mariadbd: /data/bld/10.6-asan/sql/semisync_master.cc:382: void Active_tranx::assert_thd_is_waiter(THD*, const char*, my_off_t): Assertion `entry' failed.

240508 23:22:46 [ERROR] mysqld got signal 6 ;

Sorry, we probably made a mistake, and this is a bug.

#9  0x00007faee3a53e32 in __GI___assert_fail (assertion=0x55949d484900 "entry", file=0x55949d484220 "/data/bld/10.6-asan/sql/semisync_master.cc", line=382, function=0x55949d484880 "void Active_tranx::assert_thd_is_waiter(THD*, const char*, my_off_t)") at ./assert/assert.c:101

#10 0x000055949b63849c in Active_tranx::assert_thd_is_waiter (this=0x60800000ada0, thd_to_check=0x62b00008c218, log_file_name=0x6160006a98a0 "master-bin.000001", log_file_pos=1002) at /data/bld/10.6-asan/sql/semisync_master.cc:382

#11 0x000055949b63b753 in Repl_semi_sync_master::commit_trx (this=0x55949f687d60 <repl_semisync_master>, trx_wait_binlog_name=0x6160006a98a0 "master-bin.000001", trx_wait_binlog_pos=1002) at /data/bld/10.6-asan/sql/semisync_master.cc:969

#12 0x000055949b63a880 in Repl_semi_sync_master::wait_after_commit (this=0x55949f687d60 <repl_semisync_master>, thd=0x62b00008c218, all=true) at /data/bld/10.6-asan/sql/semisync_master.cc:770

#13 0x000055949b8c6288 in ha_commit_trans (thd=0x62b00008c218, all=true) at /data/bld/10.6-asan/sql/handler.cc:1988

#14 0x000055949b4e6c0c in trans_commit (thd=0x62b00008c218) at /data/bld/10.6-asan/sql/transaction.cc:270

#15 0x000055949b044187 in mysql_execute_command (thd=0x62b00008c218, is_called_from_prepared_stmt=false) at /data/bld/10.6-asan/sql/sql_parse.cc:5746

#16 0x000055949b053f04 in mysql_parse (thd=0x62b00008c218, rawbuf=0x62b000093238 "COMMIT", length=6, parser_state=0x7faed99fe9f0) at /data/bld/10.6-asan/sql/sql_parse.cc:8146

#17 0x000055949b0292ba in dispatch_command (command=COM_QUERY, thd=0x62b00008c218, packet=0x62900023f219 "COMMIT", packet_length=6, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1896

#18 0x000055949b025fee in do_command (thd=0x62b00008c218, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1409

#19 0x000055949b4a05b6 in do_handle_one_connection (connect=0x608000002eb8, put_in_cache=true) at /data/bld/10.6-asan/sql/sql_connect.cc:1415

#20 0x000055949b49ff77 in handle_one_connection (arg=0x608000002e38) at /data/bld/10.6-asan/sql/sql_connect.cc:1317

#21 0x000055949c10f856 in pfs_spawn_thread (arg=0x617000006298) at /data/bld/10.6-asan/storage/perfschema/pfs.cc:2201

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

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

commit 75c7c6dc39a1b622b876199aca8242bd23720844

Commit:     Brandon Nesterenko

CommitDate: Thu Mar 21 08:42:18 2024 -0600

    MDEV-33551: Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency