diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-04-29 17:02:30 +0300 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-04-29 17:04:10 +0300 |
| commit | 7a546650fae56368800c52bc996d8830fb1de3b9 (patch) | |
| tree | b4e58f7099c6d764bd733d8ed4b98de99b1ec55b | |
| parent | ba2061da52d9dba06dfd454efc1332f7d6cf476c (diff) | |
| download | mariadb-git-7a546650fae56368800c52bc996d8830fb1de3b9.tar.gz | |
MDEV-20916: Galera test failure on galera.galera_parallel_autoinc_largetrx: Result content mismatch
Add wait_condition to make sure that node contains all the rows
expected.
| -rw-r--r-- | mysql-test/suite/galera/disabled.def | 1 | ||||
| -rw-r--r-- | mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result | 8 | ||||
| -rw-r--r-- | mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test | 8 |
3 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/suite/galera/disabled.def b/mysql-test/suite/galera/disabled.def index 27691c8f4b5..59faf2c2fe7 100644 --- a/mysql-test/suite/galera/disabled.def +++ b/mysql-test/suite/galera/disabled.def @@ -21,7 +21,6 @@ galera_binlog_stmt_autoinc : MDEV-19959 Galera test failure on galera_binlog_stm galera_gcache_recover_manytrx : MDEV-18834 Galera test failure galera_ist_progress : MDEV-15236 fails when trying to read transfer status galera_load_data : MDEV-19968 galera.galera_load_data -galera_parallel_autoinc_largetrx : MDEV-20916 galera.galera_parallel_autoinc_largetrx galera_parallel_simple : MDEV-20318 galera.galera_parallel_simple fails galera_shutdown_nonprim : MDEV-21493 galera.galera_shutdown_nonprim galera_ssl_upgrade : MDEV-19950 Galera test failure on galera_ssl_upgrade diff --git a/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result b/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result index b21a9d0bdca..8d8f4c1a371 100644 --- a/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result +++ b/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result @@ -15,11 +15,11 @@ connection node_1; connection node_1a; connection node_2; disconnect node_1a; -SELECT COUNT(*) FROM t1; -COUNT(*) +SELECT COUNT(*) AS EXPECT_30000 FROM t1; +EXPECT_30000 30000 -SELECT COUNT(DISTINCT f1) FROM t1; -COUNT(DISTINCT f1) +SELECT COUNT(DISTINCT f1) AS EXPECT_30000 FROM t1; +EXPECT_30000 30000 connection default; DROP TABLE t1; diff --git a/mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test b/mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test index 9e1f47b1ac4..adabb4def00 100644 --- a/mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test +++ b/mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test @@ -44,8 +44,12 @@ SET GLOBAL wsrep_slave_threads = 4; --connection node_2 --reap --disconnect node_1a -SELECT COUNT(*) FROM t1; -SELECT COUNT(DISTINCT f1) FROM t1; + +--let $wait_condition = SELECT COUNT(*) = 30000 FROM t1; +--source include/wait_condition.inc + +SELECT COUNT(*) AS EXPECT_30000 FROM t1; +SELECT COUNT(DISTINCT f1) AS EXPECT_30000 FROM t1; --disable_query_log --eval SET GLOBAL wsrep_slave_threads = $wsrep_slave_threads_orig; |