Details
Critical Description
The galera_3nodes.inconsistency_shutdown test occasionally hangs when unable to reach the required cluster size:
galera_3nodes.inconsistency_shutdown w1 [ fail ]
|
Test ended at 2025-06-03 04:14:08
|
 |
CURRENT_TEST: galera_3nodes.inconsistency_shutdown
|
--- /home/jenkins/workspace/Source-Build-Test/src/mysql-test/suite/galera_3nodes/r/inconsistency_shutdown.result 2025-06-03 03:09:26.000000000 +0000
|
+++ /home/jenkins/workspace/Source-Build-Test/src/mysql-test/suite/galera_3nodes/r/inconsistency_shutdown.reject 2025-06-03 04:13:58.423454908 +0000
|
@@ -35,16 +35,53 @@
|
SET wsrep_on=OFF;
|
SET wsrep_on=ON;
|
UNLOCK TABLES;
|
+Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready' AND VARIABLE_VALUE = 'OFF'
|
+Id User Host db Command Time State Info Progress
|
+1 system user NULL Sleep 42 wsrep aborter idle NULL 0.000
|
+2 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+5 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+7 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+6 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+8 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+10 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+12 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+13 system user NULL Sleep 30 wsrep applier committed NULL 0.000
|
+17 root localhost:54480 test Query 0 starting show full processlist 0.000
|
SET SESSION wsrep_on = ON;
|
SET SESSION wsrep_sync_wait = 15;
|
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
|
+Id User Host db Command Time State Info Progress
|
+1 system user NULL Sleep 72 wsrep aborter idle NULL 0.000
|
+2 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+5 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+7 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+6 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+8 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+10 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+12 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+13 system user NULL Sleep 61 wsrep applier committed NULL 0.000
|
+17 root localhost:54480 test Query 0 starting show full processlist 0.000
|
SET SESSION wsrep_on = ON;
|
SET SESSION wsrep_sync_wait = 15;
|
connection node_1;
|
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
|
+Id User Host db Command Time State Info Progress
|
+2 system user NULL Sleep 104 closing tables NULL 0.000
|
+1 system user NULL Sleep 104 wsrep aborter idle NULL 0.000
|
+5 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+8 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+7 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+10 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+9 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+6 system user NULL Sleep 104 wsrep applier idle NULL 0.000
|
+12 system user NULL Sleep 104 closing tables NULL 0.000
|
+18 root localhost test Sleep 94 NULL 0.000
|
+19 root localhost:48102 test Query 0 starting show full processlist 0.000
|
SET SESSION wsrep_on = ON;
|
SET SESSION wsrep_sync_wait = 15;
|
SHOW STATUS LIKE 'wsrep_cluster_size';
|
Variable_name Value
|
-wsrep_cluster_size 2
|
+wsrep_cluster_size 3
|
SELECT * FROM t1;
|
f1 f2
|
1 1
|