急！MySQL server PID file could not be found! ...论坛里的方法都不行啊

enjoycolin · 发表于 2017-2-16 10:39:16

今天早上重启了一下服务器，之后数据库就无法启动了。top后找不到mysql进程，但是用网上ps aux |grep mysq*的方法可以列出一项，然而kill时又显示找不到进程。

host.err：

170215 05:16:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:16:11 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 499 ...
170215 5:16:11 [Note] Plugin 'FEDERATED' is disabled.
170215 5:16:11 InnoDB: The InnoDB memory heap is disabled
170215 5:16:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:16:11 InnoDB: Compressed tables use zlib 1.2.7
170215 5:16:11 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:16:11 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!
170215 5:16:11 InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170215 5:16:12 InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...

复制代码

enjoycolin · 发表于 2017-2-16 10:40:24

170215 5:16:12 InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170215 5:16:12 InnoDB: Waiting for the background threads to start
170215 5:16:13 InnoDB: 5.5.48 started; log sequence number 0
170215 5:16:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:13 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:13 [Note] Server socket created on IP: '0.0.0.0'.
170215 5:16:13 [Note] Event Scheduler: Loaded 0 events
170215 5:16:13 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:14 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

170215 5:16:14 [Note] Event Scheduler: Purging the queue. 0 events
170215 5:16:14 InnoDB: Starting shutdown...
170215 5:16:14 InnoDB: Shutdown completed; log sequence number 1595675
170215 5:16:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170215 05:16:14 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:16:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:16:15 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1048 ...
170215 5:16:15 [Note] Plugin 'FEDERATED' is disabled.
170215 5:16:15 InnoDB: The InnoDB memory heap is disabled
170215 5:16:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:16:15 InnoDB: Compressed tables use zlib 1.2.7
170215 5:16:15 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:16:15 InnoDB: Completed initialization of buffer pool
170215 5:16:15 InnoDB: highest supported file format is Barracuda.
170215 5:16:15 InnoDB: Waiting for the background threads to start
170215 5:16:16 InnoDB: 5.5.48 started; log sequence number 1595675
170215 5:16:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:16 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:16 [Note] Server socket created on IP: '0.0.0.0'.
170215 5:16:16 [Note] Event Scheduler: Loaded 0 events
170215 5:16:16 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:17 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

170215 5:16:17 [Note] Event Scheduler: Purging the queue. 0 events
170215 5:16:17 InnoDB: Starting shutdown...
170215 5:16:18 InnoDB: Shutdown completed; log sequence number 1595685
170215 5:16:18 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170215 05:16:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:16:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:16:19 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1621 ...
170215 5:16:19 [Note] Plugin 'FEDERATED' is disabled.
170215 5:16:19 InnoDB: The InnoDB memory heap is disabled
170215 5:16:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:16:19 InnoDB: Compressed tables use zlib 1.2.7
170215 5:16:19 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:16:19 InnoDB: Completed initialization of buffer pool
170215 5:16:19 InnoDB: highest supported file format is Barracuda.
170215 5:16:19 InnoDB: Waiting for the background threads to start
170215 5:16:20 InnoDB: 5.5.48 started; log sequence number 1595685
170215 5:16:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:20 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:20 [Note] Server socket created on IP: '0.0.0.0'.
170215 5:16:20 [Note] Event Scheduler: Loaded 0 events
170215 5:16:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:21 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

170215 5:16:21 [Note] Event Scheduler: Purging the queue. 0 events
170215 5:16:21 InnoDB: Starting shutdown...
170215 5:16:21 InnoDB: Shutdown completed; log sequence number 1595685
170215 5:16:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170215 05:16:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:22:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:22:07 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1762 ...
170215 5:22:07 [Note] Plugin 'FEDERATED' is disabled.
170215 5:22:07 InnoDB: The InnoDB memory heap is disabled
170215 5:22:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:22:07 InnoDB: Compressed tables use zlib 1.2.7
170215 5:22:07 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:22:07 InnoDB: Completed initialization of buffer pool
170215 5:22:07 InnoDB: highest supported file format is Barracuda.
170215 5:22:07 InnoDB: Waiting for the background threads to start
170215 5:22:08 InnoDB: 5.5.48 started; log sequence number 1595685
170215 5:22:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:22:08 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170215 5:22:08 [Note] Server socket created on IP: '0.0.0.0'.
170215 5:22:08 [Note] Event Scheduler: Loaded 0 events
170215 5:22:08 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 23:48:35 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

170215 23:48:35 [Note] Event Scheduler: Purging the queue. 0 events
170215 23:48:35 InnoDB: Starting shutdown...
170215 23:48:36 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:48:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170215 23:48:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 23:48:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 23:48:44 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:48:44 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2682 ...
170215 23:48:44 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170215 23:48:44 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:48:44 [Note] Plugin 'FEDERATED' is disabled.
170215 23:48:44 InnoDB: The InnoDB memory heap is disabled
170215 23:48:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 23:48:44 InnoDB: Compressed tables use zlib 1.2.7
170215 23:48:44 InnoDB: Initializing buffer pool, size = 16.0M
170215 23:48:44 InnoDB: Completed initialization of buffer pool
170215 23:48:44 InnoDB: highest supported file format is Barracuda.
170215 23:48:44 InnoDB: Waiting for the background threads to start
170215 23:48:45 InnoDB: 5.5.48 started; log sequence number 3831310
170215 23:48:45 [ERROR] Aborting

