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

我乐啥

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

120406 11:12:36 [Note] Event Scheduler: Purging the queue. 0 events
120406 11:12:36 [Note] /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 [Note] Event Scheduler: Loaded 0 events
120406 11:12:37 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120406 11:12:38 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120406 11:12:38 [Note] Event Scheduler: Purging the queue. 0 events
120406 11:12:38 [Note] /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 [Note] Event Scheduler: Loaded 0 events
120406 11:20:17 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120406 11:20:19 mysqld_safe A mysqld process already exists
120426  2:02:19 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
120426  8:07:34 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
120426 09:35:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120426  9:35:31 [Note] Event Scheduler: Loaded 0 events
120426  9:35:31 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120426  9:46:33 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120426  9:46:33 [Note] Event Scheduler: Purging the queue. 0 events
120426  9:46:34 [Note] /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
120426  9:46:52 [Note] Event Scheduler: Loaded 0 events
120426  9:46:52 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120426 11:02:32 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120426 11:02:32 [Note] Event Scheduler: Purging the queue. 0 events
120426 11:02:32 [Note] /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 [Note] Event Scheduler: Loaded 0 events
120426 11:02:38 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120426 11:03:30 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120426 11:03:30 [Note] Event Scheduler: Purging the queue. 0 events
120426 11:03:30 [Note] /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 [Warning] Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:03:31 [Warning] 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 [ERROR] MYSQL_BIN_LOG:pen_purge_index_file failed to open register  file.
120426 11:03:31 [ERROR] MYSQL_BIN_LOG:pen_index_file failed to sync the index file.
120426 11:03:31 [ERROR] Aborting

120426 11:03:31 [Note] /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 [Warning] Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:08:52 [Warning] 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 [ERROR] MYSQL_BIN_LOG:pen_purge_index_file failed to open register  file.
120426 11:08:52 [ERROR] MYSQL_BIN_LOG:pen_index_file failed to sync the index file.
120426 11:08:52 [ERROR] Aborting

120426 11:08:52 [Note] /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 [Warning] Can't create test file /usr/local/mysql/var/286858.lower-test
120426 11:09:28 [Warning] 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 [ERROR] MYSQL_BIN_LOG:pen_purge_index_file failed to open register  file.
120426 11:09:28 [ERROR] MYSQL_BIN_LOG:pen_index_file failed to sync the index file.
120426 11:09:28 [ERROR] Aborting

120426 11:09:28 [Note] /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 [Note] Event Scheduler: Loaded 0 events
120426 11:11:36 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source 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.

我乐啥

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

licess

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

我乐啥

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

我乐啥

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

licess

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

我乐啥

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

我乐啥

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


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

我乐啥

Filesystem            Size  Used Avail Use% Mounted on
/dev/simfs             20G  6.5G   14G  33% /
none                  257M  4.0K  257M   1% /dev

licess

看权限是没问题

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

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

我乐啥

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

licess

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

我乐啥

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