MySQL中 InnoDB: Check that you do not already have another mysqld process 错误解决办法
来源:互联网 发布:株洲网络买花花店 编辑:程序博客网 时间:2024/06/15 18:37
mysqld_safe Starting mysqld daemon with databases from /export/mysql_data/var
170612 5:22:10 InnoDB: The InnoDB memory heap is disabled
170612 5:22:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170612 5:22:10 InnoDB: Compressed tables use zlib 1.2.3
170612 5:22:10 InnoDB: Initializing buffer pool, size = 16.0M
170612 5:22:10 InnoDB: Completed initialization of buffer pool
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.
170612 5:22:10 InnoDB: Retrying to lock the first data file
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
解决办法:
解决办法:
[root@DBA log]# ps -ef|grep mysql
root 11979 1 0 Jul11 ? 00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/opt/mysql/data --pid-file=/opt/mysql/data/dba.sky-mobi.com.hz.bj.pid
mysql 12742 11972 0 Jul11 ? 00:03:19 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/opt/mysql/lib/mysql/plugin --user=mysql --log-error=/opt/mysql/log/alert.log --open-files-limit=65535 --pid-file=/opt/mysql/data/dba.sky-mobi.com.hz.bj.pid --socket=/opt/mysql/run/mysql.sock --port=3306
root 29331 29081 0 15:48 pts/1 00:00:00 grep mysql
看到有其它进程占用了 mysql的data文件夹
最快的处理方法是 kill 掉这些进程之后 ,重新启动 mysql 正常启动
总结: 再启动mysql之前 先查看一下是否有其它的进程 占用mysql的数据文件
如果有则杀掉占用的进程 再启动mysql
阅读全文
1 0
- MySQL中 InnoDB: Check that you do not already have another mysqld process 错误解决办法
- InnoDB: Check that you do not already have another mysqld process 错误解决办法
- Check that you do not already have another mysqld process
- 【mysql异常】 InnoDB: Check that you do not already have another mysqld process using the same InnoDB da
- mysqld启动“ Can't start server: Bind on TCP/IP port: Address already in use Do you already have anothe
- mysql提示错误#42000You have an error in your SQL syntax; check the manual that corresponds
- 解决You have an error in your SQL syntax; check the manual that corresponds to your MySQL server错误
- 1064 - You have an error in your SQL syntax; check the manual that correspon解决办法
- git push updates were rejected because the remote contain works that you do not have
- Could not open Selected VM debug port (8700). Make sure you do not have another instance of DDMS or
- Could not open Selected VM debug port (8700). Make sure you do not have another instance of DDMS or
- 创建存储过程错误(已解决):Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ver
- Hibernate操作MySQL使用reserved word引发错误: “You have an error in your SQL syntax; check the manual that co
- ubuntu the folder contents could not be display ,you do not have the permission(解决办法)
- “you do not have permissions to run”
- ssh开发中插入数据时遇到 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
- 奇怪的错误:This generally means that another instance of this process was already running or is hung in t
- MySql-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
- selenium2java如何关闭上传弹框问题的解决办法
- typedef struct 和 struct的区别
- 深入理解PHP内核(一):生命周期和zend引擎
- 学习笔记
- pageContext、request、session和application区别
- MySQL中 InnoDB: Check that you do not already have another mysqld process 错误解决办法
- 检测系统(linux/window)的各种数据类型所占字节数
- C# VS中进行编译发现没有错误但是无法生成的原因
- JS判断是否手机或移动端访问
- 7大不跳槽就会死的理由!
- PHPEXCEL导入数据库,执行到load导致系统崩溃问题
- 如何修改Maven的引用路径
- 作为前端,你会选择哪种格式的图片
- const 限定符总结