军哥帮忙看一下哪里错误，谢谢。

我乐啥 发表于 2012-4-26 11:27:44

120406 11:12:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120406 11:12:35 Event Scheduler: Loaded 0 events
120406 11:12:35 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
120406 11:12:36 /usr/local/mysql/libexec/mysqld: Normal shutdown

120406 11:12:36 Event Scheduler: Purging the queue. 0 events
120406 11:12:36 /usr/local/mysql/libexec/mysqld: Shutdown complete

120406 11:12:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120406 11:12:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120406 11:12:37 Event Scheduler: Loaded 0 events
120406 11:12:37 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
120406 11:12:38 /usr/local/mysql/libexec/mysqld: Normal shutdown

120406 11:12:38 Event Scheduler: Purging the queue. 0 events
120406 11:12:38 /usr/local/mysql/libexec/mysqld: Shutdown complete

120406 11:12:38 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120406 11:20:16 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120406 11:20:17 Event Scheduler: Loaded 0 events
120406 11:20:17 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
120406 11:20:19 mysqld_safe A mysqld process already exists
1204262:02:19 /usr/local/mysql/libexec/mysqld: Sort aborted
1204268:07:34 /usr/local/mysql/libexec/mysqld: Sort aborted
120426 09:35:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1204269:35:31 Event Scheduler: Loaded 0 events
1204269:35:31 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
1204269:46:33 /usr/local/mysql/libexec/mysqld: Normal shutdown

1204269:46:33 Event Scheduler: Purging the queue. 0 events
1204269:46:34 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 09:46:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 09:46:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1204269:46:52 Event Scheduler: Loaded 0 events
1204269:46:52 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
120426 11:02:32 /usr/local/mysql/libexec/mysqld: Normal shutdown

120426 11:02:32 Event Scheduler: Purging the queue. 0 events
120426 11:02:32 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 11:02:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 11:02:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426 11:02:38 Event Scheduler: Loaded 0 events
120426 11:02:38 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
120426 11:03:30 /usr/local/mysql/libexec/mysqld: Normal shutdown

120426 11:03:30 Event Scheduler: Purging the queue. 0 events
120426 11:03:30 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 11:03:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 11:03:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426 11:03:31 Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:03:31 Can't create test file /usr/local/mysql/var/286858.lower-test
/usr/local/mysql/libexec/mysqld: File './mysql-bin.~rec~' not found (Errcode: 122)
120426 11:03:31 MYSQL_BIN_LOG::open_purge_index_file failed to open registerfile.
120426 11:03:31 MYSQL_BIN_LOG::open_index_file failed to sync the index file.
120426 11:03:31 Aborting

120426 11:03:31 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 11:03:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 11:08:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426 11:08:52 Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:08:52 Can't create test file /usr/local/mysql/var/286858.lower-test
/usr/local/mysql/libexec/mysqld: File './mysql-bin.~rec~' not found (Errcode: 122)
120426 11:08:52 MYSQL_BIN_LOG::open_purge_index_file failed to open registerfile.
120426 11:08:52 MYSQL_BIN_LOG::open_index_file failed to sync the index file.
120426 11:08:52 Aborting

120426 11:08:52 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 11:08:52 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 11:09:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426 11:09:28 Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:09:28 Can't create test file /usr/local/mysql/var/286858.lower-test
/usr/local/mysql/libexec/mysqld: File './mysql-bin.~rec~' not found (Errcode: 122)
120426 11:09:28 MYSQL_BIN_LOG::open_purge_index_file failed to open registerfile.
120426 11:09:28 MYSQL_BIN_LOG::open_index_file failed to sync the index file.
120426 11:09:28 Aborting

120426 11:09:28 /usr/local/mysql/libexec/mysqld: Shutdown complete

120426 11:09:28 mysqld_safe mysqld from pid file /usr/local/mysql/var/286858.lqh.pid ended
120426 11:11:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426 11:11:36 Event Scheduler: Loaded 0 events
120426 11:11:36 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution

phpMyAdmin - ErrorCannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

我乐啥 发表于 2012-4-26 11:37:53

几乎配置好后运行半个月就会出现这种情况。

licess 发表于 2012-4-26 12:34:12

修改过配置文件或修改过mysql目录权限？

我乐啥 发表于 2012-4-26 12:37:43

之改过一次 php.ini里session.auto_start的值是多少，改为1 后又恢复了0.
其他任何文件都没有修改过。

我乐啥 发表于 2012-4-26 12:39:33

就今天发现我网站后台登录不进去。然后发现 phpmyadmin 错误。然后就进论坛找到你说的方法。然后重启mysql 起不了。。然后就来提问题了。

licess 发表于 2012-4-26 13:11:16

mysql -uroot -p 登陆看看
我感觉是权限设置问题，ls -l /usr/local/mysql/var/ 看看

我乐啥 发表于 2012-4-26 13:59:22

按照你说的操作了请看如下图重启了 VPS 现在网站搞不通了 502 Bad Gateway

我乐啥 发表于 2012-4-26 14:15:12

全部服务重启只有 mysql 起不了。。网站现在又可以正常。仍然 phpMyAdmin - 错误

# /etc/init.d/mysql start
Starting MySQL SUCCESS!
#
# /etc/init.d/mysql restart
Shutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!
touch: cannot touch `/var/lock/subsys/mysql': Disk quota exceeded

我乐啥 发表于 2012-4-26 14:19:08

Filesystem          SizeUsed Avail Use% Mounted on
/dev/simfs          20G6.5G 14G33% /
none                257M4.0K257M 1% /dev

licess 发表于 2012-4-26 14:40:25

看权限是没问题

df -h看占用在openvz下是不准的，如果母机没空间了，照样是没空间
Disk quota exceeded看可能就是没空间了

按https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html 只删除日志，再启动试试看

我乐啥 发表于 2012-4-26 15:09:54

删除日志还显示配额满。注解两行就没有提示了
但是 phpmyadmin OK 了

licess 发表于 2012-4-26 15:21:04

是openvz的话最好是问问，也可以找个大文件下载看看，能存上不，存不上就肯定是母机上没空间了，就得找vps客服问问了

我乐啥 发表于 2012-4-26 16:09:35

已经搞定了。谢谢是VPS文件夹限制问题。

页: [1]

VPS侦探论坛's Archiver

军哥帮忙看一下 哪里错误，谢谢。

军哥帮忙看一下哪里错误，谢谢。