170215 23:48:45 InnoDB: Starting shutdown...
170215 23:48:46 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:48:46 [Note]
170215 23:48:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170215 23:54:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 23:54:50 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:54:50 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2677 ...
170215 23:54:50 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170215 23:54:51 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:54:51 [Note] Plugin 'FEDERATED' is disabled.
170215 23:54:51 InnoDB: The InnoDB memory heap is disabled
170215 23:54:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 23:54:51 InnoDB: Compressed tables use zlib 1.2.7
170215 23:54:51 InnoDB: Initializing buffer pool, size = 16.0M
170215 23:54:51 InnoDB: Completed initialization of buffer pool
170215 23:54:51 InnoDB: highest supported file format is Barracuda.
170215 23:54:51 InnoDB: Waiting for the background threads to start
170215 23:54:52 InnoDB: 5.5.48 started; log sequence number 3831310
170215 23:54:52 [ERROR] Aborting

170215 23:54:52 InnoDB: Starting shutdown...
170215 23:54:52 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:54:52 [Note]
170215 23:54:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:36:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:36:08 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:36:08 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2408 ...
170216 9:36:08 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

enjoycolin · 发表于 2017-2-16 10:40:48

170216 9:36:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:36:08 [Note] Plugin 'FEDERATED' is disabled.
170216 9:36:08 InnoDB: The InnoDB memory heap is disabled
170216 9:36:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:36:08 InnoDB: Compressed tables use zlib 1.2.7
170216 9:36:08 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:36:08 InnoDB: Completed initialization of buffer pool
170216 9:36:08 InnoDB: highest supported file format is Barracuda.
170216 9:36:08 InnoDB: Waiting for the background threads to start
170216 9:36:09 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:36:09 [ERROR] Aborting

170216 9:36:09 InnoDB: Starting shutdown...
170216 9:36:10 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:36:10 [Note]
170216 09:36:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:40:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:40:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:40:54 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 3352 ...
170216 9:40:54 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:40:54 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:40:54 [Note] Plugin 'FEDERATED' is disabled.
170216 9:40:54 InnoDB: The InnoDB memory heap is disabled
170216 9:40:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:40:54 InnoDB: Compressed tables use zlib 1.2.7
170216 9:40:54 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:40:54 InnoDB: Completed initialization of buffer pool
170216 9:40:54 InnoDB: highest supported file format is Barracuda.
170216 9:40:54 InnoDB: Waiting for the background threads to start
170216 9:40:55 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:40:55 [ERROR] Aborting

170216 9:40:55 InnoDB: Starting shutdown...
170216 9:40:55 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:40:55 [Note]
170216 09:40:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:43:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:43:31 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:43:31 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 4155 ...
170216 9:43:31 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:43:31 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:43:31 [Note] Plugin 'FEDERATED' is disabled.
170216 9:43:31 InnoDB: The InnoDB memory heap is disabled
170216 9:43:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:43:31 InnoDB: Compressed tables use zlib 1.2.7
170216 9:43:31 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:43:31 InnoDB: Completed initialization of buffer pool
170216 9:43:31 InnoDB: highest supported file format is Barracuda.
170216 9:43:31 InnoDB: Waiting for the background threads to start
170216 9:43:32 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:43:32 [ERROR] Aborting

170216 9:43:32 InnoDB: Starting shutdown...
170216 9:43:33 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:43:33 [Note]
170216 09:43:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:48:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:48:04 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:04 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 5030 ...
170216 9:48:04 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:48:04 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:04 [Note] Plugin 'FEDERATED' is disabled.
170216 9:48:04 InnoDB: The InnoDB memory heap is disabled
170216 9:48:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:48:04 InnoDB: Compressed tables use zlib 1.2.7
170216 9:48:04 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:48:04 InnoDB: Completed initialization of buffer pool
170216 9:48:04 InnoDB: highest supported file format is Barracuda.
170216 9:48:04 InnoDB: Waiting for the background threads to start
170216 9:48:05 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:48:05 [ERROR] Aborting

170216 9:48:05 InnoDB: Starting shutdown...
170216 9:48:05 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:48:05 [Note]
170216 09:48:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:48:47 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:48:47 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:47 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 5888 ...
170216 9:48:47 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:48:47 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:47 [Note] Plugin 'FEDERATED' is disabled.
170216 9:48:47 InnoDB: The InnoDB memory heap is disabled
170216 9:48:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:48:47 InnoDB: Compressed tables use zlib 1.2.7
170216 9:48:47 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:48:47 InnoDB: Completed initialization of buffer pool
170216 9:48:47 InnoDB: highest supported file format is Barracuda.
170216 9:48:47 InnoDB: Waiting for the background threads to start
170216 9:48:48 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:48:48 [ERROR] Aborting

170216 9:48:48 InnoDB: Starting shutdown...
170216 9:48:49 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:48:49 [Note]
170216 09:48:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:54:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:54:06 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:54:06 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 6771 ...
170216 9:54:06 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:54:06 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:54:06 [Note] Plugin 'FEDERATED' is disabled.
170216 9:54:06 InnoDB: The InnoDB memory heap is disabled
170216 9:54:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:54:06 InnoDB: Compressed tables use zlib 1.2.7
170216 9:54:06 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:54:06 InnoDB: Completed initialization of buffer pool
170216 9:54:06 InnoDB: highest supported file format is Barracuda.
170216 9:54:06 InnoDB: Waiting for the background threads to start
170216 9:54:07 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:54:07 [ERROR] Aborting

170216 9:54:07 InnoDB: Starting shutdown...
170216 9:54:08 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:54:08 [Note]
170216 09:54:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

licess · 发表于 2017-2-16 13:21:32

先看一下硬盘或分区是否满了，检查一下mysql数据库目录权限

再看https://bbs.vpser.net/thread-14937-1-1.html

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

[Oracle] 急！MySQL server PID file could not be found! ...论坛里的方法都不行啊

接上面

接上面