Ubuntu下mysql无法重启

最新推荐文章于 2023-12-21 22:50:56 发布

epsilon1

最新推荐文章于 2023-12-21 22:50:56 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL Ubuntu 文章标签： ubuntu mysql

本文链接：https://blog.csdn.net/qq_20480611/article/details/49008341

Ubuntu 同时被 2 个专栏收录

46 篇文章

订阅专栏

MySQL

16 篇文章

订阅专栏

本文介绍了解决MySQL启动过程中出现的因资源暂时不可用导致的错误。通过检查是否有其他mysqld进程正在使用相同的InnoDB数据文件，并展示了如何查找并终止冲突的进程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误日志：

$ tail -n 100 /var/log/mysql/error.log | head -n 20 #或者 tail -n 20 /var/log/mysql/error.log

最近的错误信息：

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
151009 21:54:03 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
151009 21:54:03 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at

错误已经很明确了：存在其它的mysql数据库服务进程