killall mysql服务 mysql服务后无法启动
Can”t init tc log Aborting |mysql事务日志导致启动失败问题,killall mysql进程后,mysql无法启动问题总汇;
问题1:
将mysql所有进程kill掉后,重启,无法启动,报错:
110303 14:01:45 InnoDB: Started; log sequence number 0 138710263 /usr/local/mysql/bin/mysqld: File ‘./mysql-bin.000041′ not found (Errcode: 13) 110303 14:01:45 [ERROR] Failed to open log (file ‘./mysql-bin.000041′, errno 13) 110303 14:01:45 [ERROR] Could not open log file 110303 14:01:45 [ERROR] Can’t init tc log 110303 14:01:45 [ERROR] Aborting
在mysql/data/目录下找到mysql-bin.000041文件,删掉,重启,仍不行,报错:
110303 14:04:07 InnoDB: Started; log sequence number 0 138710263 /usr/local/mysql/bin/mysqld: File ‘./mysql-bin.000041′ not found (Errcode: 2) 110303 14:04:07 [ERROR] Failed to open log (file ‘./mysql-bin.000041′, errno 2) 110303 14:04:07 [ERROR] Could not open log file 110303 14:04:07 [ERROR] Can’t init tc log 110303 14:04:07 [ERROR] Aborting
touch之,修改权限,重启,也不行,报错:
110303 14:05:41 InnoDB: Started; log sequence number 0 138710263 110303 14:05:41 [ERROR] I/O error reading the header from the binary log, errno=-1, io cache code=0 110303 14:05:41 [ERROR] I/O error reading the header from the binary log 110303 14:05:41 [ERROR] Can’t init tc log 110303 14:05:41 [ERROR] Aborting
最后解决办法:
将mysql/data/mysql-bin.index文件删除,重启mysql,会自动生成新的mysql-bin.index文件,启动成功
问题2:
启动后,报错:
InnoDB: Started; log sequence number 0 1004308157 110303 14:15:01 [Note] Recovering after a crash using mysql-bin 110303 14:15:01 [ERROR] Error in Log_event::read_log_event(): ‘read error’, data_len: 169, event_type: 2 110303 14:15:01 [Note] Starting crashrecovery… 110303 14:15:01 [Note] Crash recovery finished. /opt/31306/mysql/bin/mysqld: Disk is full writing ‘./mysql-bin.~rec~’ (Errcode: 28). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)
这是由于mysql-bin日志过多,进入mysql/data/目录,果断删除所有mysql-bin.*文件,重启,启动成功
问题3:
启动后,报错:
110303 14:21:37 InnoDB: Started; log sequence number 0 487312871 110303 14:21:37 [ERROR] Can’t start server: Bind on TCP/IP port: Address already in use 110303 14:21:37 [ERROR] Do you already have another mysqld server running on port: 43306 ? 110303 14:21:37 [ERROR] Aborting
按提示,应该是43306端口占用,但是查看后并未发现该端口被占用,不深究,果断将其my.cnf文件中的port修改成一个新的端口,重启,启动成功。关闭后,重新将my.cnf中的port改回为43306,重启,又可以成功启动了。
一、推荐使用迅雷或快车等多线程下载软件下载本站资源。
二、未登录会员无法下载,登录后可获得更多便利功能,若未注册,请先注册。
三、如果服务器暂不能下载请稍后重试!总是不能下载,请点我报错 ,谢谢合作!
四、本站大部分资源是网上搜集或私下交流学习之用,任何涉及商业盈利目的均不得使用,否则产生的一切后果将由您自己承担!本站将不对任何资源负法律责任.如果您发现本站有部分资源侵害了您的权益,请速与我们联系,我们将尽快处理.
五、如有其他问题,请加网站设计交流群(点击这里查看交流群 )进行交流。
六、如需转载本站资源,请注明转载来自并附带链接
七、本站部分资源为加密压缩文件,统一解压密码为:www.aizhanzhe.com
- 1CSS控制文字在Div最底部显示
- 2Thinkphp5如何配置IP+端口访问项目模块
- 3elementUI el-dialog弹框居中
- 4教你如何搭建及优化站点
- 5国内互联网视频行业运营分析
- 6service mysql start出错,mysql不能启动,解决mysql: unrecognized service错误
- 7CSS实现悬浮顶部的Div工具栏
- 8记一次Thinkphp5.1框架mysql数据库崩溃(SQLSTATE [08004] Too many connections)
- 9连接SQL Server数据库提示:Login failed for user 'sa'错误的解决方案
- 10Thinkphp3.2在centos7上设置计划任务的方法