search

codership / galera-manager-support

Galera Manager Support Repository
7 stars 2 forks source link

No of nodes present is incorrect - logic flaw #72

Open rajeshXYZ opened 7 months ago

rajeshXYZ commented 7 months ago

I have 3 nodes

mysql Ver 15.1 Distrib 10.4.25-MariaDB,

On healthy node , I see this. Also note that I restarted another node-2 and it was in in joining status. But galera seems to have decided to declare that as already joinedm,

+---------------------------+---------+
| Variable_name             | Value   |
+---------------------------+---------+
| wsrep_protocol_version    | 10      |
| wsrep_local_state_comment | Synced  |
| wsrep_cluster_size        | 3       |
| wsrep_cluster_status      | Primary |
+---------------------------+---------+

On node-2

2023-11-29 11:30:18 0 [Note] WSREP: Member 1.0 (i-xxxx-2) requested state transfer from '*any*'. Selected 0.0 (i-xxx-1)(SYNCED) as donor.
2023-11-29 11:30:18 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 262059818)
2023-11-29 11:30:18 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2023-11-29 11:30:18 2 [Note] WSREP: Resetting GCache seqno map due to different histories.
2023-11-29 11:30:18 2 [Note] WSREP: GCache history reset: b883495d-5a4f-11ea-bc88-53fd69b864fe:261979142 -> b883495d-5a4f-11ea-bc88-53fd69b864fe:262059810
2023-11-29 11:30:18 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 1073139376 bytes
2023-11-29 11:30:18 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 1/10 locked buffers
2023-11-29 11:30:19 0 [Note] WSREP: (ab4642c3-ade3, 'tcp://0.0.0.0:4567') turning message relay requesting off