wsrep_sst_mysqldump fails if joiner has logging enabled
Bug #385269 reported by
Seppo Jaakola
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
High
|
Seppo Jaakola | ||
Bug Description
wsrep_sst_mysqldump aborts for an error in dump loading phase, if the joiner node has logging enabled. This happens with either general_log or slow_query_log.
The error message from the script is:
ERROR 1580 (HY000) at line 114: You cannot 'ALTER' a log table if logging is enabled
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
| importance: | Undecided → High |
| milestone: | none → 0.7 |
| status: | New → In Progress |
Revision history for this message
| Alex Yurchenko (ayurchen) wrote Re: [Bug 385269] Re:wsrep_sst_mysqldump fails if joiner has logging enabled | #2 |
| Changed in codership-mysql: | |
| status: | In Progress → Fix Committed |
| Changed in codership-mysql: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
the dump file has "ALTER TABLE" commands for the log tables. It turns out that MySQL does not allow altering these tables, if logging is enabled.
As a workaround the logging should be disabled for the duration of loading the dump.