[Commits] 767d6ce38ca: MDEV-15807: Test failure on galera.galera_lock_table

jan jan.lindstrom at mariadb.com
Mon Apr 9 07:29:18 EEST 2018


revision-id: 767d6ce38cafd735aa70fcd6d6e4fa682d5548af (mariadb-10.1.32-41-g767d6ce38ca)
parent(s): 8bb40f2404909fc9c8070008f8a6e86180f2d74b
author: Jan Lindström
committer: Jan Lindström
timestamp: 2018-04-09 07:28:13 +0300
message:

MDEV-15807: Test failure on galera.galera_lock_table

Wait until create tables are replicated to the slave before trying
lock table.

---
 mysql-test/suite/galera/disabled.def               | 1 -
 mysql-test/suite/galera/r/galera_lock_table.result | 4 ++++
 mysql-test/suite/galera/t/galera_lock_table.test   | 7 +++++++
 3 files changed, 11 insertions(+), 1 deletion(-)

diff --git a/mysql-test/suite/galera/disabled.def b/mysql-test/suite/galera/disabled.def
index 13bb2d01ffb..4861223ba4b 100644
--- a/mysql-test/suite/galera/disabled.def
+++ b/mysql-test/suite/galera/disabled.def
@@ -31,7 +31,6 @@ galera_var_retry_autocommit : MDEV-15794 Test failure on galera.galera_var_retry
 galera_var_auto_inc_control_on : MDEV-15803 Test failure on galera.galera_var_auto_inc_control_on
 pxc-421 : MDEV-15804 Test failure on galera.pxc-421
 query_cache : MDEV-15805 Test failure on galera.query_cache
-galera.galera_lock_table : MDEV-15807
 galera.galera_gra_log : MDEV-15808 Test failure on galera.galera_gra_log
 galera.MW-44 : MDEV-15809 Test failure on galera.MW-44
 galera.lp1376747 : MDEV-15810 Test failure on galera.lp1376747
diff --git a/mysql-test/suite/galera/r/galera_lock_table.result b/mysql-test/suite/galera/r/galera_lock_table.result
index 16e9037a4de..0d40ac16565 100644
--- a/mysql-test/suite/galera/r/galera_lock_table.result
+++ b/mysql-test/suite/galera/r/galera_lock_table.result
@@ -1,5 +1,9 @@
 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
+SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
+NAME
+test/t1
+test/t2
 LOCK TABLE t1 READ;
 INSERT INTO t1 VALUES (1);
 INSERT INTO t2 VALUES (1);
diff --git a/mysql-test/suite/galera/t/galera_lock_table.test b/mysql-test/suite/galera/t/galera_lock_table.test
index bd581842f6f..2745bfe5faf 100644
--- a/mysql-test/suite/galera/t/galera_lock_table.test
+++ b/mysql-test/suite/galera/t/galera_lock_table.test
@@ -12,6 +12,13 @@ CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
 
 --connection node_2
+
+# Wait until above DDL's are replicated
+--let $wait_condition = SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
+--source include/wait_condition.inc
+
+SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
+
 LOCK TABLE t1 READ;
 
 --connection node_1


More information about the commits mailing list