MYSQL启动不了，急求，附错误日志
VPS上一直很正常地运行。今天突然出现著名的502错误。重启LNMP在MYSQL启动处失败。没法，重启VPS。
连接MYSQL，提示2002错误。
再重启VPS。MYSQL就连接失败了。
附错误日志。
110225 11:22:22 /usr/local/mysql/libexec/mysqld: Normal shutdown
110225 11:22:22 Event Scheduler: Purging the queue. 0 events
110225 11:22:22 /usr/local/mysql/libexec/mysqld: Shutdown complete
110225 11:22:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/10wan.info.pid ended
110225 11:22:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110225 11:22:23 Event Scheduler: Loaded 0 events
110225 11:22:23 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
110322 03:36:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1103223:36:07 Event Scheduler: Loaded 0 events
1103223:36:07 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
110401 21:25:19 /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)
110401 21:25:20 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 21:35:20 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 21:45:20 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 21:55:20 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:05:32 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:15:32 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:25:32 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:28:39 /usr/local/mysql/libexec/mysqld: Normal shutdown
110401 22:28:40 Event Scheduler: Purging the queue. 0 events
110401 22:28:42 /usr/local/mysql/libexec/mysqld: Forcing close of thread 60774user: '9ch'
110401 22:28:42 /usr/local/mysql/libexec/mysqld: Forcing close of thread 60767user: '9ch'
110401 22:28:42 /usr/local/mysql/libexec/mysqld: Forcing close of thread 60761user: 'wh2'
110401 22:29:33 /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)
110401 22:29:33 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:39:33 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:49:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/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)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 22:55:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/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)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110401 23:24:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writin110401 23:28:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/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)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 军哥，救急啊。。。。:Q :Q
Reload LNMP...
Reload Nginx configure...
the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
configuration file /usr/local/nginx/conf/nginx.conf test is successful
Nginx program is reloding!
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL.. ERROR! Manager of pid-file quit without updating file.
Shutting down php_fpm . done
Starting php_fpm . done
[ 本帖最后由 wngx99 于 2011-4-1 16:41 编辑 ]
回复 1# 的帖子
110401 21:25:19 /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)已经提示，硬盘满了 但是我的空间容量还剩余42148.58 M，难道MYSQL还有另外别的设置吗？求解释。。。。
回复 4# 的帖子
可能mysql目录是单独的分区 谢谢军哥热心回答。。。我自己再研究一下。。。 我用lnmp包装的mysql，然后主从配置后，出现上述问题。原因是mysql的反向解析连接使中断或者变慢
my.cny里加上
skip-name-resolve
重启mysql
回复 1# 的帖子
这个问题我也遇到了。最后找到原因了，是磁盘满的原因。最大的盘是/var/spool/mail 占用资源太大的缘故。
cd /var/spool/mail
ls | xargs rm -f
即可。
页:
[1]