Bug #71222 | Incorrect error message of relay_log_basename without relay-log | ||
---|---|---|---|
Submitted: | 24 Dec 2013 10:33 | Modified: | 25 Dec 2013 11:37 |
Reporter: | Tsubasa Tanaka (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.6.15 | OS: | Linux (CentOS 6.3) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Docs |
[24 Dec 2013 10:33]
Tsubasa Tanaka
[24 Dec 2013 12:18]
Peter Laursen
The variables exist on my 5.6.15 server (64 bit) running on Win7/64 (even though empty as binlog is not enabled and it is not a slave): SHOW VARIABLES LIKE '%basename' /* returns Variable_name Value ------------------ -------- log_bin_basename relay_log_basename */ .. but I did not try to use same as options for startup. Peter (not a MySQL/Oracle person)
[24 Dec 2013 12:25]
Peter Laursen
Did you try to quote the file name? $ bin/mysqld_safe --no-defaults --log-bin-basename='test'
[24 Dec 2013 14:51]
Tsubasa Tanaka
Hi, I tried with quoted file name, but it doesn't work. $ bin/mysqld_safe --no-defaults --log-bin-basename="/tmp/test" & .. 2013-12-24 23:49:17 18508 [ERROR] /usr/mysql/5.6.15/bin/mysqld: unknown variable 'log-bin-basename=/tmp/test' And I realized that I can't see log-bin-basename valiable in mysqld's usage. $ bin/mysqld --help --verbose | grep basename 2013-12-24 23:50:44 18542 [Note] Binlog end 2013-12-24 23:50:44 18542 [Note] Shutting down plugin 'CSV' 2013-12-24 23:50:44 18542 [Note] Shutting down plugin 'MyISAM'
[24 Dec 2013 14:53]
Tsubasa Tanaka
And I can see those variables in SHOW GLOBAL VARIABLES. mysql56> SELECT @@version; +------------------+ | @@version | +------------------+ | 5.6.15-debug-log | +------------------+ 1 row in set (0.00 sec) mysql56> show global variables like '%basename'; +--------------------+------------------------------+ | Variable_name | Value | +--------------------+------------------------------+ | log_bin_basename | /usr/mysql/5.6.15/data/bin | | relay_log_basename | /usr/mysql/5.6.15/data/relay | +--------------------+------------------------------+ 2 rows in set (0.02 sec)
[24 Dec 2013 17:00]
Sveta Smirnova
Thank you for the report. Regarding to log_bin_basename: this variable set by passing option to parameter log_bin and can not be used both as command line parameter and in the option file. See http://dev.mysql.com/doc/refman/5.6/en/mysqld-option-tables.html and read carefully link you provided. Same rule applies to relay_log_basename: see http://dev.mysql.com/doc/refman/5.6/en/mysqld-option-tables.html
[25 Dec 2013 7:16]
Tsubasa Tanaka
Hi, Thank you for your suggest. I have read the docs again, but I still have two point. o- Incorrect error message when I give log_bin_basename, relay_log_basename without log_bin, relay_log option(Non-Critical) It should not return "unknown variable", I hope that message get to be "You need to use --log-bin to make --log-bin-basename work.", like when I give --binlog-format without --log-bin to mysqld. o- Please update the docs more in detail(Feature Request) I can't see relay_log_basename needs relay_log, because I can make my server to be replication slave, even if I don't give relay_log option to mysqld. I changed Synopsis. Thanks,
[25 Dec 2013 11:37]
Sveta Smirnova
Thank you for the feedback. I agree: documentation can be more clearer.
[16 Jan 2014 15:34]
Jon Stephens
Let's fix the software issue, first.