[MDEV-14033] wsrep_on=off + binlog = mixed on MariaDB 10.2.9 Created: 2017-10-09  Updated: 2019-03-13  Resolved: 2019-03-13

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.1
Fix Version/s: 10.2.23, 10.1.39, 10.3.14, 10.4.4

Type: Bug Priority: Minor
Reporter: Aurélien LEQUOY Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

The problem it's we can have a working configuration but mysqld refuse to start and it's should not because Galera is off.

oct. 09 14:15:02 hb03-mariatac01-new mysqld[11737]: 2017-10-09 14:15:02 139748708274752 [ERROR] WSREP: Only binlog_format = 'ROW' is currently supported. Configured value: 'MIXED'. Please adjust your configuratio

with WSREP_ON = off

I am agree if WSREP_ON = ON but with OFF it's should not bklock the start of MySQL server.



 Comments   
Comment by Elena Stepanova [ 2017-10-09 ]

Mixed format works just fine without Galera:

MariaDB [test]> select @@log_bin, @@binlog_format, @@wsrep_on, @@version;
+-----------+-----------------+------------+--------------------+
| @@log_bin | @@binlog_format | @@wsrep_on | @@version          |
+-----------+-----------------+------------+--------------------+
|         1 | MIXED           |          0 | 10.2.9-MariaDB-log |
+-----------+-----------------+------------+--------------------+
1 row in set (0.00 sec)

Is it possible that you have wsrep_provider set in your configuration, even though wsrep_on is turned off?

Comment by Aurélien LEQUOY [ 2017-10-09 ]

my goal was to have same configuration for all, but with wsrep_on = OFF and binlog_format = MIXED mysqd refuse to start.

but yes if you start mysqld with binlog_format = ROW and you switch to MIXED it's work fine.

after dunno about binlog_format = MIXED + wsrep_on = ON, if it's should work it's critical bug

Comment by Elena Stepanova [ 2017-10-09 ]

I didn't mean starting with ROW and switching to MIXED to be a workaround; but I think if you have wsrep_provider configured, even with wsrep_on=OFF on startup, it's not that crazy that the server assumes it is going to be used as a Galera node, and thus refuses to start in a non-supported configuration.

I'll leave it to anikitin and sachin.setiya.007 to decide on the subject.

Comment by Andrii Nikitin (Inactive) [ 2017-10-17 ]

I agree with Elena - even if instance is started with WSREP_ON=0 - the parameter still may be changed to 1 later and Galera must make sure that binlog_format configuration is suitable.
So configuration should avoid enabling any Galera-related parameters to make sure that similar checks aren't performed.

Comment by Aurélien LEQUOY [ 2017-10-17 ]

The goal we can change it online (have this configuration), so why to refuse it on start, it's not logical.

I am agree you have to refuse to restart in this case :
@@wsrep_on = 1
@@binlog_format = MIXED

(and should be easy to change in code)

Maybe you don't see the interest right now, but with my tools (PmaControl) it's usefull. Else it's imply for me to change my.cnf and restart mysql and it's should be not required.

Comment by Sergei Golubchik [ 2017-10-17 ]

I'd think that "assuming that wsrep_on will be enabled eventually" is a rather strange reason to disallow MIXED. If galera only supports ROW, then it should refuse to enable wsrep_on run-time when binlog format is MIXED. But as long as wsrep_on is disabled, binlog format should not matter.

Comment by Aurélien LEQUOY [ 2017-10-17 ]

I found this bug by luck, because normally i mostly use ROW in 99% but was a bug with spider (see https://jira.mariadb.org/browse/MDEV-14019) I discover this one

Comment by Andrii Nikitin (Inactive) [ 2017-10-18 ]

I agree with your reasoning thus I verify this report as requested.

Generated at Thu Feb 08 08:10:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.