Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
When flashback is enabled, the local value of binlog_format can still be set to STATEMENT or MIXED, and an informative warning is produced:
MariaDB [test]> show warnings;
|
+---------+------+------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------+
|
| Warning | 1105 | MariaDB Galera and flashback do not support binlog format: MIXED |
|
+---------+------+------------------------------------------------------------------+
|
1 row in set (0.01 sec)
|
However, when one attempts to set the global value, it produces a generic error:
MariaDB [test]> set global binlog_format=mixed;
|
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'mixed'
|
Maybe there is a reason why a local value can be set and global can not, but then the error message should at least say why it is not possible, referring to flashback.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | 10.2-ga |
| Assignee | Lixun Peng [ plinux ] | Sachin Setiya [ sachin.setiya.007 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Sachin Setiya [ sachin.setiya.007 ] | Michael Widenius [ monty ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Labels | 10.2-ga |
| Assignee | Michael Widenius [ monty ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Sachin Setiya [ sachin.setiya.007 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Attachment | patch [ 43587 ] |
| Fix Version/s | 10.2.6 [ 22527 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 79562 ] | MariaDB v4 [ 151680 ] |
I'm having the same error reported when I try to set global binlog_format back to mixed.
Why is that and how can I switch to mixed binlog format dynamically or is it required to restart server?
sachin.setiya.007, what's the state of it? where's the patch?