当前位置: 代码迷 >> Ruby/Rails >> ERROR! MySQL manager or server PID file could not be found! Starting MySQL.
  详细解决方案

ERROR! MySQL manager or server PID file could not be found! Starting MySQL.

热度:135   发布时间:2016-04-29 02:19:40.0
ERROR! MySQL manager or server PID file could not be found! Starting MySQL.....

wdlinux

在mysql 安装目录下

新建 /home/wddata/var? 文件即可? mysql-bin.000008

?

141026 20:13:49 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141026 20:13:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141026 20:13:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141026 20:13:50? InnoDB: Initializing buffer pool, size = 8.0M
141026 20:13:50? InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141026 20:13:50? InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141026 20:13:50? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141026 20:13:50 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141026 20:13:50 [ERROR] Could not open log file
141026 20:13:50 [ERROR] Can't init tc log
141026 20:13:50 [ERROR] Aborting

141026 20:13:50? InnoDB: Starting shutdown...
141026 20:13:55? InnoDB: Shutdown completed; log sequence number 0 44243
141026 20:13:55 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141026 20:13:55 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141029 20:12:20 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141029 20:12:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141029 20:12:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141029 20:12:20? InnoDB: Initializing buffer pool, size = 8.0M
141029 20:12:20? InnoDB: Completed initialization of buffer pool
141029 20:12:20? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141029 20:12:20 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141029 20:12:20 [ERROR] Could not open log file
141029 20:12:20 [ERROR] Can't init tc log
141029 20:12:20 [ERROR] Aborting

141029 20:12:20? InnoDB: Starting shutdown...
141029 20:12:26? InnoDB: Shutdown completed; log sequence number 0 44243
141029 20:12:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141029 20:12:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 11:51:17 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 11:51:18 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 11:51:18 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 11:51:18? InnoDB: Initializing buffer pool, size = 8.0M
141101 11:51:18? InnoDB: Completed initialization of buffer pool
141101 11:51:19? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 11:51:19 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 11:51:19 [ERROR] Could not open log file
141101 11:51:19 [ERROR] Can't init tc log
141101 11:51:19 [ERROR] Aborting

wdlinux? 下数据库文件位置


/home/wddata/var



141101 11:51:19? InnoDB: Starting shutdown...
141101 11:51:24? InnoDB: Shutdown completed; log sequence number 0 44243
141101 11:51:24 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 11:51:24 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:03:50 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:03:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:03:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:03:50? InnoDB: Initializing buffer pool, size = 8.0M
141101 19:03:50? InnoDB: Completed initialization of buffer pool
141101 19:03:50? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:03:50 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:03:50 [ERROR] Could not open log file
141101 19:03:50 [ERROR] Can't init tc log
141101 19:03:50 [ERROR] Aborting

141101 19:03:50? InnoDB: Starting shutdown...
141101 19:03:55? InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:03:55 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:03:55 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:40:21 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:40:21 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:40:21 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:40:21? InnoDB: Initializing buffer pool, size = 8.0M
141101 19:40:21? InnoDB: Completed initialization of buffer pool
141101 19:40:21? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:40:21 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:40:21 [ERROR] Could not open log file
141101 19:40:21 [ERROR] Can't init tc log
141101 19:40:21 [ERROR] Aborting

141101 19:40:21? InnoDB: Starting shutdown...
141101 19:40:26? InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:40:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:40:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:57:20 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:57:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:57:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:57:20? InnoDB: Initializing buffer pool, size = 8.0M
141101 19:57:20? InnoDB: Completed initialization of buffer pool
141101 19:57:20? InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:57:20 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:57:20 [ERROR] Could not open log file
141101 19:57:20 [ERROR] Can't init tc log
141101 19:57:20 [ERROR] Aborting

141101 19:57:20? InnoDB: Starting shutdown...
141101 19:57:26? InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:57:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:57:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended

?

  相关解决方案