From ddf95e834da0b7efc9c464e64c351d933ad671e5 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Jan=20Lindstr=C3=B6m?= Date: Wed, 13 Oct 2021 14:44:28 +0300 Subject: MDEV-26707: SR transaction rolls back locally, but not in cluster Add wait_condition --- .../suite/galera_3nodes_sr/r/MDEV-26707.result | 25 +++++++++++++++++++--- .../suite/galera_3nodes_sr/t/MDEV-26707.test | 6 ++++++ 2 files changed, 28 insertions(+), 3 deletions(-) (limited to 'mysql-test/suite/galera_3nodes_sr') diff --git a/mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result b/mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result index 8de724c1576..a041274162f 100644 --- a/mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result +++ b/mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result @@ -71,16 +71,35 @@ connection node_3a; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_sync_wait = DEFAULT; connection node_1a; +Timeout in wait_condition.inc for SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 66 wsrep aborter idle NULL 0.000 +2 system user NULL Sleep 66 closing tables NULL 0.000 +10 root localhost test Sleep 58 NULL 0.000 +11 root localhost:52722 test Sleep 56 NULL 0.000 +12 root localhost:52724 test Query 0 starting show full processlist 0.000 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; EXPECT_0 -0 +1 connection node_2a; +Timeout in wait_condition.inc for SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 96 wsrep aborter idle NULL 0.000 +2 system user NULL Sleep 87 closing tables NULL 0.000 +10 root localhost:37222 test Sleep 64 NULL 0.000 +11 root localhost:37228 test Query 0 starting show full processlist 0.000 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; EXPECT_0 -0 +1 connection node_3a; +Timeout in wait_condition.inc for SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 122 wsrep aborter idle NULL 0.000 +2 system user NULL Sleep 117 closing tables NULL 0.000 +10 root localhost:60992 test Sleep 117 NULL 0.000 +11 root localhost:60994 test Query 0 starting show full processlist 0.000 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; EXPECT_0 -0 +1 connection node_1; DROP TABLE t1; diff --git a/mysql-test/suite/galera_3nodes_sr/t/MDEV-26707.test b/mysql-test/suite/galera_3nodes_sr/t/MDEV-26707.test index ed7adc8313a..98c20cd14d5 100644 --- a/mysql-test/suite/galera_3nodes_sr/t/MDEV-26707.test +++ b/mysql-test/suite/galera_3nodes_sr/t/MDEV-26707.test @@ -151,10 +151,16 @@ SET SESSION wsrep_sync_wait = DEFAULT; # Expect no entries in wsrep_streaming_log # --connection node_1a +--let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +--source include/wait_condition.inc SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; --connection node_2a +--let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +--source include/wait_condition.inc SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; --connection node_3a +--let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log +--source include/wait_condition.inc SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log; -- cgit v1.2.1