军哥:误删了/usr/local/mysql/var下的.pid文件重启不生成怎么办?

affpay · 发表于 2014-12-5 20:05:40

由于手动删mysql-bin.0000*日志文件
误删了/usr/local/mysql/var下的vultr.guest.pid文件
论坛搜索到一个相关帖子说这个是重启下就能自动生成
结果我重启了vps 一直生成不了那个.pid文件

数据库重启一直提示：
/etc/init.d/mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/vultr.guest.pid).

请问军哥有啥办法处理这个问题

licess · 发表于 2014-12-5 20:24:52

pid是自动创建删除的，不存在误删启动不了
mysql启动不了按置顶帖提供日志

affpay · 发表于 2014-12-5 21:11:47

141205 18:21:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:21:06 InnoDB: The InnoDB memory heap is disabled
141205 18:21:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:21:06 InnoDB: Compressed tables use zlib 1.2.3
141205 18:21:06 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:21:06 InnoDB: Completed initialization of buffer pool
141205 18:21:06 InnoDB: highest supported file format is Barracuda.
141205 18:21:06  InnoDB: Waiting for the background threads to start
141205 18:21:07 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:21:07 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:21:07 [ERROR] Could not open log file
141205 18:21:07 [ERROR] Can't init tc log
141205 18:21:07 [ERROR] Aborting

141205 18:21:07  InnoDB: Starting shutdown...
141205 18:21:07  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:21:07 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:21:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:21:16 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:21:16 InnoDB: The InnoDB memory heap is disabled
141205 18:21:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:21:16 InnoDB: Compressed tables use zlib 1.2.3
141205 18:21:16 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:21:16 InnoDB: Completed initialization of buffer pool
141205 18:21:16 InnoDB: highest supported file format is Barracuda.
141205 18:21:16  InnoDB: Waiting for the background threads to start
141205 18:21:17 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:21:17 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:21:17 [ERROR] Could not open log file
141205 18:21:17 [ERROR] Can't init tc log
141205 18:21:17 [ERROR] Aborting

141205 18:21:17  InnoDB: Starting shutdown...
141205 18:21:18  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:21:18 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:21:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:23:43 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:23:43 InnoDB: The InnoDB memory heap is disabled
141205 18:23:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:23:43 InnoDB: Compressed tables use zlib 1.2.3
141205 18:23:43 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:23:43 InnoDB: Completed initialization of buffer pool
141205 18:23:43 InnoDB: highest supported file format is Barracuda.
141205 18:23:43  InnoDB: Waiting for the background threads to start
141205 18:23:44 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:23:44 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:23:44 [ERROR] Could not open log file
141205 18:23:44 [ERROR] Can't init tc log
141205 18:23:44 [ERROR] Aborting

141205 18:23:44  InnoDB: Starting shutdown...
141205 18:23:45  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:23:45 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:23:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:23:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:23:55 InnoDB: The InnoDB memory heap is disabled
141205 18:23:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:23:55 InnoDB: Compressed tables use zlib 1.2.3
141205 18:23:55 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:23:55 InnoDB: Completed initialization of buffer pool
141205 18:23:55 InnoDB: highest supported file format is Barracuda.
141205 18:23:55  InnoDB: Waiting for the background threads to start
141205 18:23:56 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:23:56 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:23:56 [ERROR] Could not open log file
141205 18:23:56 [ERROR] Can't init tc log
141205 18:23:56 [ERROR] Aborting

141205 18:23:56  InnoDB: Starting shutdown...
141205 18:23:57  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:23:57 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:23:57 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:24:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:24:53 InnoDB: The InnoDB memory heap is disabled
141205 18:24:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:24:53 InnoDB: Compressed tables use zlib 1.2.3
141205 18:24:53 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:24:53 InnoDB: Completed initialization of buffer pool
141205 18:24:53 InnoDB: highest supported file format is Barracuda.
141205 18:24:53  InnoDB: Waiting for the background threads to start
141205 18:24:54 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:24:54 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:24:54 [ERROR] Could not open log file
141205 18:24:54 [ERROR] Can't init tc log
141205 18:24:54 [ERROR] Aborting

141205 18:24:54  InnoDB: Starting shutdown...
141205 18:24:54  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:24:54 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:24:54 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:25:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:25:08 InnoDB: The InnoDB memory heap is disabled
141205 18:25:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:25:08 InnoDB: Compressed tables use zlib 1.2.3
141205 18:25:08 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:25:08 InnoDB: Completed initialization of buffer pool
141205 18:25:08 InnoDB: highest supported file format is Barracuda.
141205 18:25:08  InnoDB: Waiting for the background threads to start
141205 18:25:09 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:25:09 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:25:09 [ERROR] Could not open log file
141205 18:25:09 [ERROR] Can't init tc log
141205 18:25:09 [ERROR] Aborting

