点击蓝色“DevOps架构实战”关注我哟
分享到“朋友圈”，每天上午 07:30，干货推送！
2021-11-24T10:40:09.891923+08:00 1 [ERROR] [MY-012574] [InnoDB] Unable to lock /data/mysql/mysql/ibdata1 error: 11
2021-11-24T10:40:10.892190+08:00 1 [ERROR] [MY-012574] [InnoDB] Unable to lock /data/mysql/mysql/ibdata1 error: 11
2021-11-24T10:40:11.893713+08:00 1 [ERROR] [MY-012574] [InnoDB] Unable to lock /data/mysql/mysql/ibdata1 error: 11
2021-11-24T10:40:12.893963+08:00 1 [ERROR] [MY-012574] [InnoDB] Unable to lock /data/mysql/mysql/ibdata1 error: 11
2021-11-24T10:40:12.894085+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 11 in a file operation.
2021-11-24T10:40:12.894125+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 11 means 'Resource temporarily unavailable'
2021-11-24T10:40:12.894269+08:00 1 [ERROR] [MY-012215] [InnoDB] Cannot open datafile '/data/mysql/mysql/ibdata1'
2021-11-24T10:40:12.894329+08:00 1 [ERROR] [MY-012959] [InnoDB] Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2021-11-24T10:40:12.894371+08:00 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Cannot open a file.
2021-11-24T10:40:13.393416+08:00 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2021-11-24T10:40:13.393718+08:00 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-11-24T10:40:13.395005+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2021-11-24T10:40:13.397981+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[root@mha logs]# /etc/init.d/mysqld start
Starting MySQL........................................................................................................ ERROR! The server quit without updating PID file (/data/mysql/mysql/mha.pid).
[root@mha tmp]# ll
total 8
srwxrwxrwx 1 mysql mysql 0 Nov 24 10:45 mysql.sock
-rw------- 1 mysql mysql 6 Nov 24 10:45 mysql.sock.lock
srwxrwxrwx 1 mysql mysql 0 Nov 24 10:45 mysqlx.sock
-rw------- 1 mysql mysql 7 Nov 24 10:45 mysqlx.sock.lock
drwx------ 3 root root 17 Oct 30 09:04 systemd-private-a34423ea97f6474fb9cd36bc7e981b87-chronyd.service-GFOMFZ
[root@mha tmp]# rm -rf mysql.sock.lock
[root@mha tmp]# rm -rf mysqlx.sock.lock
[root@mha tmp]# /etc/init.d/mysqld start
Starting MySQL..... SUCCESS!
