设为首页收藏本站
切换到窄版

VPS侦探论坛

 找回密码
 注册
VPS侦探论坛»VPS侦探论坛 › 技术交流区 › LNMP一键安装包 › 【求助】ERROR! MySQL server PID file could not be fo ...
返回列表 发新帖
查看: 3940|回复: 5

【求助】ERROR! MySQL server PID file could not be found!

[复制链接]
xiaoxue
发表于 2016-11-22 22:58:49 | 显示全部楼层 |阅读模式

Stoping LNMP...
Stoping nginx...  done
ERROR! MySQL server PID file could not be found!
Gracefully shutting down php-fpm . done
Starting LNMP...
Starting nginx...  done
Starting MySQL. ERROR!
Starting php-fpm  done

日志：
  1. 161122 20:34:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 161122 20:34:30 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 14390 ...
  3. 161122 20:34:30 [Note] Plugin 'FEDERATED' is disabled.
  4. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  5. 161122 20:34:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  6. 161122 20:34:30 InnoDB: The InnoDB memory heap is disabled
  7. 161122 20:34:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  8. 161122 20:34:30 InnoDB: Compressed tables use zlib 1.2.7
  9. 161122 20:34:30 InnoDB: Initializing buffer pool, size = 256.0M
  10. 161122 20:34:30 InnoDB: Completed initialization of buffer pool
  11. InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
  12. InnoDB: a new database to be created!
  13. 161122 20:34:30  InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
  14. InnoDB: Database physically writes the file full: wait...
  15. 161122 20:34:30  InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
  16. InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 64 MB
  17. InnoDB: Database physically writes the file full: wait...
  18. 161122 20:34:31  InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be created
  19. InnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 64 MB
  20. InnoDB: Database physically writes the file full: wait...
  21. InnoDB: Doublewrite buffer not found: creating new
  22. InnoDB: Doublewrite buffer created
  23. InnoDB: 127 rollback segment(s) active.
  24. InnoDB: Creating foreign key constraint system tables
  25. InnoDB: Foreign key constraint system tables created
  26. 161122 20:34:31  InnoDB: Waiting for the background threads to start
  27. 161122 20:34:32 InnoDB: 5.5.48 started; log sequence number 0
  28. 161122 20:34:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  29. 161122 20:34:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  30. 161122 20:34:32 [Note] Server socket created on IP: '0.0.0.0'.
  31. 161122 20:34:32 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  32. 161122 20:34:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  33. 161122 20:34:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  34. 161122 20:34:32 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 14938 ...
  35. 161122 20:34:32 [Note] Plugin 'FEDERATED' is disabled.
  36. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  37. 161122 20:34:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  38. 161122 20:34:32 InnoDB: The InnoDB memory heap is disabled
  39. 161122 20:34:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  40. 161122 20:34:32 InnoDB: Compressed tables use zlib 1.2.7
  41. 161122 20:34:32 InnoDB: Initializing buffer pool, size = 256.0M
  42. 161122 20:34:32 InnoDB: Completed initialization of buffer pool
  43. 161122 20:34:32 InnoDB: highest supported file format is Barracuda.
  44. InnoDB: Log scan progressed past the checkpoint lsn 48941
  45. 161122 20:34:32  InnoDB: Database was not shut down normally!
  46. InnoDB: Starting crash recovery.
  47. InnoDB: Reading tablespace information from the .ibd files...
  48. InnoDB: Restoring possible half-written data pages from the doublewrite
  49. InnoDB: buffer...
  50. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  51. 161122 20:34:32  InnoDB: Starting an apply batch of log records to the database...
  52. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  53. InnoDB: Apply batch completed
  54. 161122 20:34:33  InnoDB: Waiting for the background threads to start
  55. 161122 20:34:34 InnoDB: 5.5.48 started; log sequence number 1595675
  56. 161122 20:34:34 [Note] Recovering after a crash using mysql-bin
  57. 161122 20:34:34 [Note] Starting crash recovery...
  58. 161122 20:34:34 [Note] Crash recovery finished.
  59. 161122 20:34:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  60. 161122 20:34:34 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  61. 161122 20:34:34 [Note] Server socket created on IP: '0.0.0.0'.
  62. 161122 20:34:34 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  63. 161122 20:34:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  64. 161122 20:34:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  65. 161122 20:34:34 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 15489 ...
  66. 161122 20:34:34 [Note] Plugin 'FEDERATED' is disabled.
  67. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  68. 161122 20:34:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  69. 161122 20:34:34 InnoDB: The InnoDB memory heap is disabled
  70. 161122 20:34:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  71. 161122 20:34:34 InnoDB: Compressed tables use zlib 1.2.7
  72. 161122 20:34:34 InnoDB: Initializing buffer pool, size = 256.0M
  73. 161122 20:34:34 InnoDB: Completed initialization of buffer pool
  74. 161122 20:34:34 InnoDB: highest supported file format is Barracuda.
  75. InnoDB: Log scan progressed past the checkpoint lsn 48941
  76. 161122 20:34:34  InnoDB: Database was not shut down normally!
  77. InnoDB: Starting crash recovery.
  78. InnoDB: Reading tablespace information from the .ibd files...
  79. InnoDB: Restoring possible half-written data pages from the doublewrite
  80. InnoDB: buffer...
  81. InnoDB: Warning: database page corruption or a failed
  82. InnoDB: file read of space 0 page 281.
  83. InnoDB: Trying to recover it from the doublewrite buffer.
  84. InnoDB: Recovered the page from the doublewrite buffer.
  85. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  86. 161122 20:34:35  InnoDB: Starting an apply batch of log records to the database...
  87. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  88. InnoDB: Apply batch completed
  89. 161122 20:34:35  InnoDB: Waiting for the background threads to start
  90. 161122 20:34:36 InnoDB: 5.5.48 started; log sequence number 1595675
  91. 161122 20:34:36 [Note] Recovering after a crash using mysql-bin
  92. 161122 20:34:36 [Note] Starting crash recovery...
  93. 161122 20:34:36 [Note] Crash recovery finished.
  94. 161122 20:34:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  95. 161122 20:34:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  96. 161122 20:34:36 [Note] Server socket created on IP: '0.0.0.0'.
