[MDEV-28872] Galera group UUID Created: 2022-06-17  Updated: 2022-06-17

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

Type: Bug Priority: Major
Reporter: William Wong Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

redhat 7 x86_64 on VMware

Attachments: Text File mariadb-error.1st.log     Text File mariadb-error.2nd.log    

 Description   

We have an 3 nodes Galera cluster (2 data nodes + 1 arbitrator)

Found one node (1st node) got group UUID all 0. This DB node is up and running.

MariaDB [(none)]> show status like 'wsrep%uuid%';
 
+--------------------------+--------------------------------------+
 
| Variable_name            | Value                                |
 
+--------------------------+--------------------------------------+
 
| wsrep_local_state_uuid   |                                      |
 
| wsrep_gcomm_uuid         | 60932a90-4908-11ec-982f-12a73728d85f |
 
| wsrep_cluster_state_uuid | 00000000-0000-0000-0000-000000000000 |
 
+--------------------------+--------------------------------------+

Unfortunately, we restart the other DB node (2nd node) and 2nd node cannot join back cluster even using SST.

Is there any method to change the UUID online in the 1st node?

Second question: Will bootstrap the whole DB cluster set the UUID and solve the problem?

 Comments   
Comment by Daniel Black [ 2022-06-17 ]

Attach the log files.

Comment by William Wong [ 2022-06-17 ]

attached log
mariadb-error.1st.log - node with uuid all 0
mariadb-error.2nd.log - node restarted

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