VPS侦探论坛

标题: 为何执行lnmp restart后出现如下错误? [打印本页]

作者: johnlou    时间: 2015-12-15 12:38
标题: 为何执行lnmp restart后出现如下错误?
军哥,我在安装Magento2.0的时候,由于进程问题,就执行了lnmp restart后。出现了mysql无法连接了。提示是什么PID找不到了。你的1.2和1.3我都试了,遇到同样的问题。
麻烦帮忙看看是什么原因? 谢谢。用的是腾讯云,服务器地址:182.254.129.193,可以看到相关配置。

错误日志:
2015-12-15 12:30:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-15 12:30:40 31503 [Warning] You need to use --log-bin to make --binlog-format work.
2015-12-15 12:30:40 31503 [Note] Plugin 'FEDERATED' is disabled.
2015-12-15 12:30:40 7f045f221740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-12-15 12:30:40 31503 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-12-15 12:30:40 31503 [Note] InnoDB: The InnoDB memory heap is disabled
2015-12-15 12:30:40 31503 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-15 12:30:40 31503 [Note] InnoDB: Memory barrier is not used
2015-12-15 12:30:40 31503 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-15 12:30:40 31503 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-15 12:30:40 31503 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-12-15 12:30:40 31503 [Note] InnoDB: Completed initialization of buffer pool
2015-12-15 12:30:40 31503 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-15 12:30:40 31503 [Note] InnoDB: 128 rollback segment(s) are active.
2015-12-15 12:30:40 31503 [Note] InnoDB: Waiting for purge to start
2015-12-15 12:30:40 31503 [Note] InnoDB: 5.6.23 started; log sequence number 27926842
2015-12-15 12:30:40 31503 [Note] Server hostname (bind-address): '*'; port: 3306
2015-12-15 12:30:40 31503 [Note] IPv6 is available.
2015-12-15 12:30:40 31503 [Note]   - '::' resolves to '::';
2015-12-15 12:30:40 31503 [Note] Server socket created on IP: '::'.
2015-12-15 12:30:40 31503 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql[img]file:///C:\Users\qlou\AppData\Local\Temp\[LC3U)F{0XCAB)LKNIT0K@G.gif[/img]ar/VM_88_116_centos.pid' (Errcode: 28 - No space left on device)
2015-12-15 12:30:40 31503 [ERROR] Can't start server: can't create PID file: No space left on device
151215 12:30:40 mysqld_safe Number of processes running now: 0
151215 12:30:40 mysqld_safe mysqld restarted

[ 本帖最后由 johnlou 于 2015-12-15 12:40 编辑 ]
作者: licess    时间: 2015-12-15 13:04
标题: 回复 1# 的帖子
日志里已经说了
[ERROR] Can't start server: can't create PID file: No space left on device

可能当前分区或硬盘磁盘已满
作者: johnlou    时间: 2015-12-15 13:56
标题: 回复 2# 的帖子
100g的磁盘怎么可能满了呢,肯定是哪出问题了。
作者: johnlou    时间: 2015-12-15 14:48
标题: 回复 2# 的帖子
而且这提示好像是说从我备份的PID上传后的提升,这个PID是我开始备份后上传后的提示。
我执行lnmp restrart后就无法连接mysql了。
作者: licess    时间: 2015-12-15 16:08
标题: 回复 4# 的帖子
pid就只是个pid影响不到mysql的运行,pid文件你删掉mysql照样运行,pid本来就是mysql控制生成的仅仅是来存pid号的

你说你磁盘100G,这也不一定有关系,你磁盘1000G但挂载的 /usr 分区上只有100MB一样是2楼我说的分区或磁盘不足的现象
你df -h看一下占用情况




欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/) Powered by Discuz! X3.4