141205 18:25:09  InnoDB: Starting shutdown...
141205 18:25:10  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:25:10 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:25:10 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:31:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:31:57 InnoDB: The InnoDB memory heap is disabled
141205 18:31:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:31:57 InnoDB: Compressed tables use zlib 1.2.3
141205 18:31:57 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:31:57 InnoDB: Completed initialization of buffer pool
141205 18:31:57 InnoDB: highest supported file format is Barracuda.
141205 18:31:57  InnoDB: Waiting for the background threads to start
141205 18:31:58 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:31:58 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:31:58 [ERROR] Could not open log file
141205 18:31:58 [ERROR] Can't init tc log
141205 18:31:58 [ERROR] Aborting

141205 18:31:58  InnoDB: Starting shutdown...
141205 18:31:58  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:31:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

affpay · 发表于 2014-12-5 21:12:11

141205 18:31:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:35:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:35:18 InnoDB: The InnoDB memory heap is disabled
141205 18:35:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:35:18 InnoDB: Compressed tables use zlib 1.2.3
141205 18:35:18 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:35:18 InnoDB: Completed initialization of buffer pool
141205 18:35:18 InnoDB: highest supported file format is Barracuda.
141205 18:35:18  InnoDB: Waiting for the background threads to start
141205 18:35:19 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:35:19 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:35:19 [ERROR] Could not open log file
141205 18:35:19 [ERROR] Can't init tc log
141205 18:35:19 [ERROR] Aborting

141205 18:35:19  InnoDB: Starting shutdown...
141205 18:35:19  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:35:19 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:35:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:37:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:37:22 InnoDB: The InnoDB memory heap is disabled
141205 18:37:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:37:22 InnoDB: Compressed tables use zlib 1.2.3
141205 18:37:22 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:37:22 InnoDB: Completed initialization of buffer pool
141205 18:37:22 InnoDB: highest supported file format is Barracuda.
141205 18:37:22  InnoDB: Waiting for the background threads to start
141205 18:37:23 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:37:23 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:37:23 [ERROR] Could not open log file
141205 18:37:23 [ERROR] Can't init tc log
141205 18:37:23 [ERROR] Aborting

141205 18:37:23  InnoDB: Starting shutdown...
141205 18:37:24  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:37:24 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:38:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:38:07 InnoDB: The InnoDB memory heap is disabled
141205 18:38:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:38:07 InnoDB: Compressed tables use zlib 1.2.3
141205 18:38:07 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:38:07 InnoDB: Completed initialization of buffer pool
141205 18:38:07 InnoDB: highest supported file format is Barracuda.
141205 18:38:07  InnoDB: Waiting for the background threads to start
141205 18:38:08 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:38:08 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:38:08 [ERROR] Could not open log file
141205 18:38:08 [ERROR] Can't init tc log
141205 18:38:08 [ERROR] Aborting

141205 18:38:08  InnoDB: Starting shutdown...
141205 18:38:08  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:38:08 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:38:08 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:38:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:38:17 InnoDB: The InnoDB memory heap is disabled
141205 18:38:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:38:17 InnoDB: Compressed tables use zlib 1.2.3
141205 18:38:17 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:38:17 InnoDB: Completed initialization of buffer pool
141205 18:38:17 InnoDB: highest supported file format is Barracuda.
141205 18:38:17  InnoDB: Waiting for the background threads to start
141205 18:38:18 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:38:18 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:38:18 [ERROR] Could not open log file
141205 18:38:18 [ERROR] Can't init tc log
141205 18:38:18 [ERROR] Aborting

141205 18:38:18  InnoDB: Starting shutdown...
141205 18:38:19  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:38:19 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:38:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:41:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:41:48 InnoDB: The InnoDB memory heap is disabled
141205 18:41:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:41:48 InnoDB: Compressed tables use zlib 1.2.3
141205 18:41:48 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:41:48 InnoDB: Completed initialization of buffer pool
141205 18:41:48 InnoDB: highest supported file format is Barracuda.
141205 18:41:48  InnoDB: Waiting for the background threads to start
141205 18:41:49 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:41:49 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:41:49 [ERROR] Could not open log file
141205 18:41:49 [ERROR] Can't init tc log
141205 18:41:49 [ERROR] Aborting

