Bug #83081 starting or stopping an MySQL instance 8.0.0.0 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:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:8.0.0.0 OS:CentOS (6.5)
Assigned to: CPU Architecture:Any
Tags: mysqld_multi

[21 Sep 2016 13:45] Saïd Mendi
Description:
In a multi-instance environment, using mysqld_multi does not work. You can't start again after having stopped your MySQL 8.0.0.0 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] Miguel Solorzano
Thank you for the bug report.

https://dev.mysql.com/doc/refman/8.0/en/mysqld-multi.html

Note

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