wsrep_check_opts doesn't check for default values
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
Confirmed
|
Low
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
As discussed in https:/
For example, binlog_format is STATEMENT by default. So, if it is not set in my.cnf, it doesn't fail, only when it is explicitly set it fails.
============
sudo /pxc/bin/mysqld --defaults-
131022 19:29:24 [Warning] WSREP: wsrep_sst_
131022 19:29:24 [ERROR] WSREP: Only binlog_format = 'ROW' is currently supported. Configured value: 'MIXED'. Please adjust your configuration.
131022 19:29:24 [ERROR] Aborting
=======
So, it needs to be either fixed to check for default values or the default have to be adjusted appropriately. Latter is simpler but may break compatibility with mysql.
Changed in codership-mysql: | |
importance: | Undecided → Low |
status: | New → Confirmed |
Also, even though it may be fine to set defaults, it may be problematic when that pxc node is used as an async slave or for any other purpose.
Specifically, following options:
"wsrep_ slave_threads" , "1" sst_receive_ address" ,"AUTO" cluster_ address" , "0" unsafe_ for_binlog" , "0" lock_mode" , "1"
"bind_address", "0.0.0.0"
"wsrep_sst_method", "rsync"
"wsrep_
"binlog_format", "ROW"
"wsrep_provider", "none"
"query_cache_type", "0"
"query_cache_size", "0"
"locked_in_memory", "0"
"wsrep_
"locks_
"autoinc_
Out of the above, the options with bad defaults are:
"binlog_format", (STATEMENT)
"query_cache_type", (1)
"autoinc_lock_mode" (1)
======= ======= ======= ======= ==
This should also avoid people crashing their nodes with bad
defaults and reporting bugs on that :) (seen many bugs with STMT
binlog_format).