service mysqld start MySQL Daemon failed to start.
来源:互联网 发布:java输入输出流缓冲区 编辑:程序博客网 时间:2024/06/04 17:46
正常是MySQL开机自动启动的,可是这次没有启动;
使用 service mysqld start 启动时提示:MySQL Daemon failed to start.
正在启动 mysqld: [失败]
查看MySQL日志
vi /var/log/mysqld.log
:$移动到文件尾,发现如下错误:
2016-07-02T01:34:44.454839Z 0 [ERROR] InnoDB: Write to file ./ibtmp1failed at offset 0, 1048576 bytes should have been written, only 0 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2016-07-02T01:34:44.454863Z 0 [ERROR] InnoDB: Error number 28 means 'No space left on device'
2016-07-02T01:34:44.454909Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-07-02T01:34:44.454925Z 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
2016-07-02T01:34:44.454936Z 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
2016-07-02T01:34:44.454948Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2016-07-02T01:34:45.056320Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-07-02T01:34:45.056344Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-02T01:34:45.056354Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-07-02T01:34:45.056364Z 0 [ERROR] Failed to initialize plugins.
2016-07-02T01:34:45.056372Z 0 [ERROR] Aborting
其中注意到:'No space left on device',没有磁盘空间了;
删除了一部分没用的文件,然后再启动就可以了。
相关:
Navicat for MySQL出现1030-Got error 28 from storage engine错误
mysql无法启动ERROR! MySQL is running but PID file could not be found
- service mysqld start MySQL Daemon failed to start.
- mysqld daemon start failed
- MySQL Daemon failed to start
- MySQL Daemon failed to start
- MySQL Daemon failed to start.
- [mysql]MySQL Daemon failed to start
- failed to start daemon
- * failed to start daemon *
- MySQL Daemon failed to start 解决
- mysql daemon failed to start 解决办法
- MySQL Daemon failed to start解决方法
- MySQL Daemon failed to start. 无法启动
- * failed to start daemon *解决方法
- linux mysql无法启动(Redirecting to /bin/systemctl start mysqld.service Failed to issue method call: U)
- MySQL Daemon failed to start (mysql 版本为 5.1.)
- mysql5.6 安装启动失败 MySQL Daemon failed to start
- mysql启动方式:service mysqld start
- mysql failed to start
- 无向图(Undigraph)
- 1011. World Cup Betting (20)
- LeTao的popoverPresentationController
- 4.3.函数指针
- 第三方支付架构设计之—帐户体系
- service mysqld start MySQL Daemon failed to start.
- 线性表的链式存储
- 图的连通性问题之连通和最小环
- WEBRTC 媒体引擎MediaEngine
- Spring MVC请求处理流程及架构
- linux常用命令3
- Java-类库-Guava-Multimap
- osx + Intellij + mysql + jsp + tomcat 之java web项目-网上书店 (上) (mysql的配置)
- linux 如何显示一个文件的某几行(中间几行)