diff options
author | Jan Lindström <jan.lindstrom@mariadb.com> | 2019-07-03 15:52:38 +0300 |
---|---|---|
committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2019-07-04 19:42:55 +0300 |
commit | fee61edd4401ac4e5f6dd71d5de89dd495b821be (patch) | |
tree | 8851bf24be7884e21e87921e611140759bcd0144 | |
parent | 24aa723a28764d11430fbffb562be7b1f30a8b68 (diff) | |
download | mariadb-git-fee61edd4401ac4e5f6dd71d5de89dd495b821be.tar.gz |
MDEV-19939: Galera test failure on galera_toi_ddl_fk_insert
Add sync wait to make sure selects see correct consistent db.
-rw-r--r-- | mysql-test/suite/galera/disabled.def | 1 | ||||
-rw-r--r-- | mysql-test/suite/galera/r/galera_toi_ddl_fk_insert.result | 31 | ||||
-rw-r--r-- | mysql-test/suite/galera/t/galera_toi_ddl_fk_insert.test | 17 |
3 files changed, 24 insertions, 25 deletions
diff --git a/mysql-test/suite/galera/disabled.def b/mysql-test/suite/galera/disabled.def index 4bb2c4f92eb..4b872e4bd68 100644 --- a/mysql-test/suite/galera/disabled.def +++ b/mysql-test/suite/galera/disabled.def @@ -32,7 +32,6 @@ galera_parallel_autoinc_largetrx : MDEV-19746 Galera test failures because of ws galera_parallel_autoinc_manytrx : MDEV-19746 Galera test failures because of wsrep_slave_threads identification galera_ssl_upgrade : MDEV-19950 Galera test failure on galera_ssl_upgrade galera_sst_mariabackup_encrypt_with_key : MDEV-19926 Galera SST tests fail -galera_toi_ddl_fk_insert : MDEV-19939: Galera test failure on galera_toi_ddl_fk_insert galera_var_slave_threads : MDEV-19746 Galera test failures because of wsrep_slave_threads identification galera_wan : MDEV-17259: Test failure on galera.galera_wan diff --git a/mysql-test/suite/galera/r/galera_toi_ddl_fk_insert.result b/mysql-test/suite/galera/r/galera_toi_ddl_fk_insert.result index 0dbc89978d4..94752ed7c76 100644 --- a/mysql-test/suite/galera/r/galera_toi_ddl_fk_insert.result +++ b/mysql-test/suite/galera/r/galera_toi_ddl_fk_insert.result @@ -1,9 +1,8 @@ -CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB; +CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB; INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); CREATE TABLE parent ( id INT PRIMARY KEY AUTO_INCREMENT, -f2 INTEGER, -KEY (id) +f2 INTEGER ) ENGINE=InnoDB; CREATE TABLE child ( id INT PRIMARY KEY AUTO_INCREMENT, @@ -23,19 +22,21 @@ connection node_1b; connection node_2; connection node_2a; connection node_1; -SELECT COUNT(*) = 20001 FROM parent; -COUNT(*) = 20001 -1 -SELECT COUNT(*) = 10000 FROM child; -COUNT(*) = 10000 -1 +SET SESSION wsrep_sync_wait=15; +SELECT COUNT(*) FROM parent; +COUNT(*) +20001 +SELECT COUNT(*) FROM child; +COUNT(*) +10000 connection node_2; -SELECT COUNT(*) = 20001 FROM parent; -COUNT(*) = 20001 -1 -SELECT COUNT(*) = 10000 FROM child; -COUNT(*) = 10000 -1 +SET SESSION wsrep_sync_wait=15; +SELECT COUNT(*) FROM parent; +COUNT(*) +20001 +SELECT COUNT(*) FROM child; +COUNT(*) +10000 DROP TABLE child; DROP TABLE parent; DROP TABLE ten; diff --git a/mysql-test/suite/galera/t/galera_toi_ddl_fk_insert.test b/mysql-test/suite/galera/t/galera_toi_ddl_fk_insert.test index 9f161afc52e..fadc94d78ff 100644 --- a/mysql-test/suite/galera/t/galera_toi_ddl_fk_insert.test +++ b/mysql-test/suite/galera/t/galera_toi_ddl_fk_insert.test @@ -6,13 +6,12 @@ # This test creates a new FK constraint while concurrent INSERTS are running # -CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB; +CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB; INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); CREATE TABLE parent ( id INT PRIMARY KEY AUTO_INCREMENT, - f2 INTEGER, - KEY (id) + f2 INTEGER ) ENGINE=InnoDB; CREATE TABLE child ( @@ -41,7 +40,6 @@ INSERT INTO parent VALUES (1, 0); --let $galera_server_number = 1 --source include/galera_connect.inc --connection node_1b ---sleep 2 --send ALTER TABLE child ADD FOREIGN KEY (parent_id) REFERENCES parent(id); --connection node_1a @@ -57,14 +55,15 @@ INSERT INTO parent VALUES (1, 0); --reap --connection node_1 -SELECT COUNT(*) = 20001 FROM parent; -SELECT COUNT(*) = 10000 FROM child; +SET SESSION wsrep_sync_wait=15; +SELECT COUNT(*) FROM parent; +SELECT COUNT(*) FROM child; --connection node_2 -SELECT COUNT(*) = 20001 FROM parent; -SELECT COUNT(*) = 10000 FROM child; +SET SESSION wsrep_sync_wait=15; +SELECT COUNT(*) FROM parent; +SELECT COUNT(*) FROM child; DROP TABLE child; DROP TABLE parent; - DROP TABLE ten; |