复制代码
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复

举报

xiaoxue
 楼主| 发表于 2016-11-22 23:00:16 | 显示全部楼层


接上面
  1. 161122 20:34:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  2. 161122 20:34:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  3. 161122 20:41:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  4. 161122 20:41:27 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 20214 ...
  5. 161122 20:41:27 [Note] Plugin 'FEDERATED' is disabled.
  6. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  7. 161122 20:41:27 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  8. 161122 20:41:27 InnoDB: The InnoDB memory heap is disabled
  9. 161122 20:41:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  10. 161122 20:41:27 InnoDB: Compressed tables use zlib 1.2.7
  11. 161122 20:41:27 InnoDB: Initializing buffer pool, size = 256.0M
  12. 161122 20:41:27 InnoDB: Completed initialization of buffer pool
  13. 161122 20:41:27 InnoDB: highest supported file format is Barracuda.
  14. InnoDB: Log scan progressed past the checkpoint lsn 49439
  15. 161122 20:41:27 InnoDB: Database was not shut down normally!
  16. InnoDB: Starting crash recovery.
  17. InnoDB: Reading tablespace information from the .ibd files...
  18. InnoDB: Restoring possible half-written data pages from the doublewrite
  19. InnoDB: buffer...
  20. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  21. 161122 20:41:27 InnoDB: Starting an apply batch of log records to the database...
  22. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  23. InnoDB: Apply batch completed
  24. 161122 20:41:27 InnoDB: Waiting for the background threads to start
  25. 161122 20:41:28 InnoDB: 5.5.48 started; log sequence number 1595675
  26. 161122 20:41:28 [Note] Recovering after a crash using mysql-bin
  27. 161122 20:41:28 [Note] Starting crash recovery...
  28. 161122 20:41:28 [Note] Crash recovery finished.
  29. 161122 20:41:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  30. 161122 20:41:28 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  31. 161122 20:41:28 [Note] Server socket created on IP: '0.0.0.0'.
  32. 161122 20:41:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  33. 161122 20:41:28 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  34. 161122 20:41:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  35. 161122 20:41:49 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 20844 ...
  36. 161122 20:41:49 [Note] Plugin 'FEDERATED' is disabled.
  37. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  38. 161122 20:41:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  39. 161122 20:41:49 InnoDB: The InnoDB memory heap is disabled
  40. 161122 20:41:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  41. 161122 20:41:49 InnoDB: Compressed tables use zlib 1.2.7
  42. 161122 20:41:49 InnoDB: Initializing buffer pool, size = 256.0M
  43. 161122 20:41:49 InnoDB: Completed initialization of buffer pool
  44. 161122 20:41:49 InnoDB: highest supported file format is Barracuda.
  45. InnoDB: Log scan progressed past the checkpoint lsn 49439
  46. 161122 20:41:49 InnoDB: Database was not shut down normally!
  47. InnoDB: Starting crash recovery.
  48. InnoDB: Reading tablespace information from the .ibd files...
  49. InnoDB: Restoring possible half-written data pages from the doublewrite
  50. InnoDB: buffer...
  51. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  52. 161122 20:41:49 InnoDB: Starting an apply batch of log records to the database...
  53. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  54. InnoDB: Apply batch completed
  55. 161122 20:41:49 InnoDB: Waiting for the background threads to start
  56. 161122 20:41:50 InnoDB: 5.5.48 started; log sequence number 1595675
  57. 161122 20:41:50 [Note] Recovering after a crash using mysql-bin
  58. 161122 20:41:50 [Note] Starting crash recovery...
  59. 161122 20:41:50 [Note] Crash recovery finished.
  60. 161122 20:41:50 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  61. 161122 20:41:50 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  62. 161122 20:41:50 [Note] Server socket created on IP: '0.0.0.0'.
  63. 161122 20:41:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  64. 161122 20:41:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  65. 161122 20:49:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  66. 161122 20:49:15 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 21503 ...
  67. 161122 20:49:15 [Note] Plugin 'FEDERATED' is disabled.
  68. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  69. 161122 20:49:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  70. 161122 20:49:15 InnoDB: The InnoDB memory heap is disabled
  71. 161122 20:49:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  72. 161122 20:49:15 InnoDB: Compressed tables use zlib 1.2.7
  73. 161122 20:49:15 InnoDB: Initializing buffer pool, size = 256.0M
  74. 161122 20:49:15 InnoDB: Completed initialization of buffer pool
  75. 161122 20:49:15 InnoDB: highest supported file format is Barracuda.
  76. InnoDB: Log scan progressed past the checkpoint lsn 49439
  77. 161122 20:49:15 InnoDB: Database was not shut down normally!
  78. InnoDB: Starting crash recovery.
  79. InnoDB: Reading tablespace information from the .ibd files...
  80. InnoDB: Restoring possible half-written data pages from the doublewrite
  81. InnoDB: buffer...
  82. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  83. 161122 20:49:15 InnoDB: Starting an apply batch of log records to the database...
  84. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  85. InnoDB: Apply batch completed
  86. 161122 20:49:16 InnoDB: Waiting for the background threads to start
  87. 161122 20:49:17 InnoDB: 5.5.48 started; log sequence number 1595675
  88. 161122 20:49:17 [Note] Recovering after a crash using mysql-bin
  89. 161122 20:49:17 [Note] Starting crash recovery...
  90. 161122 20:49:17 [Note] Crash recovery finished.
  91. 161122 20:49:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  92. 161122 20:49:17 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  93. 161122 20:49:17 [Note] Server socket created on IP: '0.0.0.0'.
  94. 161122 20:49:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  95. 161122 20:49:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
  96. 161122 20:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  97. 161122 20:59:31 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 22099 ...
  98. 161122 20:59:31 [Note] Plugin 'FEDERATED' is disabled.
  99. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
  100. 161122 20:59:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  101. 161122 20:59:31 InnoDB: The InnoDB memory heap is disabled
  102. 161122 20:59:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  103. 161122 20:59:31 InnoDB: Compressed tables use zlib 1.2.7
  104. 161122 20:59:31 InnoDB: Initializing buffer pool, size = 256.0M
  105. 161122 20:59:31 InnoDB: Completed initialization of buffer pool
  106. 161122 20:59:31 InnoDB: highest supported file format is Barracuda.
  107. InnoDB: Log scan progressed past the checkpoint lsn 49439
  108. 161122 20:59:31 InnoDB: Database was not shut down normally!
  109. InnoDB: Starting crash recovery.
  110. InnoDB: Reading tablespace information from the .ibd files...
  111. InnoDB: Restoring possible half-written data pages from the doublewrite
  112. InnoDB: buffer...
  113. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  114. 161122 20:59:31 InnoDB: Starting an apply batch of log records to the database...
  115. InnoDB: Progress in percents: 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  116. InnoDB: Apply batch completed
  117. 161122 20:59:32 InnoDB: Waiting for the background threads to start
  118. 161122 20:59:33 InnoDB: 5.5.48 started; log sequence number 1595675
  119. 161122 20:59:33 [Note] Recovering after a crash using mysql-bin
  120. 161122 20:59:33 [Note] Starting crash recovery...
  121. 161122 20:59:33 [Note] Crash recovery finished.
  122. 161122 20:59:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  123. 161122 20:59:33 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  124. 161122 20:59:33 [Note] Server socket created on IP: '0.0.0.0'.
  125. 161122 20:59:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  126. 161122 20:59:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
复制代码

本帖子中包含更多资源

您需要 登录 才可以下载或查看，没有账号？注册

x
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

licess
发表于 2016-11-23 09:51:08 | 显示全部楼层

df -h
检测一下磁盘或分区是否满了

161122 20:59:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
有表缺失估计可能被误删
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

xiaoxue
 楼主| 发表于 2016-11-23 10:12:32 | 显示全部楼层

回复 3# 的帖子




[root@yidong ~]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1        20G  4.9G   14G  27% /
devtmpfs        1.9G     0  1.9G   0% /dev
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           1.9G  312K  1.9G   1% /run
tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
tmpfs           380M     0  380M   0% /run/user/0
[root@yidong ~]#


没满呀
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

xiaoxue
 楼主| 发表于 2016-11-23 11:09:54 | 显示全部楼层

回复 3# 的帖子


全新vps
两台都是一样的问题...

军哥运维代购：http://shop63846532.taobao.com/
回复 支持 反对

举报

licess
发表于 2016-11-23 14:29:05 | 显示全部楼层

传安装日志看一下
回复 支持 反对

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-9-28 11:19 , Processed in 0.028457 second(s), 17 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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