VPS侦探论坛

标题: 数据库突然链接不上了 帮忙看下日志 [打印本页]
作者: affpay    时间: 2014-6-7 16:31
标题: 数据库突然链接不上了 帮忙看下日志
网站打开提示 Error establishing a database connectionFTP和ssh都能连上
PHPmyadmin 登录不进去了 好几个月没登录过这个VPS了
确信自己没改过任何东西

军歌帮忙看下是不是被入侵了 改了配置


附件：[attach]2005[/attach]
------------------------
日志里边有段这个代码很可疑 但是不明白意思[attach]2005[/attach]

  1. Version: '5.5.28-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  2. 131211 15:11:16 [Warning] IP address '60.171.215.146' could not be resolved: Name or service not known
  3. 131217 23:40:14 [Warning] IP address '82.221.102.179' could not be resolved: Name or service not known
  4. 131218  0:36:18 [Warning] IP address '80.82.78.9' could not be resolved: Name or service not known
  5. 131228  6:17:54 [Warning] IP address '61.139.44.69' could not be resolved: Name or service not known
  6. 131230  3:31:59 [Warning] IP address '121.14.220.190' could not be resolved: Name or service not known
  7. 131231 20:42:40 [Warning] IP address '60.222.229.66' has been resolved to the host name '66.229.222.60.adsl-pool.sx.cn', which resembles IPv4-address itself.
  8. 140104  3:04:45 [Warning] IP address '1.93.14.51' could not be resolved: Name or service not known
  9. 140108 14:03:12 [Warning] IP address '221.11.108.10' could not be resolved: Name or service not known
  10. 140125  0:22:16 [Warning] IP address '1.93.1.83' could not be resolved: Name or service not known
  11. 140201 16:02:15 [Warning] IP address '61.147.103.154' could not be resolved: Name or service not known
  12. 140215 23:49:31 [Warning] IP address '117.34.72.148' could not be resolved: Name or service not known
  13. 140218 11:43:12 [Warning] IP address '61.147.103.160' could not be resolved: Name or service not known
  14. 140219 19:09:17 [Warning] IP address '220.181.158.174' could not be resolved: Name or service not known
  15. 140223  8:03:19 [Warning] IP address '118.26.230.35' could not be resolved: Name or service not known
  16. 140226  3:52:58 [Warning] IP address '222.187.129.29' could not be resolved: Name or service not known
  17. 140306  9:46:39 [Warning] IP address '112.186.1.37' could not be resolved: Name or service not known
  18. 140317 13:41:09 [Warning] IP address '96.47.235.31' could not be resolved: Name or service not known
  19. 140318  0:53:23 [Warning] IP address '61.167.138.235' could not be resolved: Name or service not known
  20. 140320 12:36:27 [Warning] IP address '113.105.247.54' could not be resolved: Name or service not known
  21. 140320 15:58:18 [Warning] IP address '218.9.29.90' could not be resolved: Name or service not known
  22. 140321 19:17:08 [Warning] IP address '96.47.235.5' could not be resolved: Name or service not known
  23. 140324 15:05:03 [Warning] IP address '61.183.41.72' could not be resolved: Name or service not known
  24. 140326 22:14:18 [Warning] IP address '119.147.114.23' could not be resolved: Name or service not known
  25. 140328 17:02:23 [Warning] IP address '119.97.184.164' has been resolved to the host name '164.184.97.119.broad.wh.hb.dynamic.163data.com.cn', which resembles IPv4-address itself.
  26. 140404 12:26:56 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
复制代码





[attach]2005[/attach]
作者: licess    时间: 2014-6-7 16:54
前半部分日志里没错误信息
只是一些mysql对ip地址进行dns解析的日志记录

后半部分
140605  4:50:23 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
140605  4:50:23 [ERROR] Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605  4:50:23 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_2.MYI'; try to repair it
140605  4:50:23 [ERROR] Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605  4:50:23 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_1.MYI'; try to repair it
140605  4:50:23 [ERROR] Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605 14:50:25 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
140605 14:50:25 [ERROR] Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605 15:13:30 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
140605 15:13:30 [ERROR] Got an error from unkn140607 16:09:05 mysqld_safe A mysqld process already exists
140607 16:15:49 [ERROR] /usr/local/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

数据库有错误需要修复
/usr/local/mysql/bin/mysqlcheck -A -r -c -p 修复试试看
作者: affpay    时间: 2014-6-7 17:31
标题: 回复 2# 的帖子
谢谢军哥这么快速的回复

在论坛找到帖子 说可能是日志满了 造成的
用探针看了下 可用空间为0了
于是删除了10几G的mysql-bin.000013 类似文件
网站现在能访问了
https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html



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