产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[求助帖] [已经解决!]急啊 求助啊~~!请大神给分析下日志~!

xiaomayi2012
铜牌会员
947.65 价值分

xiaomayi2012 发表于 2014-11-23 11:55:07
本帖最后由 xiaomayi2012 于 2014-11-23 14:30 编辑

自己网站用的linode vps 4.2面板 今天突然前台显示502 进入AMH后台输入正确的验证码光提示错误~!进入linode后重启服务器 进入AMH面板时提示如下错误:
[Amysql-Notice] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Mysql链接出错,请配置/Amysql/config.php文件。# 请问什么意思,,求助

我远程连接服务器 用 amh mysql restart 重新启动数据库又出现如下错误:

ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/li637-186.pid).

这个li637-186.err 文件错误提示日志文件信息如下:

Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
141115 14:24:06 [Warning] IP address '222.211.86.208' could not be resolved: Name or service not known
141116 11:40:59 [Warning] IP address '180.250.89.50' could not be resolved: Name or service not known
141116 19:59:13 [Warning] IP address '104.194.6.192' could not be resolved: Temporary failure in name resolution
141117 8:43:44 [Warning] IP address '175.19.185.150' has been resolved to the host name '150.185.19.175.adsl-pool.jlccptt.net.cn', which resembles IPv4-address itself.
141119 13:16:47 [Warning] IP address '222.73.254.108' could not be resolved: Name or service not known
141121 9:56:20 [Warning] IP address '122.227.228.41' could not be resolved: Name or service not known
141122 6:23:32 [Warning] IP address '222.76.218.237' could not be resolved: Name or service not known
141123 3:00:09 [Warning] IP address '183.136.205.36' could not be resolved: Name or service not known
141123 3:06:00 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
141123 3:06:00 [Warning] Retry in 60 secs. Message reprinted in 600 secs
141123 3:16:00 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
141123 3:16:00 [Warning] Retry in 60 secs. Message reprinted in 600 secs
141123 3:26:00 [Warning] Disk is full writing './mysql-bin.000005' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
141123 3:26:00 [Warning] Retry in 60 secs. Message reprinted in 600 secs
141123 3:36:00 [Warning] Disk is full writing './mysql-bin.000005' (Errco141123 03:46:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
141123 3:46:30 [Note] Plugin 'InnoDB' is disabled.
03:46:30 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144

请教大神给看看日志文件 啥错误~~!
出现原因:因为我在amh后台开启了数据自动备份,通过ftp看了下backup目录下有前几天备份的数据一个达到了3G,一个达到了6G,导致空间不足,所以出现以上问题~!自己第一次遇到这种情况,有增加了一些经验~!结贴!在此谢谢,好心回复的网友,真诚感谢~!



2014-11-23 11:55:07 1

zxcdotso
铝牌会员
375.00 价值分

amh mysql restart 重启试试,或者你可能在PMA上改了密码
  支持 (0分)  反对 (0分)
回复  2014-11-23 12:02:06 2

xiaomayi2012
铜牌会员
947.65 价值分

引用:
zxcdotso 发表于 2014-11-23 12:02
amh mysql restart 重启试试,或者你可能在PMA上改了密码


这个得用root权限吗,pma密码我今天都没动 网站突然前台显示502 后台输入验证码正确 确提示错误~~!
  支持 (0分)  反对 (0分)
回复  2014-11-23 13:37:02 3

xiaomayi2012
铜牌会员
947.65 价值分

引用:
zxcdotso 发表于 2014-11-23 12:02
amh mysql restart 重启试试,或者你可能在PMA上改了密码


刚试了试 出现这个错误!

ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mys ql/data/li637-186.pid).
  支持 (3.48分)  反对 (0分)
回复  2014-11-23 13:50:08 4

zxcdotso
铝牌会员
375.00 价值分

进程卡死了。。。需要用ps aux | grep mysql查看PID,然后用kill PID杀死进程。。。
  支持 (0分)  反对 (0分)
回复  2014-11-23 17:53:21 5

xiaomayi2012
铜牌会员
947.65 价值分

引用:
zxcdotso 发表于 2014-11-23 17:53
进程卡死了。。。需要用ps aux | grep mysql查看PID,然后用kill PID杀死进程。。。 ...


可能是 但是今天在看 WordPress的主题 缩略图不显示了。。
  支持 (0分)  反对 (0分)
回复  2014-11-24 21:02:46 6
 1  (总1页)
AMH社区列表
用户服务中心