为何执行lnmp restart后出现如下错误?
军哥,我在安装Magento2.0的时候,由于进程问题,就执行了lnmp restart后。出现了mysql无法连接了。提示是什么PID找不到了。你的1.2和1.3我都试了,遇到同样的问题。麻烦帮忙看看是什么原因? 谢谢。用的是腾讯云,服务器地址:182.254.129.193,可以看到相关配置。
错误日志:
2015-12-15 12:30:40 0 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 You need to use --log-bin to make --binlog-format work.
2015-12-15 12:30:40 31503 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 InnoDB: Using atomics to ref count buffer pool pages
2015-12-15 12:30:40 31503 InnoDB: The InnoDB memory heap is disabled
2015-12-15 12:30:40 31503 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-15 12:30:40 31503 InnoDB: Memory barrier is not used
2015-12-15 12:30:40 31503 InnoDB: Compressed tables use zlib 1.2.3
2015-12-15 12:30:40 31503 InnoDB: Not using CPU crc32 instructions
2015-12-15 12:30:40 31503 InnoDB: Initializing buffer pool, size = 16.0M
2015-12-15 12:30:40 31503 InnoDB: Completed initialization of buffer pool
2015-12-15 12:30:40 31503 InnoDB: Highest supported file format is Barracuda.
2015-12-15 12:30:40 31503 InnoDB: 128 rollback segment(s) are active.
2015-12-15 12:30:40 31503 InnoDB: Waiting for purge to start
2015-12-15 12:30:40 31503 InnoDB: 5.6.23 started; log sequence number 27926842
2015-12-15 12:30:40 31503 Server hostname (bind-address): '*'; port: 3306
2015-12-15 12:30:40 31503 IPv6 is available.
2015-12-15 12:30:40 31503 - '::' resolves to '::';
2015-12-15 12:30:40 31503 Server socket created on IP: '::'.
2015-12-15 12:30:40 31503 /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysqlfile:///C:\Users\qlou\AppData\Local\Temp\ar/VM_88_116_centos.pid' (Errcode: 28 - No space left on device)
2015-12-15 12:30:40 31503 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 编辑 ]
回复 1# 的帖子
日志里已经说了Can't start server: can't create PID file: No space left on device
可能当前分区或硬盘磁盘已满
回复 2# 的帖子
100g的磁盘怎么可能满了呢,肯定是哪出问题了。回复 2# 的帖子
而且这提示好像是说从我备份的PID上传后的提升,这个PID是我开始备份后上传后的提示。我执行lnmp restrart后就无法连接mysql了。
回复 4# 的帖子
pid就只是个pid影响不到mysql的运行,pid文件你删掉mysql照样运行,pid本来就是mysql控制生成的仅仅是来存pid号的你说你磁盘100G,这也不一定有关系,你磁盘1000G但挂载的 /usr 分区上只有100MB一样是2楼我说的分区或磁盘不足的现象
你df -h看一下占用情况
页:
[1]