mysql 无法启动的原因Can't start server: can't create PID file: No space left on device
Posted on 2017-01-17 15:46 爱编程的欧巴 阅读(1663) 评论(0) 编辑 收藏 举报一大早来到公司,看到了一个噩梦,后台总是登录不上,登录就出错,还以为被黑客入侵了。经过1个小时的排错原因如下:
我的服务器是linux的,mysql的报错日志路径是/var/log/,经过查看日志发现错误信息为:
Can't start server: can't create PID file: No space left on device
120321 14:23:54 InnoDB: 1.1.8 started; log sequence number 1595695
120321 14:23:54 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld/mysqld.pid' (Errcode: 28)
120321 14:23:54 [ERROR] Can't start server: can't create PID file: No space left on device
120321 14:23:54 mysqld_safe Number of processes running now: 0
120321 14:23:54 mysqld_safe mysqld restarted
120321 14:23:54 [Note] Plugin ‘FEDERATED' is disabled.
120321 14:23:54 InnoDB: The InnoDB memory heap is disabled
120321 14:23:54 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120321 14:23:54 InnoDB: Compressed tables use zlib 1.2.3
120321 14:23:54 InnoDB: Using Linux native AIO
120321 14:23:54 InnoDB: Initializing buffer pool, size = 128.0M
120321 14:23:54 InnoDB: Completed initialization of buffer pool
120321 14:23:54 InnoDB: highest supported file format is Barracuda.
120321 14:23:55 InnoDB: Waiting for the background threads to start
这个错误。
提示磁盘空间不足
后用df -h 命令查看
我的是mysql的日志占用太多
我把mysql的日志删除掉
service mysqld start
重新启动mysql服务就好了
因为马上过年要回家了,虚惊一场,吓死宝宝了。
相关问题链接:http://www.jb51.net/article/66449.htm
作者:候鸟 出处:http://www.cnblogs.com/swite/ 本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。 如果文中有什么错误,欢迎指出。以免更多的人被误导。 |