mysql重装出错InnoDB: Unable to lock ./ibdata1, error: 11
来源:互联网 发布:淘宝联盟怎么下单 编辑:程序博客网 时间:2024/05/16 14:15
Centos6.2系统自带的Mysql版本较低,卸载掉再重装一个最新的。
下载并安装以下包
MySQL-client-5.5.25-1.el6.i686.rpm
MySQL-devel-5.5.25-1.el6.i686.rpm(含mysql_config)
MySQL-server-5.5.25-1.el6.i686.rpm
MySQL-shared-5.5.25-1.el6.i686.rpm
MySQL-shared-compat-5.5.25-1.el6.i686.rpm
安装成功后
启动mysql,使用
#service mysql start显示Starting MySQL SUCCESS!
使用ps命令查看进程情况
#ps -ef | grep mysqlroot 2853 1 0 09:03 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/python.centos.pidmysql 3105 2853 0 09:03 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql--log-error=/var/lib/mysql/python.centos.err --pid-file=/var/lib/mysql/python.centos.pid --socket=/var/lib/mysql/mysql.sock --port=3306root 4163 1 0 09:17 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/python.centos.pidmysql 4416 4163 1 09:17 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/python.centos.err --pid-file=/var/lib/mysql/python.centos.pid --socket=/var/lib/mysql/mysql.sock --port=3306mysql写错误日志,python.centos是我的机器名。两个时间,可能是我运行了两次。
从shell进入mysql
# mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)结束mysql服务
#service mysql stopERROR! MySQL server PID file could not be found!查看/var/lib/mysql/python.centos.err错误日志
120706 09:17:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql120706 9:17:59 [Note] Plugin 'FEDERATED' is disabled.120706 9:17:59 InnoDB: The InnoDB memory heap is disabled120706 9:17:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins120706 9:17:59 InnoDB: Compressed tables use zlib 1.2.3120706 9:17:59 InnoDB: Using Linux native AIO120706 9:17:59 InnoDB: Initializing buffer pool, size = 128.0M120706 9:17:59 InnoDB: Completed initialization of buffer poolInnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Check that you do not already have another mysqld processInnoDB: using the same InnoDB data or log files.120706 9:17:59 InnoDB: Retrying to lock the first data fileInnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Check that you do not already have another mysqld process... ... ... ... ... ... ...
InnoDB: Check that you do not already have another mysqld processInnoDB: using the same InnoDB data or log files.InnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Check that you do not already have another mysqld processInnoDB: using the same InnoDB data or log files.120706 9:19:40 InnoDB: Unable to open the first data fileInnoDB: Error in opening ./ibdata1120706 9:19:40 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 atInnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html120706 9:19:40 InnoDB: Could not open or create data files.120706 9:19:40 InnoDB: If you tried to add new data files, and it failed here,120706 9:19:40 InnoDB: you should now edit innodb_data_file_path in my.cnf back120706 9:19:40 InnoDB: to what it was, and remove the new ibdata files InnoDB created120706 9:19:40 InnoDB: in this failed attempt. InnoDB only wrote those files full of120706 9:19:40 InnoDB: zeros, but did not yet use them in any way. But be careful: do not120706 9:19:40 InnoDB: remove old data files which contain your precious data!120706 9:19:40 [ERROR] Plugin 'InnoDB' init function returned error.120706 9:19:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.120706 9:19:40 [ERROR] Unknown/unsupported storage engine: InnoDB120706 9:19:40 [ERROR] Aborting120706 9:19:40 [Note] /usr/sbin/mysqld: Shutdown complete120706 09:19:40 mysqld_safe mysqld from pid file /var/lib/mysql/python.centos.pid ended查找InnoDB: Unable to lock ./ibdata1, error: 11的解决方法
http://cglreport.zhenhua.info/2008/08/mysql-error-unable-to-lock-ibdata1.html
Solution:
make a copy of the original files (ibdata1, ib_logfile0, ib_logfile1...).
mv ibdata1 ibdata1.bak
cp -a ibdata1.bak ibdata1
......
操作:
先查看/var/lib/mysql目录下的文件
# cd /var/lib/mysql/# lltotal 28812-rw-rwxr-x. 1 mysql mysql 18874368 Jul 4 17:30 ibdata1-rw-rwxr-x. 1 mysql mysql 5242880 Jul 6 09:03 ib_logfile0-rw-rwxr-x. 1 mysql mysql 5242880 Jun 14 15:48 ib_logfile1drwxr-xr-x. 2 mysql mysql 4096 Jun 14 14:39 mysql-rw-rw----. 1 mysql mysql 107 Jul 6 09:03 mysql-bin.000001-rw-rwxr-x. 1 mysql mysql 19 Jul 6 09:03 mysql-bin.indexdrwxr-xr-x. 2 mysql mysql 4096 Jun 14 14:39 performance_schema-rw-rwxr-x. 1 mysql root 108068 Jul 6 09:19 python.centos.err-rw-r-xr-x. 1 root root 329 Jun 14 15:47 RPM_UPGRADE_HISTORY-rw-r-xr-x. 1 mysql mysql 329 Jun 14 15:47 RPM_UPGRADE_MARKER-LAST-rw-r-xr-x. 1 root root 0 Jul 5 16:56 -Sdrwxr-xr-x. 2 mysql mysql 4096 Jun 14 16:06 test上面三个文件ibdata1、ib_logfile0、ib_logfile1都是属于mysql用户的。
切换到mysql用户再进行操作
# su mysqlbash-4.1$ pwd/var/lib/mysql确认当前在/var/lib/mysql目录下,执行
bash-4.1$ mv ibdata1 ibdata1.bakbash-4.1$ cp -a ibdata1.bak ibdata1bash-4.1$ mv ib_logfile0 ib_logfile0.bakbash-4.1$ cp -a ib_logfile0.bak ib_logfile0bash-4.1$ mv ib_logfile1 ib_logfile1.bakbash-4.1$ cp -a ib_logfile1.bak ib_logfile1bash-4.1$ exit退出mysql用户,使用lsof查找mysql进程并杀掉,重启mysql服务
# lsof -i:3306COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 3105 mysql 11u IPv4 15743 0t0 TCP *:mysql (LISTEN)# kill -9 3105# service mysql startStarting MySQL.. SUCCESS!进入mysql
# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.25-log MySQL Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.10 sec)将mysql添加到自动启动
/sbin/chkconfig --level 35 mysql on成功解决。对于错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)的讨论:
http://www.iteye.com/topic/149100
http://cglreport.zhenhua.info/2008/08/mysql-error-unable-to-lock-ibdata1.html
- mysql重装出错InnoDB: Unable to lock ./ibdata1, error: 11
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
- mysql InnoDB: Unable to lock ./ibdata1, error: 11
- mysql Unable to lock ./ibdata1, error: 11
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
- InnoDB: Unable to lock ibdata1, error: 35
- mysql集群 之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
- mysql_install_db出错,Unable to lock /usr/local/mysql/var/ibdata1, error: 11
- 数据库的问题:InnoDB: Unable to lock ./ibdata1, error: 37
- InnoDB: Error: unable to create temporary file
- Mysql启动错误:“InnoDB: Error: unable to create temporary file”的解决方法
- InnoDB: Error in opening ./ibdata1 问题重现
- [ERROR] InnoDB: Data file /data/mysql/3310/data/ibdata1 is of a different size 1536 pages
- mysql的innodb扩容、ibdata1 瘦身
- mysql重装时报错:last error unable to update security settings. access denied for user ‘root’ @ ‘localh
- 968 InnoDB: Error: unable to create temporary file; errno: 2
- InnoDB: Error: unable to create temporary file; errno: 13
- 打补丁报错Opatch error : "Unable to lock Central Inventory
- 你必须学会清洗电脑——提网速
- 常用设计模式收集
- JNDI配置数据库连接池
- 项目管理十日谈-浅谈成本管理
- 用户至上-阿里马马篇
- mysql重装出错InnoDB: Unable to lock ./ibdata1, error: 11
- PostGis入门知识
- 横向滚动和竖直滚动结合,scrollview嵌套多个HorizontalScrollView
- 1174 最优序列
- 如何分析看待ERP系统信息缺失
- win7下安装NET-SNMP
- 工厂类通用写法
- 图例
- hdoj 1150