VPS侦探论坛

 找回密码
 注册
查看: 3780|回复: 4

为何执行lnmp restart后出现如下错误?

[复制链接]
发表于 2015-12-15 12:38:36 | 显示全部楼层 |阅读模式

军哥,我在安装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 编辑 ]

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?注册

x
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2015-12-15 13:04:23 | 显示全部楼层

回复 1# 的帖子



日志里已经说了
[ERROR] Can't start server: can't create PID file: No space left on device

可能当前分区或硬盘磁盘已满
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2015-12-15 13:56:40 | 显示全部楼层

回复 2# 的帖子


100g的磁盘怎么可能满了呢,肯定是哪出问题了。
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2015-12-15 14:48:04 | 显示全部楼层

回复 2# 的帖子




而且这提示好像是说从我备份的PID上传后的提升,这个PID是我开始备份后上传后的提示。
我执行lnmp restrart后就无法连接mysql了。
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2015-12-15 16:08:56 | 显示全部楼层

回复 4# 的帖子


pid就只是个pid影响不到mysql的运行,pid文件你删掉mysql照样运行,pid本来就是mysql控制生成的仅仅是来存pid号的

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

军哥运维代购:http://shop63846532.taobao.com/

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-9-28 15:19 , Processed in 0.027257 second(s), 18 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表