summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniele Sciascia <daniele.sciascia@galeracluster.com>2023-03-16 09:29:10 +0100
committerJulius Goryavsky <julius.goryavsky@mariadb.com>2023-05-11 14:41:43 +0200
commitbc275e86a002b58c3a966474dca554ffbc98badd (patch)
tree1542639c730f26dd993936c69622f528c687ba31
parent28eaf66e18fbb2fc15c20c14f835c7c276c35cb2 (diff)
downloadmariadb-git-bb-10.4-MDEV-30388-galera.tar.gz
MDEV-30473 Remove test galera.MDEV-27713bb-10.4-MDEV-30388-galera
Remove test galera.MDEV-27713. This test relies on GET_LOCK() and has stopped working since commit 844ddb1 (see MDEV-30473). This commit disabled GET_LOCK() in combination with Galera. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
-rw-r--r--mysql-test/suite/galera/r/MDEV-27713.result46
-rw-r--r--mysql-test/suite/galera/t/MDEV-27713.test67
2 files changed, 0 insertions, 113 deletions
diff --git a/mysql-test/suite/galera/r/MDEV-27713.result b/mysql-test/suite/galera/r/MDEV-27713.result
deleted file mode 100644
index 14575cb484d..00000000000
--- a/mysql-test/suite/galera/r/MDEV-27713.result
+++ /dev/null
@@ -1,46 +0,0 @@
-connection node_2;
-connection node_1;
-CREATE TABLE t1 (
-f1 INT,
-f2 VARCHAR(255) PRIMARY KEY
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-INSERT INTO t1 VALUES(1, 'abc');
-connection node_1;
-SET AUTOCOMMIT=OFF;
-START TRANSACTION;
-INSERT INTO t1 VALUES (2,'def');
-connection node_2;
-SET GLOBAL event_scheduler=ON;
-CREATE PROCEDURE update_table()
-BEGIN
-SET AUTOCOMMIT=OFF;
-DO GET_LOCK('local_lock', 0);
-SET DEBUG_SYNC = 'innodb_row_update_for_mysql_begin SIGNAL blocked WAIT_FOR continue';
-UPDATE t1 SET f2 = 'jkl' WHERE f1 != 2;
-DO RELEASE_LOCK('local_lock');
-END|
-CREATE DEFINER=current_user
-EVENT event
-ON SCHEDULE AT CURRENT_TIMESTAMP
-ON COMPLETION PRESERVE
-ENABLE
-DO CALL update_table();
-connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
-SET DEBUG_SYNC = 'now WAIT_FOR blocked';
-connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
-SET GLOBAL debug_dbug = "+d,sync.wsrep_apply_cb";
-connection node_1;
-COMMIT;
-connection node_2b;
-SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
-SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
-connection node_2a;
-SET DEBUG_SYNC = 'now SIGNAL continue';
-connection node_2;
-SET GLOBAL event_scheduler=default;
-DROP PROCEDURE update_table;
-DROP EVENT event;
-SET DEBUG_SYNC='reset';
-SET GLOBAL debug_dbug = DEFAULT;
-connection node_1;
-DROP TABLE t1;
diff --git a/mysql-test/suite/galera/t/MDEV-27713.test b/mysql-test/suite/galera/t/MDEV-27713.test
deleted file mode 100644
index 4bfcd7e3d50..00000000000
--- a/mysql-test/suite/galera/t/MDEV-27713.test
+++ /dev/null
@@ -1,67 +0,0 @@
---source include/galera_cluster.inc
---source include/have_innodb.inc
---source include/have_debug.inc
---source include/have_debug_sync.inc
---source include/big_test.inc
-
-CREATE TABLE t1 (
- f1 INT,
- f2 VARCHAR(255) PRIMARY KEY
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-INSERT INTO t1 VALUES(1, 'abc');
-
---connection node_1
-SET AUTOCOMMIT=OFF;
-START TRANSACTION;
-INSERT INTO t1 VALUES (2,'def');
-
---connection node_2
-
-SET GLOBAL event_scheduler=ON;
-
-DELIMITER |;
-CREATE PROCEDURE update_table()
-BEGIN
- SET AUTOCOMMIT=OFF;
- DO GET_LOCK('local_lock', 0);
- SET DEBUG_SYNC = 'innodb_row_update_for_mysql_begin SIGNAL blocked WAIT_FOR continue';
- UPDATE t1 SET f2 = 'jkl' WHERE f1 != 2;
- DO RELEASE_LOCK('local_lock');
-END|
-DELIMITER ;|
-
-CREATE DEFINER=current_user
- EVENT event
- ON SCHEDULE AT CURRENT_TIMESTAMP
- ON COMPLETION PRESERVE
- ENABLE
- DO CALL update_table();
-
---connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
-SET DEBUG_SYNC = 'now WAIT_FOR blocked';
-
-# Applier control thread
---connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2
-SET GLOBAL debug_dbug = "+d,sync.wsrep_apply_cb";
-
---connection node_1
-COMMIT;
-
-# Applier control thread
---connection node_2b
-SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
-SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
-
---connection node_2a
-SET DEBUG_SYNC = 'now SIGNAL continue';
-
---connection node_2
-SET GLOBAL event_scheduler=default;
-DROP PROCEDURE update_table;
-DROP EVENT event;
-SET DEBUG_SYNC='reset';
-SET GLOBAL debug_dbug = DEFAULT;
-
---connection node_1
-DROP TABLE t1;