[MDEV-24481] galera_3nodes.galera_vote_rejoin_mysqldump MTR failed: mysql_shutdown failed Created: 2020-12-23  Updated: 2023-12-21  Resolved: 2023-12-21

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.5.9, 10.6.0
Fix Version/s: 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Critical
Reporter: Stepan Patryshev (Inactive) Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-rpm-centos8-amd64, kvm-zyp-opensuse150-amd64


Attachments: Zip Archive MDEV-24481_105_logs_201211.zip    
Issue Links:
Blocks
blocks MDEV-22122 Galera test failures on 10.5 Open
blocks MDEV-30172 Galera test case cleanup Stalled
Relates
relates to MDEV-23595 galera_3nodes.galera_wsrep_schema MTR... Closed
relates to MDEV-23605 galera_3nodes.galera_vote_rejoin_mysq... Closed
relates to MDEV-24097 galera_3nodes suite tests in MTR spor... Closed
relates to MDEV-32635 galera_shutdown_nonprim: mysql_shutd... Closed
relates to MDEV-26499 galera_3nodes.galera_ipv6_mysqldump M... Stalled

 Description   

galera_3nodes.galera_vote_rejoin_mysqldump failed on BB 10.5 CS and BB 10.6 CS: "mysql_shutdown failed".
It seems to be a sporadic issue.

[stdio.log|url2log]:

10.5.9, 8677c14e65f436db00be5aedb1f644fcffc70f7e, kvm-zyp-opensuse150-amd64

galera_3nodes.galera_vote_rejoin_mysqldump 'innodb' w1 [ fail ]
        Test ended at 2020-12-11 17:06:52
 
CURRENT_TEST: galera_3nodes.galera_vote_rejoin_mysqldump
mysqltest: In included file "./include/shutdown_mysqld.inc": 
included from ./include/restart_mysqld.inc at line 10:
included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test at line 78:
At line 50: mysql_shutdown failed
 
The result from queries just before the failure was:
< snip >
expect_Primary
Primary
connection node_2;
SET SESSION wsrep_on=OFF;
SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
expect_Disconnected
Disconnected
SET SESSION wsrep_on=ON;
SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
expect_Primary
Primary
connection node_1;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `f1` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
connection node_2;
SET SESSION wsrep_on=OFF;
SET SESSION wsrep_on=ON;
 
More results from queries before failure can be found in /dev/shm/var/1/log/galera_vote_rejoin_mysqldump.log
 
 - saving '/dev/shm/var/1/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' to '/dev/shm/var/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/'
 
Retrying test galera_3nodes.galera_vote_rejoin_mysqldump, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started
worker[1] > Restart  - not started
***Warnings generated in error logs during shutdown after running tests: galera_3nodes.galera_vote_rejoin_mysqldump
 
2020-12-11 17:06:48 2 [ERROR] WSREP: Vote 0 (success) on 3a0023f3-3bd3-11eb-827e-fb59270527e2:7 is inconsistent with group. Leaving cluster.

Server logs.



 Comments   
Comment by Jan Lindström [ 2023-12-19 ]

https://github.com/MariaDB/server/pull/2945

Comment by Julius Goryavsky [ 2023-12-21 ]

Thanks, change merged with head revision: https://github.com/MariaDB/server/commit/cfaab614ea9bf0df4b5398c5d51f18cda8a9a00f

Comment by Julius Goryavsky [ 2023-12-21 ]

Fix merged with head revision: https://github.com/MariaDB/server/commit/cfaab614ea9bf0df4b5398c5d51f18cda8a9a00f

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