mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
066f920484
This is an extension of MDEV-30423 "Deadlock on Replica during BACKUP STAGE BLOCK_COMMIT on XA transactions" The original commit in MDEV-30423 was not complete as some usage in XA of MDL_BACKUP_COMMIT locks did not set thd->backup_commit_lock. This is required to be set when using parallel replication. Fixed by ensuring that all usage of BACKUP_COMMIT lock i XA is uniform and all sets thd->backup_commit_lock. I also changed all locks to be MDL_EXPLICIT to keep also that part uniform. A regression test is added.
64 lines
1.7 KiB
Text
64 lines
1.7 KiB
Text
# Verify deadlock between XA-PREPARE and BACKUP on the optimistic slave
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
--source include/have_innodb.inc
|
|
# The test is not format specific, MIXED is required to optimize testing time
|
|
--source include/have_binlog_format_mixed.inc
|
|
--source include/master-slave.inc
|
|
|
|
--connection master
|
|
CREATE TABLE t (a INT) ENGINE = innodb;
|
|
|
|
--sync_slave_with_master
|
|
--source include/stop_slave.inc
|
|
SET @old_parallel_threads= @@GLOBAL.slave_parallel_threads;
|
|
SET @old_parallel_mode = @@GLOBAL.slave_parallel_mode;
|
|
SET @@global.slave_parallel_threads= 2;
|
|
SET @@global.slave_parallel_mode = 'optimistic';
|
|
|
|
--connection master
|
|
--echo # MDEV-35110
|
|
SET @@gtid_seq_no=100;
|
|
insert into t set a=1;
|
|
xa start 'x';
|
|
insert into t set a=2;
|
|
xa end 'x';
|
|
xa prepare 'x';
|
|
|
|
--connection slave
|
|
SET @@global.debug_dbug="+d,hold_worker_on_schedule";
|
|
start slave;
|
|
--let $wait_condition= SELECT count(*) = 1 FROM information_schema.processlist WHERE state LIKE "Waiting for prior transaction to commit"
|
|
--source include/wait_condition.inc
|
|
|
|
--connection slave1
|
|
backup stage start;
|
|
--send backup stage block_commit
|
|
|
|
--connection slave
|
|
--let $wait_condition= SELECT count(*) = 1 FROM information_schema.processlist WHERE state LIKE "Waiting for backup lock"
|
|
SET debug_sync = 'now SIGNAL continue_worker';
|
|
SET debug_sync = RESET;
|
|
|
|
--connection slave1
|
|
reap;
|
|
backup stage end;
|
|
|
|
--connection master
|
|
xa rollback 'x';
|
|
|
|
--sync_slave_with_master
|
|
|
|
--echo # Clean up.
|
|
--connection slave
|
|
--source include/stop_slave.inc
|
|
SET @@global.debug_dbug="";
|
|
SET @@global.slave_parallel_threads= @old_parallel_threads;
|
|
SET @@global.slave_parallel_mode = @old_parallel_mode;
|
|
|
|
--source include/start_slave.inc
|
|
|
|
--connection server_1
|
|
DROP TABLE t;
|
|
|
|
--source include/rpl_end.inc
|