当前位置: 首页 >> MySQL >> 【排错】MySQL无法启动--error: 11 >> 正文

【排错】MySQL无法启动--error: 11

6年前 (2018-05-05)     作者:Jiaozn     分类:MySQL     阅读次数:4058     评论(0)    

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.

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.

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


上午的时候启动MySQL的时候这种错误,

启动命令: ./mysqld_safe --defaults-file=/..../my.cnf  --user=mysql &

显示的结果是启动正常,,

ps aux|grepmysqld

显示已启动的服务也是正常的,

service mysql restart 的时候无法正常关闭,当然也无法重启,查看错误errorlog,出现上面的错误信息,,


解决方法--此错误信息是由于你的磁盘空间不足导致在mysql启动的时候无法正常的读写你data中的表的数据,df -h 使用此命令查看你磁盘空间,一瞥便知,删除多余文件,启动正常。


所述问题技术知识涵盖不深,只愿帮你解决MySQL疑难杂症。\(^o^)/~


除非注明,发表在“Jiaozn的博客”的文章『【排错】MySQL无法启动--error: 11』版权归Jiaozn所有。 转载请注明出处为“本文转载于『Jiaozn的博客』原地址https://www.jiaozn.com/reed/325.html
0

评论

发表评论   

昵称*

E-mail*(建议输入,以便收到博主回复的提示邮件)

网站

分享:

支付宝

微信