Details
Description
galera.MW-336 'innodb' w2 [ fail ]
|
Test ended at 2020-02-05 09:58:15
|
|
CURRENT_TEST: galera.MW-336
|
--- /usr/share/mysql/mysql-test/suite/galera/r/MW-336.result 2020-02-05 07:41:16.000000000 -0500
|
+++ /dev/shm/var/2/log/MW-336.reject 2020-02-05 09:58:15.531334676 -0500
|
@@ -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 37 wsrep aborter idle NULL 0.000
|
+3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
|
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
|
+15 root localhost test Sleep 32 NULL 0.000
|
+16 root localhost:54312 test Query 0 Init show processlist 0.000
|
+17 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+18 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+20 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+21 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+19 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+22 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+24 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+23 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+25 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
|
+26 system user NULL Sleep 30 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
|
+30 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+32 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+29 system user NULL Sleep 30 wsrep applier idle NULL 0.000
|
+31 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 67 wsrep aborter idle NULL 0.000
|
+3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
|
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
|
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
|
+15 root localhost test Sleep 63 NULL 0.000
|
+16 root localhost:54312 test Query 0 Init show processlist 0.000
|
+34 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+35 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+36 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+37 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+26 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+27 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+28 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+30 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+32 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+29 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
+31 system user NULL Sleep 61 wsrep applier idle NULL 0.000
|
connection node_2;
|
INSERT INTO t1 VALUES (11);
|
INSERT INTO t1 VALUES (12);
|
|
mysqltest: Result length mismatch
|
|
- saving '/dev/shm/var/2/log/galera.MW-336-innodb/' to '/dev/shm/var/log/galera.MW-336-innodb/'
|
|
Retrying test galera.MW-336, attempt(2/3)...
|