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 Tavares Correia 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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.047 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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.