mysqldump SST is broken in current head
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| MySQL patches by Codership | Status tracked in 5.6 | |||||
| 5.5 |
Fix Released
|
High
|
Yan Zhang | |||
| 5.6 |
Fix Released
|
High
|
Yan Zhang | |||
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
| 5.5 |
New
|
Undecided
|
Unassigned | |||
| 5.6 |
Fix Released
|
Undecided
|
Unassigned | |||
Bug Description
lp:codership-mysql/5.5 r3965
lp:codership-mysql/5.6 r4064
Recent merges from PXC has added WSREP_SST_OPT_CONF into wsrep_sst_common.sh which causes error with mysqldump SST because --defaults-file parameter is not passed to wsrep_sst_
Another issue is that if JOINER does not have binlog enabled, SST fails with
ERROR 1186 (HY000) at line 2: Binlog closed, cannot RESET MASTER
RESET MASTER is used to clear old binlog files and to reset GTID related variables on JOINER. Even if RESET MASTER does not make any sense if binlog is not on, DONOR does not know about JOINERs binlog settings and therefore it must be made to succeed on JOINER if wsrep is on to make error free SST possible.
| Yan Zhang (yan.zhang) wrote | #1 |
| Yan Zhang (yan.zhang) wrote | #2 |
| Yan Zhang (yan.zhang) wrote | #3 |
| Yan Zhang (yan.zhang) wrote | #4 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #5 |
first issue
fixed in http://