Starting MySQL. ERROR! The server quit without updating PID file
# lnmp mysql restart+-------------------------------------------+
| Manager for LNMP, Written by Licess |
+-------------------------------------------+
| http://lnmp.org |
+-------------------------------------------+
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/maker.njtech.edu.cn.pid).
#
主机是VMware 虚拟机,服务器故障强制关机,现在数据库无法启动。
160918 12:20:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var2016-09-18 12:20:41 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-09-18 12:20:41 15881 ignore-builtin-innodb is ignored and will be removed in future releases.2016-09-18 12:20:41 15881 Plugin 'FEDERATED' is disabled.2016-09-18 12:20:41 15881 The option innodb (skip-innodb) is deprecated and will be removed in a future release2016-09-18 12:20:41 15881 The option innodb (skip-innodb) is deprecated and will be removed in a future release2016-09-18 12:20:41 15881 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-09-18 12:20:41 15881 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-09-18 12:20:41 15881 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-09-18 12:20:41 15881 Plugin 'InnoDB' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_TRX' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_LOCK_WAITS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_CMP_RESET' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_CMPMEM' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_CMPMEM_RESET' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_BUFFER_PAGE' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_METRICS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_DELETED' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_BEING_DELETED' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_CONFIG' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_INDEX_CACHE' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_FT_INDEX_TABLE' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_TABLES' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_TABLESTATS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_INDEXES' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_COLUMNS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_FIELDS' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_FOREIGN' is disabled.2016-09-18 12:20:41 15881 Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.2016-09-18 12:20:41 15881 /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'2016-09-18 12:20:41 15881 Server hostname (bind-address): '*'; port: 33062016-09-18 12:20:41 15881 IPv6 is available.2016-09-18 12:20:41 15881 - '::' resolves to '::';2016-09-18 12:20:41 15881 Server socket created on IP: '::'.2016-09-18 12:20:41 15881 Can't start server : Bind on unix socket: Input/output error2016-09-18 12:20:41 15881 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?2016-09-18 12:20:41 15881 Aborting2016-09-18 12:20:41 15881 Binlog end2016-09-18 12:20:41 15881 Shutting down plugin 'partition'2016-09-18 12:20:41 15881 Shutting down plugin 'BLACKHOLE'2016-09-18 12:20:41 15881 Shutting down plugin 'ARCHIVE'2016-09-18 12:20:41 15881 Shutting down plugin 'PERFORMANCE_SCHEMA'2016-09-18 12:20:41 15881 Shutting down plugin 'INNODB_SYS_DATAFILES'2016-09-18 12:20:41 15881 Shutting down plugin 'INNODB_SYS_TABLESPACES'2016-09-18 12:20:41 15881 Shutting down plugin 'INNODB_CMP_PER_INDEX'2016-09-18 12:20:41 15881 Shutting down plugin 'INNODB_CMP'2016-09-18 12:20:41 15881 Shutting down plugin 'INNODB_LOCKS'2016-09-18 12:20:41 15881 Shutting down plugin 'MRG_MYISAM'2016-09-18 12:20:41 15881 Shutting down plugin 'MEMORY'2016-09-18 12:20:41 15881 Shutting down plugin 'CSV'2016-09-18 12:20:41 15881 Shutting down plugin 'MyISAM'2016-09-18 12:20:41 15881 Shutting down plugin 'sha256_password'2016-09-18 12:20:41 15881 Shutting down plugin 'mysql_old_password'2016-09-18 12:20:41 15881 Shutting down plugin 'mysql_native_password'2016-09-18 12:20:41 15881 Shutting down plugin 'binlog'2016-09-18 12:20:41 15881 /usr/local/mysql/bin/mysqld: Shutdown complete160918 12:20:41 mysqld_safe mysqld from pid file /usr/local/mysql/var/maker.njtech.edu.cn.pid ended 你提供的日志里只有 Can't start server : Bind on unix socket: Input/output error2016-09-18 12:20:41 15881 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?2016-09-18 12:20:41 15881 Aborting 这个错误,这个错误是有其他程序以及占用/tmp/mysql.sock
别没其他错误,是否修改过my.cnf?
把日志用代码形式发
页:
[1]