summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc')
-rw-r--r--mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc62
1 files changed, 0 insertions, 62 deletions
diff --git a/mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc b/mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc
deleted file mode 100644
index eec331b3d64..00000000000
--- a/mysql-test/suite/rpl/include/rpl_parallel_rollback_assert.inc
+++ /dev/null
@@ -1,62 +0,0 @@
---echo *** MDEV-8725: Assertion on ROLLBACK statement in the binary log ***
---source include/have_innodb.inc
---source include/master-slave.inc
-
---connection server_2
-SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
---source include/stop_slave.inc
-SET GLOBAL slave_parallel_threads=10;
-CHANGE MASTER TO master_use_gtid=slave_pos;
---source include/start_slave.inc
-
---connection server_1
-ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
-CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=MyISAM;
-CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
---save_master_pos
-
---connection server_2
---sync_with_master
-
---connection server_1
-# Inject an event group terminated by ROLLBACK, by mixing MyISAM and InnoDB
-# in a transaction. The bug was an assertion on the ROLLBACK due to
-# mark_start_commit() being already called.
---disable_warnings
-BEGIN;
-INSERT INTO t2 VALUES (2000);
-INSERT INTO t1 VALUES (2000);
-INSERT INTO t2 VALUES (2001);
-ROLLBACK;
---enable_warnings
-SELECT * FROM t1 WHERE a>=2000 ORDER BY a;
-SELECT * FROM t2 WHERE a>=2000 ORDER BY a;
---source include/save_master_gtid.inc
-
---connection server_2
---source include/sync_with_master_gtid.inc
-
---connection server_1
-INSERT INTO t2 VALUES (2020);
---source include/save_master_gtid.inc
-
---connection server_2
---source include/sync_with_master_gtid.inc
-SELECT * FROM t2 WHERE a>=2000 ORDER BY a;
-let $rows_in_t1= `SELECT COUNT(*) FROM t1 WHERE a>=2000 ORDER BY a`;
-if ($rows_in_t1 == 0)
-{
---query_vertical SHOW SLAVE STATUS
-}
-SELECT * FROM t1 WHERE a>=2000 ORDER BY a;
-
-# Clean up.
---source include/stop_slave.inc
-SET GLOBAL slave_parallel_threads=@old_parallel_threads;
---source include/start_slave.inc
-
---connection server_1
-DROP TABLE t1,t2;
-
---source include/rpl_end.inc
-