diff options
author | Jan Lindström <jan.lindstrom@mariadb.com> | 2021-10-13 14:44:28 +0300 |
---|---|---|
committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2021-10-13 14:44:47 +0300 |
commit | ddf95e834da0b7efc9c464e64c351d933ad671e5 (patch) | |
tree | 2fdeb38f1e1cc9e4d06a08b5143c70a39dd24611 /mysql-test/suite/galera_3nodes_sr | |
parent | ae098b49dd2b83923c9b04f81b04dda0161ed28d (diff) | |
download | mariadb-git-ddf95e834da0b7efc9c464e64c351d933ad671e5.tar.gz |
MDEV-26707: SR transaction rolls back locally, but not in cluster
Add wait_condition
Diffstat (limited to 'mysql-test/suite/galera_3nodes_sr')
-rw-r--r-- | mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result | 25 | ||||
-rw-r--r-- | mysql-test/suite/galera_3nodes_sr/t/MDEV-26707.test | 6 |
2 files changed, 28 insertions, 3 deletions
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; |