Details
Description
I know that changing wsrep_gtid_domain_id in the configuration file on all nodes requires a full cluster stop and restart to pick up the change as only the first node will actually use the config file value, while all further nodes receive the value to use from their donor during IST/SST.
But when e.g. changing the relevant configuration settings from
wsrep-gtid-mode=ON
|
wsrep_gtid_domain_id=100
|
gtid_domain_id=...different value per node....
|
to
wsrep_gtid_domain_id=200
|
then stopping all nodes, staring node-1 with galera_new_cluster, and node-2 with systemctl start mariadb, all is fine so far, both nodes show wsrep_gtid_domain_id=200 in SHOW VARIABLES LIKE 'wsrep_gtid_domain_id'. But when starting a 3rd or further nodes they all usually still show 100 instead of 200.
Looking at the error logs I see node-3 usually use node-2 as donor, not node-1.
When I force the node started with galera_new_cluster as the default donor with wsrep_sst_donor=node-1 I get the correct new 200 value on all nodes though.
So somehow nodes seem to remember the previous value and pass that on to joiners instead of the value they received from their own donor, or read from their configuration file.
Attachments
Issue Links
- relates to
-
MDEV-25115 Changes to wsrep_gtid_domain_id in my.cnf are ignored on node restart
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MENT-1230 [ MENT-1230 ] |
| Link |
This issue relates to |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] |
| Assignee | Jan Lindström [ jplindst ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Summary | chainging the value of wsrep_gtid_domain_id with full cluster restart fails on some nodes | changing the value of wsrep_gtid_domain_id with full cluster restart fails on some nodes |
| Status | Confirmed [ 10101 ] | Open [ 1 ] |
| Status | Open [ 1 ] | Needs Feedback [ 10501 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] | |
| Resolution | Incomplete [ 4 ] | |
| Status | Needs Feedback [ 10501 ] | Closed [ 6 ] |
| Resolution | Incomplete [ 4 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | N/A [ 14700 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Jan Lindström [ jplindst ] | Daniele Sciascia [ sciascid ] |
| Assignee | Daniele Sciascia [ sciascid ] | Jan Lindström [ jplindst ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Assignee | Jan Lindström [ jplindst ] | Daniele Sciascia [ sciascid ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Daniele Sciascia [ sciascid ] | Jan Lindström [ jplindst ] |
| Assignee | Jan Lindström [ jplindst ] | Julien Fritsch [ julien.fritsch ] |
| Assignee | Julien Fritsch [ julien.fritsch ] | Jan Lindström [ jplindst ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2023-01-17 12:38:42.0 | 2023-01-17 12:38:42.614 |
| Fix Version/s | 10.5.19 [ 28511 ] | |
| Fix Version/s | 10.6.12 [ 28513 ] | |
| Fix Version/s | 10.7.8 [ 28515 ] | |
| Fix Version/s | 10.8.7 [ 28517 ] | |
| Fix Version/s | 10.9.5 [ 28519 ] | |
| Fix Version/s | 10.10.3 [ 28521 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Zendesk Related Tickets | 121570 153488 |