MySQL Bugs: #83081: starting or stopping an MySQL instance 8.0.0.0 does not work

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

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 &

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”.

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