[MDEV-12017] Unclear error with flashback: Variable 'binlog_format' can't be set to the value of 'statement' Created: 2017-02-07  Updated: 2017-04-27  Resolved: 2017-04-26

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.2
Fix Version/s: 10.2.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: HTML File patch    

 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.

 Comments   
Comment by Sergei Golubchik [ 2017-04-24 ]

sachin.setiya.007, what's the state of it? where's the patch?

Comment by Sachin Setiya (Inactive) [ 2017-04-26 ]

patch
Pushed

Generated at Thu Feb 08 07:54:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.