MySQL Bugs: #43876: mysqld_multi introduces --no-defaults which screws up my system

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:		CPU Architecture:	Any

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.

Thank you for the report.

Verified as described.

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.

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)

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)

Docs:  Please set this to "Verified" instead of "Closed."

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)

Noted in 5.0.82, 5.1.35, 6.0.12 changelogs.

mysqld_multi incorrectly passed --no-defaults to mysqld_safe.

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)

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)

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)