Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.4.9
-
None
-
OS: CentOS Linux release 7.6.1810 (Core).
Description
It sporadically fails on bb and local suite runs.
MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 2b5f4b3ed68585b310b7ebede474928ff90d9aa2; debug built from sources.
Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.
Run:
./mtr --suite galera --force --big-test --max-test-fail=0 --parallel=auto --timer --timestamp --timediff
|
stdout.log (the whole file is attached: 191026_1520_SSD_stdout.log
):
mysqltest: Result length mismatch
191026 15:29:56 +2.024 galera.MW-336 'innodb' w4 [ fail ]
|
Test ended at 2019-10-26 15:29:56
|
|
|
CURRENT_TEST: galera.MW-336
|
--- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.result 2019-10-13 09:12:21.392670633 +0300
|
+++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.reject 2019-10-26 15:29:55.931500577 +0300
|
@@ -12,6 +12,40 @@
|
# Set slave threads to 10 step 2
|
SET GLOBAL wsrep_slave_threads = 20;
|
# Set slave threads to 20
|
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
|
+SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
|
+COUNT(*) EXPECTED_VALUE
|
+21 20
|
+Id User Host db Command Time State Info Progress
|
+1 system user NULL Sleep 38 wsrep aborter idle NULL 0.000
|
+3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+6 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
|
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
|
+16 root localhost test Sleep 33 NULL 0.000
|
+17 root localhost:51250 test Query 0 Init show processlist 0.000
|
+18 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+19 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+20 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+21 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+22 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+23 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+24 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+25 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+26 system user NULL Sleep 31 wsrep applier idle NULL 0.000
|
+27 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+28 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+29 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+30 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+31 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+32 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+33 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+34 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+35 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+36 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+37 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+38 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
SET GLOBAL wsrep_slave_threads = 1;
|
connection node_2;
|
INSERT INTO t1 VALUES (1);
|
@@ -30,6 +64,30 @@
|
COUNT(*)
|
11
|
# Set slave threads to 10 step 3
|
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
|
+SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
|
+COUNT(*) EXPECTED_VALUE
|
+11 10
|
+Id User Host db Command Time State Info Progress
|
+1 system user NULL Sleep 70 wsrep aborter idle NULL 0.000
|
+3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+6 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
|
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
|
+16 root localhost test Sleep 64 NULL 0.000
|
+17 root localhost:51250 test Query 0 Init show processlist 0.000
|
+28 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+29 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+30 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+31 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+32 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+33 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+34 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+35 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+36 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+37 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
+38 system user NULL Sleep 62 wsrep applier idle NULL 0.000
|
connection node_2;
|
INSERT INTO t1 VALUES (11);
|
INSERT INTO t1 VALUES (12);
|
|
|
mysqltest: Result length mismatch
|
See also other logs attached: 191029_galera.MW-336.zip.
Attachments
Issue Links
- duplicates
-
-
- Closed
-