Bug #43876 mysqld_multi introduces --no-defaults which screws up my system
Submitted: 26 Mar 2009 7:24 Modified: 2 Jun 2009 16:14
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:6.0.10, 5.1.32, 5.0, 5.1, 6.0 bzr OS:Linux
Assigned to:
Triage: Triaged: D2 (Serious)

[26 Mar 2009 7:24] Oli Sennhauser
Description:
I have a multi instance set-up which I control with mysqld_mutli.

With the newest releases it does not work anymore because mysqld_multi introduces a --no-defaults which is IMHO wrong.

How to repeat:
A typical section looks like this:

[mysqld6010]

# must be at first position
defaults-file = /home/mysql/product/mysql-6.0.10/data/my.cnf
ledir         = /home/mysql/product/mysql-6.0.10/bin
mysqld        = /home/mysql/product/mysql-6.0.10/bin/mysqld_safe
mysqladmin    = /home/mysql/product/mysql-6.0.10/bin/mysqladmin
language      = /home/mysql/product/mysql-6.0.10/share/english

port          = 3310
socket        = /home/mysql/run/mysql-3310.sock
pid-file      = /home/mysql/run/mysql-3310.pid
datadir       = /home/mysql/product/mysql-6.0.10/data

I start a database like this:

mysqld_multi --config-file=/home/mysql/myenv/mysqld_multi.conf start 6010

The database is NOT started with the following error:

090326  8:08:54 [ERROR] /home/mysql/product/mysql-6.0.10/bin/mysqld: unknown variable 'defaults-file=/home/mysql/product/mysql-6.0.10/data/my.cnf'
090326  8:08:54 [ERROR] Aborting

The reason is that mysqld_multi introduces a --no-defaults in the beginning which was NOT done in older releases:

/home/mysql/product/mysql-6.0.10/bin/mysqld_safe --no-defaults --defaults-file=/home/mysql/product/mysql-6.0.10/data/my.cnf --ledir=/home/mysql/product/mysql-6.0.10/bin --language=/home/mysql/product/mysql-6.0.10/share/english --port=3310 --socket=/home/mysql/run/mysql-3310.sock --pid-file=/home/mysql/run/mysql-3310.pid --datadir=/home/mysql/product/mysql-6.0.10/data &

When run WITHOUT --no-defaults as before it works!

shell> diff mysql-6.0.8/bin/mysqld_multi mysql-6.0.10/bin/mysqld_multi
295a296
>     # Defaults are made explicit parameters to server execution...
296a298,301
>     # ...so server MUST NOT try to read again from some config file, especially
>     # as the "right" file may be unknown to the server if we are using
>     # --defaults-file=... params in here.
>     unshift(@options,"--no-defaults");

Suggested fix:
Revert this change or think on something new.
[26 Mar 2009 8:04] Sveta Smirnova
Thank you for the report.

Verified as described.
[2 Apr 2009 15:31] 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/71216

2725 Chad MILLER	2009-04-02
      Bug#43876: mysqld_multi introduces --no-defaults which screws up my system
      Bug#32136: mysqld_multi --defaults-file not respected while using \
      	--mysqld=mysqld_safe
      
      Revert change that adds "--no-defaults" to mysqld_multi.
      
      This closes Bug#43508 and re-opens Bug#32136.
[5 May 2009 18:52] Bugs System
Pushed into 5.0.82 (revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (version source revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (merge vers: 5.0.82) (pib:6)
[5 May 2009 19:40] Bugs System
Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[5 May 2009 19:42] Chad MILLER
Docs:  Please set this to "Verified" instead of "Closed."
[6 May 2009 14:12] Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:patrick.crews@sun.com-20090402223909-o6cpilqfrc0wj5e6) (merge vers: 6.0.11-alpha) (pib:6)
[2 Jun 2009 16:14] Paul Dubois
Noted in 5.0.82, 5.1.35, 6.0.12 changelogs.

mysqld_multi incorrectly passed --no-defaults to mysqld_safe.
[15 Jun 2009 8:27] Bugs System
Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)
[15 Jun 2009 9:07] Bugs System
Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)
[15 Jun 2009 9:48] Bugs System
Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)