141205 18:41:49  InnoDB: Starting shutdown...
141205 18:41:50  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:41:50 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:41:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:45:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:45:46 InnoDB: The InnoDB memory heap is disabled
141205 18:45:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:45:46 InnoDB: Compressed tables use zlib 1.2.3
141205 18:45:46 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:45:46 InnoDB: Completed initialization of buffer pool
141205 18:45:46 InnoDB: highest supported file format is Barracuda.
141205 18:45:46  InnoDB: Waiting for the background threads to start
141205 18:45:47 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:45:47 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:45:47 [ERROR] Could not open log file
141205 18:45:47 [ERROR] Can't init tc log
141205 18:45:47 [ERROR] Aborting

141205 18:45:47  InnoDB: Starting shutdown...
141205 18:45:48  InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:45:48 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 18:45:48 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:07:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:07:30 InnoDB: The InnoDB memory heap is disabled
141205 19:07:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:07:30 InnoDB: Compressed tables use zlib 1.2.3
141205 19:07:30 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:07:30 InnoDB: Completed initialization of buffer pool
141205 19:07:30 InnoDB: highest supported file format is Barracuda.
141205 19:07:30  InnoDB: Waiting for the background threads to start
141205 19:07:31 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:07:31 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:07:31 [ERROR] Could not open log file
141205 19:07:31 [ERROR] Can't init tc log
141205 19:07:31 [ERROR] Aborting

affpay · 发表于 2014-12-5 21:13:16

141205 19:07:31  InnoDB: Starting shutdown...
141205 19:07:31  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:07:31 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:07:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:10:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:10:04 InnoDB: The InnoDB memory heap is disabled
141205 19:10:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:10:04 InnoDB: Compressed tables use zlib 1.2.3
141205 19:10:04 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:10:04 InnoDB: Completed initialization of buffer pool
141205 19:10:04 InnoDB: highest supported file format is Barracuda.
141205 19:10:04  InnoDB: Waiting for the background threads to start
141205 19:10:05 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:10:05 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:10:05 [ERROR] Could not open log file
141205 19:10:05 [ERROR] Can't init tc log
141205 19:10:05 [ERROR] Aborting

141205 19:10:05  InnoDB: Starting shutdown...
141205 19:10:06  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:10:06 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:10:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:14:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:14:40 InnoDB: The InnoDB memory heap is disabled
141205 19:14:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:14:40 InnoDB: Compressed tables use zlib 1.2.3
141205 19:14:40 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:14:40 InnoDB: Completed initialization of buffer pool
141205 19:14:40 InnoDB: highest supported file format is Barracuda.
141205 19:14:40  InnoDB: Waiting for the background threads to start
141205 19:14:41 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:14:41 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:14:41 [ERROR] Could not open log file
141205 19:14:41 [ERROR] Can't init tc log
141205 19:14:41 [ERROR] Aborting

141205 19:14:41  InnoDB: Starting shutdown...
141205 19:14:41  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:14:41 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:14:41 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:18:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:18:21 InnoDB: The InnoDB memory heap is disabled
141205 19:18:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:18:21 InnoDB: Compressed tables use zlib 1.2.3
141205 19:18:21 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:18:21 InnoDB: Completed initialization of buffer pool
141205 19:18:21 InnoDB: highest supported file format is Barracuda.
141205 19:18:21  InnoDB: Waiting for the background threads to start
141205 19:18:22 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:18:22 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:18:22 [ERROR] Could not open log file
141205 19:18:22 [ERROR] Can't init tc log
141205 19:18:22 [ERROR] Aborting

141205 19:18:22  InnoDB: Starting shutdown...
141205 19:18:23  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:18:23 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:18:23 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:18:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:18:53 InnoDB: The InnoDB memory heap is disabled
141205 19:18:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:18:53 InnoDB: Compressed tables use zlib 1.2.3
141205 19:18:53 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:18:53 InnoDB: Completed initialization of buffer pool
141205 19:18:53 InnoDB: highest supported file format is Barracuda.
141205 19:18:53  InnoDB: Waiting for the background threads to start
141205 19:18:54 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:18:54 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:18:54 [ERROR] Could not open log file
141205 19:18:54 [ERROR] Can't init tc log
141205 19:18:54 [ERROR] Aborting

