VPS侦探论坛

 找回密码
 注册
查看: 5063|回复: 3

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

[复制链接]
发表于 2017-2-16 10:39:16 | 显示全部楼层 |阅读模式

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

host.err:

  1. 170215 05:16:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 170215  5:16:11 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 499 ...
  3. 170215  5:16:11 [Note] Plugin 'FEDERATED' is disabled.
  4. 170215  5:16:11 InnoDB: The InnoDB memory heap is disabled
  5. 170215  5:16:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  6. 170215  5:16:11 InnoDB: Compressed tables use zlib 1.2.7
  7. 170215  5:16:11 InnoDB: Initializing buffer pool, size = 16.0M
  8. 170215  5:16:11 InnoDB: Completed initialization of buffer pool
  9. InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
  10. InnoDB: a new database to be created!
  11. 170215  5:16:11  InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
  12. InnoDB: Database physically writes the file full: wait...
  13. 170215  5:16:12  InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
  14. InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
  15. InnoDB: Database physically writes the file full: wait...
复制代码
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 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'
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 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
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2017-2-16 13:21:32 | 显示全部楼层



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

再看https://bbs.vpser.net/thread-14937-1-1.html
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-5-4 03:29 , Processed in 0.027345 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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