Cannot set wsrep_desync to OFF dynamically when set in my.cnf
Bug #1574846 reported by
amit arora
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Undecided
|
Krunal Bauskar | ||
Bug Description
I have 3 node PXC, let's say PXC1, PXC2 and PXC3 as 3 nodes of the cluster.
PXC1 is a primary node of sorts (since it is an async slave or another mysql master).
I created PXC1 through xtrabackup from another mysql server(not PXC) and setup replication on it.
Added PXC2, which did an SST from PXC1 and was in sync later.
In PXC3, I set "wsrep_desync=ON" in my.cnf, later PXC3 did an SST from PXC2 and was in sync.
Now I tried to disable wsrep_desync on PXC3 through following command:
"set wsrep_desync = OFF", but it threw error 1231 saying value "OFF" cannot be set for this parameter.
ERROR 1231 (42000):Variable 'wsrep_desync' can't be set to the value of 'OFF'
Version 5.6.28
Revision history for this message
| amit arora (amit-0923) wrote | #2 |
Revision history for this message
| Krunal Bauskar (krunal-bauskar) wrote | #3 |
| Changed in percona-xtradb-cluster: | |
| status: | New → Confirmed |
| assignee: | nobody → Krunal Bauskar (krunal-bauskar) |
| Changed in percona-xtradb-cluster: | |
| status: | Confirmed → Fix Committed |
| Changed in percona-xtradb-cluster: | |
| milestone: | none → 5.6.29-25.15 |
| Changed in percona-xtradb-cluster: | |
| status: | Fix Committed → Fix Released |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
To post a comment you must log in.
Version 5.6.28