141205 19:18:54  InnoDB: Starting shutdown...
141205 19:18:54  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:18:54 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:18:54 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:27:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:27:03 InnoDB: The InnoDB memory heap is disabled
141205 19:27:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:27:03 InnoDB: Compressed tables use zlib 1.2.3
141205 19:27:03 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:27:03 InnoDB: Completed initialization of buffer pool
141205 19:27:03 InnoDB: highest supported file format is Barracuda.
141205 19:27:03  InnoDB: Waiting for the background threads to start
141205 19:27:04 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:27:04 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:27:04 [ERROR] Could not open log file
141205 19:27:04 [ERROR] Can't init tc log
141205 19:27:04 [ERROR] Aborting

141205 19:27:04  InnoDB: Starting shutdown...
141205 19:27:04  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:27:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:27:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:27:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:27:54 InnoDB: The InnoDB memory heap is disabled
141205 19:27:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:27:54 InnoDB: Compressed tables use zlib 1.2.3
141205 19:27:54 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:27:54 InnoDB: Completed initialization of buffer pool
141205 19:27:54 InnoDB: highest supported file format is Barracuda.
141205 19:27:54  InnoDB: Waiting for the background threads to start
141205 19:27:55 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:27:55 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:27:55 [ERROR] Could not open log file
141205 19:27:55 [ERROR] Can't init tc log
141205 19:27:55 [ERROR] Aborting

141205 19:27:55  InnoDB: Starting shutdown...
141205 19:27:56  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:27:56 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:27:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:28:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:28:18 InnoDB: The InnoDB memory heap is disabled
141205 19:28:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:28:18 InnoDB: Compressed tables use zlib 1.2.3
141205 19:28:18 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:28:18 InnoDB: Completed initialization of buffer pool
141205 19:28:18 InnoDB: highest supported file format is Barracuda.
141205 19:28:18  InnoDB: Waiting for the background threads to start
141205 19:28:19 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:28:19 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:28:19 [ERROR] Could not open log file
141205 19:28:19 [ERROR] Can't init tc log
141205 19:28:19 [ERROR] Aborting

affpay · 发表于 2014-12-5 21:13:26

141205 19:28:19  InnoDB: Starting shutdown...
141205 19:28:20  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:28:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:28:20 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:29:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:29:59 InnoDB: The InnoDB memory heap is disabled
141205 19:29:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:29:59 InnoDB: Compressed tables use zlib 1.2.3
141205 19:29:59 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:29:59 InnoDB: Completed initialization of buffer pool
141205 19:29:59 InnoDB: highest supported file format is Barracuda.
141205 19:29:59  InnoDB: Waiting for the background threads to start
141205 19:30:00 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:30:00 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:30:00 [ERROR] Could not open log file
141205 19:30:00 [ERROR] Can't init tc log
141205 19:30:00 [ERROR] Aborting

141205 19:30:00  InnoDB: Starting shutdown...
141205 19:30:01  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:30:01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:30:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:52:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:52:03 InnoDB: The InnoDB memory heap is disabled
141205 19:52:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:52:03 InnoDB: Compressed tables use zlib 1.2.3
141205 19:52:03 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:52:03 InnoDB: Completed initialization of buffer pool
141205 19:52:03 InnoDB: highest supported file format is Barracuda.
141205 19:52:03  InnoDB: Waiting for the background threads to start
141205 19:52:04 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:52:04 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:52:04 [ERROR] Could not open log file
141205 19:52:04 [ERROR] Can't init tc log
141205 19:52:04 [ERROR] Aborting

141205 19:52:04  InnoDB: Starting shutdown...
141205 19:52:05  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:52:05 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:52:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:52:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:52:31 InnoDB: The InnoDB memory heap is disabled
141205 19:52:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:52:31 InnoDB: Compressed tables use zlib 1.2.3
141205 19:52:31 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:52:31 InnoDB: Completed initialization of buffer pool
141205 19:52:31 InnoDB: highest supported file format is Barracuda.
141205 19:52:31  InnoDB: Waiting for the background threads to start
141205 19:52:32 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:52:32 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:52:32 [ERROR] Could not open log file
141205 19:52:32 [ERROR] Can't init tc log
141205 19:52:32 [ERROR] Aborting

141205 19:52:32  InnoDB: Starting shutdown...
141205 19:52:32  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:52:32 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:52:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:58:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:58:59 InnoDB: The InnoDB memory heap is disabled
141205 19:58:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:58:59 InnoDB: Compressed tables use zlib 1.2.3
141205 19:58:59 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:58:59 InnoDB: Completed initialization of buffer pool
141205 19:58:59 InnoDB: highest supported file format is Barracuda.
141205 19:58:59  InnoDB: Waiting for the background threads to start
141205 19:59:00 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:59:00 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:59:00 [ERROR] Could not open log file
141205 19:59:00 [ERROR] Can't init tc log
141205 19:59:00 [ERROR] Aborting

