| Bug #44663 | Unused replication options prevent server from starting. | ||
|---|---|---|---|
| Submitted: | 5 May 2009 10:57 | Modified: | 12 Nov 2009 14:44 |
| Reporter: | Luis Soares | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.1, 6.0 bzr | OS: | Any |
| Assigned to: | Alfranio Junior | CPU Architecture: | Any |
| Tags: | option dependency, server startup abort | ||
[5 May 2009 11:32]
Sveta Smirnova
Thank you for the report. Verified as described.
[12 Jun 2009 2:00]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/76153 2914 Alfranio Correia 2009-06-12 BUG#44663 Unused replication options prevent server from starting. The use of option log_slave_updates without log_bin was preventing the server from starting. To fix the problem, we replaced the error message and the exit call by a warning message.
[3 Jul 2009 19:19]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/77940 2914 Alfranio Correia 2009-07-03 BUG#44663 Unused replication options prevent server from starting. The use of option log_slave_updates without log_bin was preventing the server from starting. To fix the problem, we replaced the error message and the exit call by a warning message.
[8 Jul 2009 1:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/78178 3440 Alfranio Correia 2009-07-08 BUG#44663 Unused replication options prevent server from starting. The use of option log_slave_updates without log_bin was preventing the server from starting. To fix the problem, we replaced the error message and the exit call by a warning message.
[10 Jul 2009 11:20]
Bugs System
Pushed into 5.4.4-alpha (revid:anozdrin@bk-internal.mysql.com-20090710111017-bnh2cau84ug1hvei) (version source revid:alfranio.correia@sun.com-20090709225859-kri2kkweytz6zex0) (merge vers: 5.4.4-alpha) (pib:11)
[13 Jul 2009 12:05]
Jon Stephens
Documented bugfix in the 5.4.4 changelog as follows:
The server failed to start when using the --log_slave_updates
option without also using the --log_bin option. Now in such
cases, only a warning message is generated.
[12 Aug 2009 22:00]
Paul DuBois
Noted in 5.4.2 changelog because next 5.4 version will be 5.4.2 and not 5.4.4.
[14 Aug 2009 22:51]
Paul DuBois
Ignore previous comment about 5.4.2.
[29 Sep 2009 13:39]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/85009 3114 Alfranio Correia 2009-09-29 BUG#44663 Unused replication options prevent server from starting. NOTE: Backporting the patch to next-mr. The use of option log_slave_updates without log_bin was preventing the server from starting. To fix the problem, we replaced the error message and the exit call by a warning message.
[27 Oct 2009 9:48]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091027094604-9p7kplu1vd2cvcju) (version source revid:zhenxing.he@sun.com-20091026140226-uhnqejkyqx1aeilc) (merge vers: 6.0.14-alpha) (pib:13)
[28 Oct 2009 6:32]
Jon Stephens
Also documented in the 6.0.14 changelog. Closed.
[12 Nov 2009 8:18]
Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:alik@sun.com-20091027095744-rf45u3x3q5d1f5y0) (merge vers: 5.5.0-beta) (pib:13)
[12 Nov 2009 14:44]
Jon Stephens
Also documented in the 5.5.0 changelog; closed.
Description: There are some options that if set, prevent the server from starting, because they depend on other options that are not set. For example, "log-slave-updates", depends on "log-bin". Searching in mysqld.cc I find: if (opt_log_slave_updates && !opt_bin_log) { sql_print_error("You need to use --log-bin to make " "--log-slave-updates work."); unireg_abort(1); } The same happens with "binlog-format" which prevents the server from starting if "log-bin" is not set. However, this was already reported in BUG#42928. How to repeat: Inspect the code, or start server with --log-slave-updates without --log-bin enabled. Suggested fix: Maybe, printout a warning instead of an error and let the server proceed with startup.