宝塔:MySQL无法启动解决方案/www/server/mysql/bin/mysqld: Shutdown complete

宝塔:MySQL无法启动解决方案/www/server/mysql/bin/mysqld: Shutdown complete

宝塔:MySQL无法启动解决方案

/www/server/mysql/bin/mysqld: Shutdown complete

MySQL版本5.5。

故障现象:


MySQL无法启动,报错信息如下:

190228 9:19:43 [ERROR] Can't init tc log
190228 9:19:43 [ERROR] Aborting

190228 9:19:43 InnoDB: Starting shutdown...
190228 9:19:44 InnoDB: Shutdown completed; log sequence number 1595685
190228 9:19:44 [Note] /www/server/mysqi/bin/mysqld: Shutdown complete

190228 9:27:50 [Note] Plugin FEDERATED" is disabled.
190228 9:27:50 InnoDB: The InnoDB memory heap is disabled
190228 9:27:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190228 9:27:50 InnoDB: Compressed tables use zlib 1.2.3
190228 9:27:50 InnoDB: Using Linux native AIO
190228 9:27:50 InnoDB: Initializing buffer pool, size = 128.0M
190228 9:27:50 InnoDB: Completed initialization of buffer pool
190228 9:27:50 InnoDB: highest supported file format is Barracuda.
190228 9:27:51 InnoDB: Waiting for the background threads to start
190228 9:27:52 InnoDB: 5.5.61 started; log sequence number 1595685
/www/server/mysql/bin/mysqld: File './mysql-bin.000012' not found (Errcode: 2)
190228 9:27:52 [ERROR] Failed to open log (file ‘/mysql-ben.000012', ermo 2)
190228 9:27:52 [ERROR] Could not open log file
190228 9:27:52 [ERROR] Can't init tc log

190228 9:27:52 [ERROR] Aborting
190228 9:27:52 InnoDB: Starting shutdown...
190228 9:27:54 InnoDB: Shutdown completed; log sequence number 1595685
190228 9:27:54 [Note] /www/server/mysqi/bin/mysqld: Shutdown complete

故障原因:


MySQL日志文件找不到或者损坏。

解决方案:


SSH输入:

/etc/init.d/mysqld stop
rm -f /www/server/data/ib_logfile*
rm -f /www/server/data/mysql-bin.*
/etc/init.d/mysqld start

请务必线上支付,通过线下支付的出现任何问题平台均不担保!

相关推荐

数据库技术:mysql如何清理和关闭binlog日志?

binlog日志太大了,想要清理如何处理?关闭binlog修改my.cnf注释:lo...

宝塔面板怎么设置定时重启?

宝塔面板怎么设置定时重启呢?无论是linux还是windows均可设置!在宝塔菜单左...

【仿抖音短视频双端APP】2020最新直播系统+短视频双端源码[附详细安装搭建教程]

【仿抖音短视频双端APP】2020最新直播系统+短视频双端源码[附详细安装搭建教程]...

【原创干货】怎么样配置Linux服务器web环境?新手必备,8步搞定

为了制作本教程,芒果君在腾讯云租了一台服务器。腾讯云的优势:1.全面的腾讯系API接...

发表评论

登录... 后才能评论