141205 19:59:00  InnoDB: Starting shutdown...
141205 19:59:01  InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:59:01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 19:59:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:04:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:04:32 InnoDB: The InnoDB memory heap is disabled
141205 20:04:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:04:32 InnoDB: Compressed tables use zlib 1.2.3
141205 20:04:32 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:04:32 InnoDB: Completed initialization of buffer pool
141205 20:04:32 InnoDB: highest supported file format is Barracuda.
141205 20:04:32  InnoDB: Waiting for the background threads to start
141205 20:04:33 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 20:04:33 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 20:04:33 [ERROR] Could not open log file
141205 20:04:33 [ERROR] Can't init tc log
141205 20:04:33 [ERROR] Aborting

141205 20:04:33  InnoDB: Starting shutdown...
141205 20:04:33  InnoDB: Shutdown completed; log sequence number 6242574630
141205 20:04:33 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 20:04:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:23:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:23:12 InnoDB: The InnoDB memory heap is disabled
141205 20:23:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:23:12 InnoDB: Compressed tables use zlib 1.2.3
141205 20:23:12 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:23:12 InnoDB: Completed initialization of buffer pool
141205 20:23:12 InnoDB: highest supported file format is Barracuda.
141205 20:23:12  InnoDB: Waiting for the background threads to start
141205 20:23:13 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 20:23:13 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 20:23:13 [ERROR] Could not open log file
141205 20:23:13 [ERROR] Can't init tc log
141205 20:23:13 [ERROR] Aborting

141205 20:23:13  InnoDB: Starting shutdown...
141205 20:23:13  InnoDB: Shutdown completed; log sequence number 6242574630
141205 20:23:13 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 20:23:13 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:23:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:23:44 InnoDB: The InnoDB memory heap is disabled
141205 20:23:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:23:44 InnoDB: Compressed tables use zlib 1.2.3
141205 20:23:44 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:23:44 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
InnoDB: a new database to be created!
141205 20:23:44  InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141205 20:23:44 InnoDB: Error: all log files must be created at the same time.
141205 20:23:44 InnoDB: All log files must be created also in database creation.
141205 20:23:44 InnoDB: If you want bigger or smaller log files, shut down the
141205 20:23:44 InnoDB: database and make sure there were no errors in shutdown.
141205 20:23:44 InnoDB: Then delete the existing log files. Edit the .cnf file
141205 20:23:44 InnoDB: and start the database again.
141205 20:23:44 [ERROR] Plugin 'InnoDB' init function returned error.
141205 20:23:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141205 20:23:44 [ERROR] Unknown/unsupported storage engine: InnoDB
141205 20:23:44 [ERROR] Aborting

141205 20:23:44 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

141205 20:23:44 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended

affpay · 发表于 2014-12-5 21:14:07

抱歉尝试次数太多日志有点大

licess · 发表于 2014-12-6 13:59:18

/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:59:00 [ERROR] Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:59:00 [ERROR] Could not open log file
这个错误是未按正常途径删除日志造成的，正常删除方法：https://www.vpser.net/manage/del ... -bin-0000-logs.html
目前需要将/usr/local/mysql/var 下面的mysql-bin-index.index 清空再启动就可以了
可以在/etc/my.cnf里加上 expire_logs_days = 7 来设置为7天自动清理日志

141205 20:23:44 [ERROR] Plugin 'InnoDB' init function returned error.
141205 20:23:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141205 20:23:44 [ERROR] Unknown/unsupported storage engine: InnoDB
141205 20:23:44 [ERROR] Aborting
这个错误应该安装是没选择innodb，配置文件里启用了innodb，配置文件里禁用就可以了

affpay · 发表于 2014-12-6 15:55:58

非常感谢

		自动登录	找回密码
密码			注册

军哥:误删了/usr/local/mysql/var下的.pid文件重启不生成怎么办?

回复 2# 的帖子

军哥运维代购：http://shop63846532.taobao.com/

军哥运维代购：http://shop63846532.taobao.com/

军哥:误删了/usr/local/mysql/var下的.pid文件 重启不生成怎么办?

回复 2# 的帖子

军哥运维代购：http://shop63846532.taobao.com/

军哥运维代购：http://shop63846532.taobao.com/

军哥:误删了/usr/local/mysql/var下的.pid文件重启不生成怎么办?