mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
72a5a4f1d5
Test galera_sr_ddl_master would sometimes fail due to leftover
streaming replication fragments. Rollbacker thread would attempt to
open streaming_log table to remove the fragments, but would fail in
check_stack_overrun(). Ultimately the check_stack_overrun() failure
was caused by rollbacker missing to switch the victim's THD thread
stack to rollbacker's thread stack.
Also in this patch:
- Remove duplicate functionality in rollbacker helper functions,
and extract rollbacker fragment removal into function
wsrep_remove_streaming_fragments()
- Reuse open_for_write() in wsrep_schema::remove_fragments
- Partially revert changes to galera_sr_ddl_master test from
commit 44a11a7c08. Removed unnecessary
wait condition and isolation level setting
67 lines
1.7 KiB
Plaintext
67 lines
1.7 KiB
Plaintext
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
|
|
#
|
|
# Test the following sequence of events on the master:
|
|
#
|
|
# 1. Connection #1 begins a SR transaction
|
|
# 2. Connection #2 issues DDL
|
|
# 3. Connection #1 attempts to continue the transaction, gets deadlock
|
|
# 4. Connection #1 retries the transaction and succeeds
|
|
#
|
|
|
|
--connection node_1
|
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
|
|
|
|
SET SESSION wsrep_trx_fragment_size = 1;
|
|
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (3);
|
|
INSERT INTO t1 VALUES (4);
|
|
INSERT INTO t1 VALUES (5);
|
|
|
|
--connection node_2
|
|
# SR replication is triggered and rows have been delivered to the slave
|
|
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
|
|
--let $wait_condition = SELECT COUNT(*) = 5 FROM t1;
|
|
--source include/wait_condition.inc
|
|
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
|
|
|
|
SELECT COUNT(*) as expect_5 FROM mysql.wsrep_streaming_log;
|
|
|
|
--connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
|
|
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
|
|
|
|
--connection node_1
|
|
--error ER_LOCK_DEADLOCK
|
|
INSERT INTO t1 VALUES (6);
|
|
|
|
SELECT COUNT(*) as expect_0 FROM mysql.wsrep_streaming_log;
|
|
|
|
# Check that the transaction thus aborted could be reissued
|
|
|
|
ROLLBACK;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES (1);
|
|
INSERT INTO t1 (f1) VALUES (2);
|
|
INSERT INTO t1 (f1) VALUES (3);
|
|
INSERT INTO t1 (f1) VALUES (4);
|
|
INSERT INTO t1 (f1) VALUES (5);
|
|
INSERT INTO t1 (f1) VALUES (6);
|
|
COMMIT;
|
|
|
|
SELECT COUNT(*) as expect_6 FROM t1;
|
|
SELECT * FROM t1;
|
|
SELECT COUNT(*) as expect_0 FROM mysql.wsrep_streaming_log;
|
|
|
|
--connection node_2
|
|
SELECT COUNT(*) as expect_6 FROM t1;
|
|
SELECT * FROM t1;
|
|
SELECT COUNT(*) as expect_0 FROM mysql.wsrep_streaming_log;
|
|
|
|
DROP TABLE t1;
|