Failed to open log (file '/data1/mysql/log/mysql-bin.001618', errno 2)
来源:互联网 发布:微信矩阵营销 编辑:程序博客网 时间:2024/06/05 12:50
由于数据库的不正常关机导致数据库无法启动
ps -ef|grep mysql
里面没有mysql的任何进程信息
service mysqld start 报错
错误1: mysql目录下面的tmp目录不见了
错误2:
然后在alter日志里面发现以下错误信息:
121016 19:16:19 InnoDB: The InnoDB memory heap is disabled
121016 19:16:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121016 19:16:19 InnoDB: Compressed tables use zlib 1.2.3
121016 19:16:19 InnoDB: Using Linux native AIO
121016 19:16:19 InnoDB: Initializing buffer pool, size = 10.0G
121016 19:16:20 InnoDB: Completed initialization of buffer pool
121016 19:16:20 InnoDB: highest supported file format is Barracuda.
121016 19:16:20 InnoDB: Waiting for the background threads to start
121016 19:16:21 Percona XtraDB (http://www.percona.com) 1.1.7-20.1 started; log sequence number 825493261848
/data1/mysql/bin/mysqld: File '/data1/mysql/log/mysql-bin.001618' not found (Errcode: 2)
121016 19:16:21 [ERROR] Failed to open log (file '/data1/mysql/log/mysql-bin.001618', errno 2)
121016 19:16:21 [ERROR] Could not open log file
121016 19:16:21 [ERROR] Can't init tc log
121016 19:16:21 [ERROR] Aborting
121016 19:16:21 InnoDB: Starting shutdown...
121016 19:16:26 InnoDB: Shutdown completed; log sequence number 825493261848
121016 19:16:26 [Note] /data1/mysql/bin/mysqld: Shutdown complete
解决办法:
1. 建立tmp目录
cd /data1/mysql/
mkdir tmp
chown -R mysql:mysql tmp
2. 进入/data1/mysql/log/
发现 并不存在mysql-bin.001618 这个日志文件
但是mysql-bin.index里面却有mysql-bin.001618的记录
办法是:
cp mysql-bin.index mysql-bin.index.bak
然后编辑mysql-bin.index 去掉 mysql-bin.001618 这一行数据
然后就能够正常的重启数据库了。
- Failed to open log (file '/data1/mysql/log/mysql-bin.001618', errno 2)
- Failed to open log (file './mysql-bin.000232', errno 2)
- MYSQL启动错误之[ERROR] Failed to open log (file './mysql-bin.000039', errno 2)
- MySql启动报错Failed to open log (file './mysql-bin.000232', errno 2)
- [ERROR] Failed to open log (file './mysql-bin.000009', errno 13)
- mysql(2)-bin-log
- MySQL Error: Failed to open the relay log
- mysql bin log 分析
- mysql bin-log日志
- Mysql log-bin 日志
- MySQL bin-log
- 查mysql bin-log
- mysql bin-log和log-update开启
- failed to open access log file D:\my11\taotao-manage-web\target\tomcat\logs\access.log
- 删除MYSQL BIN-LOG 日志
- 删除MYSQl BIN-LOG 日志
- 删除MYSQl BIN-LOG 日志
- 删除MYSQl BIN-LOG 日志
- Linux上的free命令详解
- STM32开源项目
- 判断素数
- GridView 全选功能
- SQL EXSITS的用法
- Failed to open log (file '/data1/mysql/log/mysql-bin.001618', errno 2)
- Typedef详解
- Guide: Uninstall Avira Free Antivirus
- AS3——Socket
- !!!Chapter 11 Generic Algorithms
- 如何识别高级的验证码
- 约瑟夫问题初探
- java 彻底理解 byte char short int float long double
- 何必伤情的伤感QQ心情日志发布:爱情,至少我挽留过