MYSQL启动不了，急求，附错误日志

wngx99

VPS上一直很正常地运行。今天突然出现著名的502错误。

重启LNMP在MYSQL启动处失败。没法，重启VPS。

连接MYSQL，提示2002错误。

再重启VPS。MYSQL就连接失败了。

附错误日志。

1. 110225 11:22:22 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
   
2. 
   
3. 110225 11:22:22 [Note] Event Scheduler: Purging the queue. 0 events
   
4. 110225 11:22:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
   
5. 
   
6. 110225 11:22:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/10wan.info.pid ended
   
7. 110225 11:22:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
   
8. 110225 11:22:23 [Note] Event Scheduler: Loaded 0 events
   
9. 110225 11:22:23 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
   
10. Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
11. 110322 03:36:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
12. 110322  3:36:07 [Note] Event Scheduler: Loaded 0 events
    
13. 110322  3:36:07 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
    
14. Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
15. 110401 21:25:19 [ERROR] /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000033' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
    
16. 110401 21:25:20 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
17. 110401 21:35:20 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
18. 110401 21:45:20 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
19. 110401 21:55:20 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
20. 110401 22:05:32 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
21. 110401 22:15:32 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
22. 110401 22:25:32 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
23. 110401 22:28:39 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
    
24. 
    
25. 110401 22:28:40 [Note] Event Scheduler: Purging the queue. 0 events
    
26. 110401 22:28:42 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 60774  user: '9ch'
    
27. 
    
28. 110401 22:28:42 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 60767  user: '9ch'
    
29. 
    
30. 110401 22:28:42 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 60761  user: 'wh2'
    
31. 
    
32. 110401 22:29:33 [ERROR] /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000033' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
    
33. 110401 22:29:33 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
34. 110401 22:39:33 [ERROR] /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
35. 110401 22:49:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
36. /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
    
37. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
38. 110401 22:55:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
39. /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
    
40. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
41. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
42. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
43. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
44. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
45. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
46. 110401 23:24:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
47. /usr/local/mysql/libexec/mysqld: Disk is full writin110401 23:28:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
48. /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
    
49. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
50. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
51. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
52. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
53. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    
54. /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs

复制代码

wngx99

军哥，救急啊。。。。

1. Reload LNMP...
   
2. Reload Nginx configure...
   
3. the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
   
4. configuration file /usr/local/nginx/conf/nginx.conf test is successful
   
5. Nginx program is reloding!
   
6. ERROR! MySQL manager or server PID file could not be found!
   
7. Starting MySQL.. ERROR! Manager of pid-file quit without updating file.
   
8. Shutting down php_fpm . done
   
9. Starting php_fpm . done

复制代码

[ 本帖最后由 wngx99 于 2011-4-1 16:41 编辑 ]

licess

110401 21:25:19 [ERROR] /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000033' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

已经提示，硬盘满了

wngx99

但是我的空间容量还剩余42148.58 M，难道MYSQL还有另外别的设置吗？求解释。。。。

licess

可能mysql目录是单独的分区

wngx99

谢谢军哥热心回答。。。我自己再研究一下。。。

zhengwu119

我用lnmp包装的mysql，然后主从配置后，出现上述问题。

原因是mysql的反向解析连接使中断或者变慢
my.cny里加上
skip-name-resolve
重启mysql

itopidea

这个问题我也遇到了。最后找到原因了，是磁盘满的原因。

最大的盘是/var/spool/mail 占用资源太大的缘故。

cd /var/spool/mail

ls | xargs rm -f

即可。