VPS侦探论坛

 找回密码
 注册
查看: 5446|回复: 1

[Oracle] MYSQL服务器无法启动

[复制链接]
发表于 2015-3-20 16:57:02 | 显示全部楼层 |阅读模式

错误日志如下,军哥,求救。折磨了一天了。150320 16:22:16  InnoDB: Starting shutdown...
150320 16:22:16  InnoDB: Shutdown completed; log sequence number 1595675
150320 16:22:16 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150320 16:22:16 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended
150320 16:23:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
150320 16:23:13 InnoDB: The InnoDB memory heap is disabled
150320 16:23:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 16:23:13 InnoDB: Compressed tables use zlib 1.2.8
150320 16:23:13 InnoDB: Initializing buffer pool, size = 16.0M
150320 16:23:13 InnoDB: Completed initialization of buffer pool
150320 16:23:13 InnoDB: highest supported file format is Barracuda.
150320 16:23:13  InnoDB: Waiting for the background threads to start
150320 16:23:14 InnoDB: 5.5.37 started; log sequence number 1595675
/usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:23:14 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:23:14 [ERROR] Could not open log file
150320 16:23:14 [ERROR] Can't init tc log
150320 16:23:14 [ERROR] Aborting

150320 16:23:14  InnoDB: Starting shutdown...
150320 16:23:15  InnoDB: Shutdown completed; log sequence number 1595675
150320 16:23:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150320 16:23:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended
150320 16:50:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
150320 16:50:51 InnoDB: The InnoDB memory heap is disabled
150320 16:50:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 16:50:51 InnoDB: Compressed tables use zlib 1.2.8
150320 16:50:51 InnoDB: Initializing buffer pool, size = 16.0M
150320 16:50:51 InnoDB: Completed initialization of buffer pool
150320 16:50:51 InnoDB: highest supported file format is Barracuda.
150320 16:50:51  InnoDB: Waiting for the background threads to start
150320 16:50:52 InnoDB: 5.5.37 started; log sequence number 1595675
/usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:50:52 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:50:52 [ERROR] Could not open log file
150320 16:50:52 [ERROR] Can't init tc log
150320 16:50:52 [ERROR] Aborting

150320 16:50:52  InnoDB: Starting shutdown...
150320 16:50:52  InnoDB: Shutdown completed; log sequence number 1595675
150320 16:50:52 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150320 16:50:52 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2015-3-20 21:20:16 | 显示全部楼层


/usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:50:52 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:50:52 [ERROR] Could not open log file

日志文件被非正常方法删除了,把其他的几个mysql-bin.00000*日志删除,然后清空一下mysql-bin.index文件,重启mysql应该就可以了
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-5-17 11:53 , Processed in 0.025626 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表