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] MySQL Verification Team
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.