【求助】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-fpmdone

日志：
161122 20:34:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:34:30 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 14390 ...
161122 20:34:30 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:34:30 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:34:30 InnoDB: The InnoDB memory heap is disabled
161122 20:34:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:34:30 InnoDB: Compressed tables use zlib 1.2.7
161122 20:34:30 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:34:30 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!
161122 20:34:30InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
161122 20:34:30InnoDB: 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 64 MB
InnoDB: Database physically writes the file full: wait...
161122 20:34:31InnoDB: 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 64 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
161122 20:34:31InnoDB: Waiting for the background threads to start
161122 20:34:32 InnoDB: 5.5.48 started; log sequence number 0
161122 20:34:32 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:34:32 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:34:32 Server socket created on IP: '0.0.0.0'.
161122 20:34:32 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:34:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:34:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:34:32 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 14938 ...
161122 20:34:32 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:34:32 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:34:32 InnoDB: The InnoDB memory heap is disabled
161122 20:34:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:34:32 InnoDB: Compressed tables use zlib 1.2.7
161122 20:34:32 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:34:32 InnoDB: Completed initialization of buffer pool
161122 20:34:32 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 48941
161122 20:34:32InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:34:32InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:34:33InnoDB: Waiting for the background threads to start
161122 20:34:34 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:34:34 Recovering after a crash using mysql-bin
161122 20:34:34 Starting crash recovery...
161122 20:34:34 Crash recovery finished.
161122 20:34:34 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:34:34 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:34:34 Server socket created on IP: '0.0.0.0'.
161122 20:34:34 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:34:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:34:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:34:34 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 15489 ...
161122 20:34:34 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:34:34 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:34:34 InnoDB: The InnoDB memory heap is disabled
161122 20:34:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:34:34 InnoDB: Compressed tables use zlib 1.2.7
161122 20:34:34 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:34:34 InnoDB: Completed initialization of buffer pool
161122 20:34:34 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 48941
161122 20:34:34InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Warning: database page corruption or a failed
InnoDB: file read of space 0 page 281.
InnoDB: Trying to recover it from the doublewrite buffer.
InnoDB: Recovered the page from the doublewrite buffer.
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:34:35InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:34:35InnoDB: Waiting for the background threads to start
161122 20:34:36 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:34:36 Recovering after a crash using mysql-bin
161122 20:34:36 Starting crash recovery...
161122 20:34:36 Crash recovery finished.
161122 20:34:36 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:34:36 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:34:36 Server socket created on IP: '0.0.0.0'.

xiaoxue 发表于 2016-11-22 23:00:16

接上面161122 20:34:36 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:34:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:41:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:41:27 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 20214 ...
161122 20:41:27 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:41:27 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:41:27 InnoDB: The InnoDB memory heap is disabled
161122 20:41:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:41:27 InnoDB: Compressed tables use zlib 1.2.7
161122 20:41:27 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:41:27 InnoDB: Completed initialization of buffer pool
161122 20:41:27 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49439
161122 20:41:27 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:41:27 InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:41:27 InnoDB: Waiting for the background threads to start
161122 20:41:28 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:41:28 Recovering after a crash using mysql-bin
161122 20:41:28 Starting crash recovery...
161122 20:41:28 Crash recovery finished.
161122 20:41:28 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:41:28 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:41:28 Server socket created on IP: '0.0.0.0'.
161122 20:41:28 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:41:28 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:41:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:41:49 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 20844 ...
161122 20:41:49 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:41:49 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:41:49 InnoDB: The InnoDB memory heap is disabled
161122 20:41:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:41:49 InnoDB: Compressed tables use zlib 1.2.7
161122 20:41:49 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:41:49 InnoDB: Completed initialization of buffer pool
161122 20:41:49 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49439
161122 20:41:49 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:41:49 InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:41:49 InnoDB: Waiting for the background threads to start
161122 20:41:50 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:41:50 Recovering after a crash using mysql-bin
161122 20:41:50 Starting crash recovery...
161122 20:41:50 Crash recovery finished.
161122 20:41:50 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:41:50 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:41:50 Server socket created on IP: '0.0.0.0'.
161122 20:41:50 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:41:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:49:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:49:15 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 21503 ...
161122 20:49:15 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:49:15 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:49:15 InnoDB: The InnoDB memory heap is disabled
161122 20:49:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:49:15 InnoDB: Compressed tables use zlib 1.2.7
161122 20:49:15 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:49:15 InnoDB: Completed initialization of buffer pool
161122 20:49:15 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49439
161122 20:49:15 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:49:15 InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:49:16 InnoDB: Waiting for the background threads to start
161122 20:49:17 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:49:17 Recovering after a crash using mysql-bin
161122 20:49:17 Starting crash recovery...
161122 20:49:17 Crash recovery finished.
161122 20:49:17 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:49:17 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:49:17 Server socket created on IP: '0.0.0.0'.
161122 20:49:17 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:49:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended
161122 20:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
161122 20:59:31 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 22099 ...
161122 20:59:31 Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
161122 20:59:31 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161122 20:59:31 InnoDB: The InnoDB memory heap is disabled
161122 20:59:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161122 20:59:31 InnoDB: Compressed tables use zlib 1.2.7
161122 20:59:31 InnoDB: Initializing buffer pool, size = 256.0M
161122 20:59:31 InnoDB: Completed initialization of buffer pool
161122 20:59:31 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49439
161122 20:59:31 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
161122 20:59:31 InnoDB: Starting an apply batch of log records to the database...
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
InnoDB: Apply batch completed
161122 20:59:32 InnoDB: Waiting for the background threads to start
161122 20:59:33 InnoDB: 5.5.48 started; log sequence number 1595675
161122 20:59:33 Recovering after a crash using mysql-bin
161122 20:59:33 Starting crash recovery...
161122 20:59:33 Crash recovery finished.
161122 20:59:33 Server hostname (bind-address): '0.0.0.0'; port: 3306
161122 20:59:33 - '0.0.0.0' resolves to '0.0.0.0';
161122 20:59:33 Server socket created on IP: '0.0.0.0'.
161122 20:59:33 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
161122 20:59:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/laodcn.novalocal.pid ended

licess 发表于 2016-11-23 09:51:08

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

161122 20:59:33 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
有表缺失估计可能被误删

xiaoxue 发表于 2016-11-23 10:12:32

回复 3# 的帖子

# df -h
Filesystem    SizeUsed Avail Use% Mounted on
/dev/vda1    20G4.9G 14G27% /
devtmpfs    1.9G 01.9G 0% /dev
tmpfs       1.9G 01.9G 0% /dev/shm
tmpfs       1.9G312K1.9G 1% /run
tmpfs       1.9G 01.9G 0% /sys/fs/cgroup
tmpfs       380M 0380M 0% /run/user/0
#

没满呀

xiaoxue 发表于 2016-11-23 11:09:54

回复 3# 的帖子

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

licess 发表于 2016-11-23 14:29:05

传安装日志看一下

页: [1]

VPS侦探论坛's Archiver