| Bug #75025 | --log_timestamps=UTC needs --log-bin | ||
|---|---|---|---|
| Submitted: | 27 Nov 2014 14:35 | Modified: | 16 Jan 2015 15:38 |
| Reporter: | Sven Sandberg | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Logging | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[16 Jan 2015 15:38]
Paul DuBois
Noted in 5.7.6 changelog. Enabling the log_timestamps system variable incorrectly required binary logging to be enabled.
Description: When --log_timestamps=UTC is used, and log-bin is not used, the server prints this warning message: You need to use --log-bin to make --binlog-format work. How to repeat: mysql-test/t/bug-master.opt: --log_timestamps=UTC mysql-test/t/bug.test: SELECT 1; Suggested fix: diff --git a/sql/sys_vars.cc b/sql/sys_vars.cc index c4dfad8..761b915 100644 --- a/sql/sys_vars.cc +++ b/sql/sys_vars.cc @@ -1819,7 +1819,7 @@ static Sys_var_enum Sys_log_timestamps( "This affects only log files, not log tables, as the timestamp columns " "of the latter can be converted at will.", GLOBAL_VAR(opt_log_timestamps), - CMD_LINE(REQUIRED_ARG, OPT_BINLOG_FORMAT), + CMD_LINE(REQUIRED_ARG), timestamp_type_names, DEFAULT(0), NO_MUTEX_GUARD, NOT_IN_BINLOG);