VPS侦探论坛

 找回密码
 注册
搜索
查看: 6794|回复: 12

[Oracle] 军哥帮忙看一下 哪里错误,谢谢。

[复制链接]
发表于 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 [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.
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
 楼主| 发表于 2012-4-26 11:37:53 | 显示全部楼层

几乎配置好后  运行半个月就会出现这种情况。
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2012-4-26 12:34:12 | 显示全部楼层



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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2012-4-26 12:37:43 | 显示全部楼层

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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2012-4-26 12:39:33 | 显示全部楼层



就今天 发现我网站后台登录不进去。 然后发现 phpmyadmin 错误。然后就进论坛找到你说的方法。然后重启mysql 起不了。。 然后就来 提问题了。
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2012-4-26 13:11:16 | 显示全部楼层



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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2012-4-26 13:59:22 | 显示全部楼层

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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2012-4-26 14:15:12 | 显示全部楼层

全部服务重启  只有 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
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
 楼主| 发表于 2012-4-26 14:19:08 | 显示全部楼层

Filesystem            Size  Used Avail Use% Mounted on
/dev/simfs             20G  6.5G   14G  33% /
none                  257M  4.0K  257M   1% /dev
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2012-4-26 14:40:25 | 显示全部楼层

看权限是没问题

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

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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2012-4-26 15:09:54 | 显示全部楼层


删除日志 还显示 配额满。 注解两行 就没有提示了
但是 phpmyadmin OK 了
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2012-4-26 15:21:04 | 显示全部楼层



是openvz的话最好是问问,也可以找个大文件下载看看,能存上不,存不上就肯定是母机上没空间了,就得找vps客服问问了
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
 楼主| 发表于 2012-4-26 16:09:35 | 显示全部楼层



已经搞定了。谢谢  是VPS文件夹限制问题。
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2019-6-17 07:49 , Processed in 0.049026 second(s), 27 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表