[MDEV-23595] galera_3nodes.galera_wsrep_schema MTR failed: mysql_shutdown failed Created: 2020-08-26  Updated: 2022-05-17  Resolved: 2022-05-16

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.15, 10.5.6, 10.6.0
Fix Version/s: 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-rpm-rhel8-amd64


Attachments: Zip Archive MDEV-23595_104_logs_201202.zip    
Issue Links:
Relates
relates to MDEV-24481 galera_3nodes.galera_vote_rejoin_mysq... Closed

 Description   

galera_3nodes.galera_wsrep_schema failed on BB 10.4 and BB 10.5: "mysql_shutdown failed".

stdio.log:

10.4.15 571764c04fc9b736366959b2c0e00d9bd0eb5a4e

galera_3nodes.galera_wsrep_schema 'innodb' w2 [ fail ]
        Test ended at 2020-08-26 14:43:12
 
CURRENT_TEST: galera_3nodes.galera_wsrep_schema
mysqltest: In included file "./include/shutdown_mysqld.inc": 
included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_wsrep_schema.test at line 52:
At line 40: mysql_shutdown failed
 
The result from queries just before the failure was:
< snip >
SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size')
1
SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
COUNT(*) = 1
1
SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
node_incoming_address LIKE '127.0.0.1:%'
1
1
1
SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid')
1
1
1
SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
COUNT(*) = 1
1
connection node_2;



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-12-23 ]

It still fails on BB, 10.5.
And it fails also on BB, 10.4 and BB, 10.6.

10.4 Server logs

Generated at Thu Feb 08 09:23:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.