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
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?