Bug #83081 starting or stopping an MySQL instance does not work
Submitted: 21 Sep 2016 13:45 Modified: 22 Sep 2016 9:14
Reporter: Saïd Mendi Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version: OS:CentOS (6.5)
Assigned to: CPU Architecture:Any
Tags: mysqld_multi

[21 Sep 2016 13:45] Saïd Mendi
In a multi-instance environment, using mysqld_multi does not work. You can't start again after having stopped your MySQL instance with mysqld_multi.
OS> mysqld_multi start 9

following lines are in the mysqld9.err

2016-09-20T23:42:41.458805Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-09-20T23:42:41.466540Z 1 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-09-20T23:42:41.466562Z 1 [ERROR] InnoDB: The error means the system cannot find the path specified.
2016-09-20T23:42:41.466568Z 1 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2016-09-20T23:42:41.466574Z 1 [ERROR] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-09-20T23:42:41.466582Z 1 [ERROR] InnoDB: Cannot continue operation.

How to repeat:
everytime you stop your instance and you want to restart it with mysqld_multi.

Suggested fix:
As a temporary workaround, I start it manually.
I will need time to debug mysql_multi.
mysql@MYSQL:/u00/app/mysql/product/mysql-8.0.0/bin/ [mysqld9] /u00/app/mysql/product/mysql-8.0.0/bin/mysqld --port=33009 --socket=/u00/app/mysql/admin/mysqld9/socket/mysqld9.sock --pid-file=/u00/app/mysql/admin/mysqld9/socket/mysqld9.pid --log-error=/u00/app/mysql/admin/mysqld9/log/mysqld9.err --datadir=/u01/mysqldata/mysqld9 --basedir=/u00/app/mysql/product/mysql-8.0.0 --slow_query_log=1 --slow_query_log_file=/u00/app/mysql/admin/mysqld9/log/mysqld9-slow-query.log --log-bin=/u00/app/mysql/admin/mysqld9/binlog/mysqld9-bin --innodb_flush_log_at_trx_commit=1 --sync_binlog=1 --expire_logs_days=1 --local-infile=0 --general_log=1 --general_log_file=/u00/app/mysql/admin/mysqld9/log/mysqld9.log --server_id=9 --lc_messages_dir=/u00/app/mysql/product/mysql-8.0.0/share/ --lc_messages=en_US &
[22 Sep 2016 0:32] MySQL Verification Team
Thank you for the bug report.



For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_multi is no longer installed because it is unnecessary. For more information, see Section 2.5.9, “Managing MySQL Server with systemd”.
[22 Sep 2016 9:14] Saïd Mendi
Thank you for your reply but my installation ist not RPM based as I'm working in a multi-instances environment with 9 instances so your note does not help me