[MDEV-21081] Stop and Start issues in MariaDB Galera Cluster Created: 2019-11-19  Updated: 2019-12-01

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Ras Tarun Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

We have Quarterly Patching maintenance activities on Linux operating system where
MariaDB Galera Cluster is hosted on all three Linux Nodes.

We need to bring MariaDB Galera environment before Linux RPM Patching Upgrade.

On completion of RPM Patching on Linux , we are facing issues in Starting up MariaDB Galera Nodes.

Generally Primary Node comes up with sudo galera_new_cluster command while remaining two nodes fail to come up.

Kindly advise , would it be advisable to use Automatic Bootstrap rather than Manual Bootstrap

We have Primary Node up where MariaDB Service is Active , Would it be advisable to

execute this command on Primary Active Node

MariaDB [(none)]> set global wsrep_provider_options='pc.bootstrap=YES';

and try to start remaining Nodes



 Comments   
Comment by Ras Tarun [ 2019-11-19 ]

grastate.dat shows sequence number is -1 on all Nodes , Is it a good sign stating MariaDB Galera is healthy

or Does it means that Nodes have crashed and Bootstrapping is required

Would it be advisable to do Automatic Bootstrapping or Manually Bootstrap in this situation

Comment by Ras Tarun [ 2019-11-19 ]

Below is the status of wsrep_last_committed on all 3 nodes of MariaDB Galera

On Node 1

MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_last_committed';
-------------------------------+

Variable_name Value

-------------------------------+

wsrep_last_committed 250792089

-------------------------------+
1 row in set (0.00 sec)

On Node 2

MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_last_committed';
---------------------------+

Variable_name Value

---------------------------+

wsrep_last_committed 0

---------------------------+
1 row in set (0.00 sec)

On Node 3

MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_last_committed';
---------------------------+

Variable_name Value

---------------------------+

wsrep_last_committed 0

---------------------------+
1 row in set (0.01 sec)

We are able to start MariaDB Services on Node 1 but On Node 2 & Node 3 , MariaDB Services are down and failing to start

Would be it be advisable to execute

node1> SET GLOBAL wsrep_provider_options="pc.bootstrap=1";

or

set GLOBAL wsrep_provider_options='pc.bootstrap=YES';

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