军哥，Mysql启动不了 Starting MySQL... ERROR! The server quit without updating PID file

2966980 发表于 2016-3-16 18:00:05

启动mysql时提示 Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/VM_75_73_centos.pid).

vim /usr/local/mysql/var/VM_75_73_centos.err 得到以下内容，请问要怎么解决？151111 11:40:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2015-11-11 11:40:06 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-11 11:40:06 27696 Plugin 'FEDERATED' is disabled.
2015-11-11 11:40:06 7ff165c1d780 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-11 11:40:06 27696 InnoDB: Using atomics to ref count buffer pool pages
2015-11-11 11:40:06 27696 InnoDB: The InnoDB memory heap is disabled
2015-11-11 11:40:06 27696 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-11 11:40:06 27696 InnoDB: Memory barrier is not used
2015-11-11 11:40:06 27696 InnoDB: Compressed tables use zlib 1.2.7
2015-11-11 11:40:06 27696 InnoDB: Not using CPU crc32 instructions
2015-11-11 11:40:06 27696 InnoDB: Initializing buffer pool, size = 16.0M
2015-11-11 11:40:06 27696 InnoDB: Completed initialization of buffer pool
2015-11-11 11:40:06 27696 InnoDB: Highest supported file format is Barracuda.
2015-11-11 11:40:06 27696 InnoDB: 128 rollback segment(s) are active.
2015-11-11 11:40:06 27696 InnoDB: Waiting for purge to start
2015-11-11 11:40:06 27696 InnoDB: 5.6.23 started; log sequence number 1625994
2015-11-11 11:40:06 27696 No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e63c77f9-8825-11e5-8553-5254001ea1a3.
2015-11-11 11:40:06 27696 Server hostname (bind-address): '*'; port: 3306
2015-11-11 11:40:06 27696 IPv6 is available.
2015-11-11 11:40:06 27696 - '::' resolves to '::';
2015-11-11 11:40:06 27696 Server socket created on IP: '::'.
2015-11-11 11:40:06 27696 Event Scheduler: Loaded 0 events
2015-11-11 11:40:06 27696 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
2015-11-11 11:40:06 27696 /usr/local/mysql/bin/mysqld: Normal shutdown

2015-11-11 11:40:06 27696 Giving 0 client threads a chance to die gracefully
2015-11-11 11:40:06 27696 Event Scheduler: Purging the queue. 0 events
2015-11-11 11:40:06 27696 Shutting down slave threads
2015-11-11 11:40:06 27696 Forcefully disconnecting 0 remaining clients
2015-11-11 11:40:06 27696 Binlog end
2015-11-11 11:40:06 27696 Shutting down plugin 'partition'
2015-11-11 11:40:06 27696 Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_DELETED'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_METRICS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-11 11:40:06 27696 Shutting down plugin 'INNODB_BUFFER_PAGE'

port    = 3306
socket    = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server

port    = 3306
socket    = /tmp/mysql.sock
datadir = /usr/local/mysql/var

[ 本帖最后由 2966980 于 2016-3-16 18:15 编辑 ]

licess 发表于 2016-3-16 19:52:15

日志是以前的不是现在的，直接上传完整文件

kcersing 发表于 2016-3-18 08:55:21

我也碰到这个错误了。

licess 发表于 2016-3-18 12:52:57

回复 3# 的帖子

日志日志日志

明月出天山 发表于 2016-4-5 21:36:50

160405 20:32:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2016-04-05 20:32:20 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-05 20:32:20 8151 ignore-builtin-innodb is ignored and will be removed in future releases.
2016-04-05 20:32:20 8151 The option innodb (skip-innodb) is deprecated and will be removed in a future release
2016-04-05 20:32:20 8151 The option innodb (skip-innodb) is deprecated and will be removed in a future release
2016-04-05 20:32:20 8151 Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 Using unique option prefix innodb-cmp-per-index instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 Plugin 'InnoDB' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_TRX' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_LOCK_WAITS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_CMP_RESET' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_CMPMEM' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_CMPMEM_RESET' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_BUFFER_PAGE' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_METRICS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_DELETED' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_CONFIG' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_TABLES' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_INDEXES' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_COLUMNS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_FIELDS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_FOREIGN' is disabled.
2016-04-05 20:32:20 8151 Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2016-04-05 20:32:20 8151 Plugin 'FEDERATED' is disabled.
2016-04-05 20:32:20 8151 /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'
2016-04-05 20:32:21 8151 No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 71239c64-fb2a-11e5-b355-deaab89eecc6.
2016-04-05 20:32:21 8151 Server hostname (bind-address): '*'; port: 3306
2016-04-05 20:32:21 8151 IPv6 is available.
2016-04-05 20:32:21 8151 - '::' resolves to '::';
2016-04-05 20:32:21 8151 Server socket created on IP: '::'.
2016-04-05 20:32:21 8151 Event Scheduler: Loaded 0 events
2016-04-05 20:32:21 8151 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
2016-04-05 20:32:22 8151 /usr/local/mysql/bin/mysqld: Normal shutdown

2016-04-05 20:32:22 8151 Giving 0 client threads a chance to die gracefully
2016-04-05 20:32:22 8151 Event Scheduler: Purging the queue. 0 events
2016-04-05 20:32:22 8151 Shutting down slave threads
2016-04-05 20:32:22 8151 Forcefully disconnecting 0 remaining clients
2016-04-05 20:32:22 8151 Binlog end
2016-04-05 20:32:22 8151 Shutting down plugin 'partition'
2016-04-05 20:32:22 8151 Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-05 20:32:22 8151 Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-05 20:32:22 8151 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-05 20:32:22 8151 Shutting down plugin 'INNODB_CMP'
2016-04-05 20:32:22 8151 Shutting down plugin 'INNODB_LOCKS'
2016-04-05 20:32:22 8151 Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-05 20:32:22 8151 Shutting down plugin 'ARCHIVE'
2016-04-05 20:32:22 8151 Shutting down plugin 'BLACKHOLE'
2016-04-05 20:32:22 8151 Shutting down plugin 'MyISAM'
2016-04-05 20:32:22 8151 Shutting down plugin 'MRG_MYISAM'
2016-04-05 20:32:22 8151 Shutting down plugin 'CSV'
2016-04-05 20:32:22 8151 Shutting down plugin 'MEMORY'
2016-04-05 20:32:22 8151 Shutting down plugin 'sha256_password'
2016-04-05 20:32:22 8151 Shutting down plugin 'mysql_old_password'
2016-04-05 20:32:22 8151 Shutting down plugin 'mysql_native_password'
2016-04-05 20:32:22 8151 Shutting down plugin 'binlog'
2016-04-05 20:32:22 8151 /usr/local/mysql/bin/mysqld: Shutdown complete

160405 20:32:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 20:32:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 20:32:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 20:39:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 20:39:42 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:09:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:09:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:21:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:21:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:22:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:22:39 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:24:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:24:26 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:24:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:25:00 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:25:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:25:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended

刚安装的lnmp1.2，mysql无法启动

licess 发表于 2016-4-6 12:57:50

回复 5# 的帖子

里面没有有用的信息，上传安装日志看一下

页: [1]

VPS侦探论坛's Archiver