diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-09-10 13:25:57 +0300 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-09-10 13:28:09 +0300 |
| commit | 8993e40dde2803156bacd9977495336eb8c03cf9 (patch) | |
| tree | 95dd344437c3d534413fe8ceb3079ce5ec432ca8 | |
| parent | f19da4a05a14e217e77600cd452a345d209101cf (diff) | |
| download | mariadb-git-8993e40dde2803156bacd9977495336eb8c03cf9.tar.gz | |
MDEV-23709 : Galera test failure on galera_fk_cascade_delete_debug
Add wait_condition so that inserts to parent and child are replicated
and applied before we set debug sync point.
| -rw-r--r-- | mysql-test/suite/galera/r/galera_fk_cascade_delete_debug.result | 1 | ||||
| -rw-r--r-- | mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test | 7 |
2 files changed, 5 insertions, 3 deletions
diff --git a/mysql-test/suite/galera/r/galera_fk_cascade_delete_debug.result b/mysql-test/suite/galera/r/galera_fk_cascade_delete_debug.result index 33ae66b1989..bd76692b27c 100644 --- a/mysql-test/suite/galera/r/galera_fk_cascade_delete_debug.result +++ b/mysql-test/suite/galera/r/galera_fk_cascade_delete_debug.result @@ -46,6 +46,7 @@ ON DELETE CASCADE ) ENGINE=InnoDB; INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1,0,1); +connection node_2; connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb"; connection node_2; diff --git a/mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test b/mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test index f38c028b7d6..96e633f83d7 100644 --- a/mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test +++ b/mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test @@ -61,20 +61,21 @@ CREATE TABLE child ( INSERT INTO parent VALUES (1); INSERT INTO child VALUES (1,0,1); +--connection node_2 +--let $wait_condition = SELECT COUNT(*) = 1 FROM child; +--source include/wait_condition.inc + # block applier before applying --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb"; --connection node_2 ---let $wait_condition = SELECT COUNT(*) = 1 FROM child; ---source include/wait_condition.inc DELETE FROM parent; --connection node_1a # wait until applier has reached the sync point SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached"; - --connection node_1 # issue conflicting write to child table, it should fail in certification --error ER_LOCK_DEADLOCK |