VPS侦探论坛

 找回密码
 注册
查看: 6616|回复: 1

Starting MySQL. ERROR! The server quit without updating PID file

[复制链接]
发表于 2016-9-18 12:45:30 | 显示全部楼层 |阅读模式

[root@maker var]# 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).
[root@maker var]#


主机是VMware 虚拟机,服务器故障强制关机,现在数据库无法启动。

160918 12:20:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var2016-09-18 12:20:41 0 [Warning] 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 [Warning] ignore-builtin-innodb is ignored and will be removed in future releases.2016-09-18 12:20:41 15881 [Note] Plugin 'FEDERATED' is disabled.2016-09-18 12:20:41 15881 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release2016-09-18 12:20:41 15881 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release2016-09-18 12:20:41 15881 [Warning] 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 [Warning] 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 [Warning] 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 [Note] Plugin 'InnoDB' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_TRX' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_CMP_RESET' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_CMPMEM' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_METRICS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_DELETED' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.2016-09-18 12:20:41 15881 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.2016-09-18 12:20:41 15881 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'2016-09-18 12:20:41 15881 [Note] Server hostname (bind-address): '*'; port: 33062016-09-18 12:20:41 15881 [Note] IPv6 is available.2016-09-18 12:20:41 15881 [Note]   - '::' resolves to '::';2016-09-18 12:20:41 15881 [Note] Server socket created on IP: '::'.2016-09-18 12:20:41 15881 [ERROR] Can't start server : Bind on unix socket: Input/output error2016-09-18 12:20:41 15881 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?2016-09-18 12:20:41 15881 [ERROR] Aborting2016-09-18 12:20:41 15881 [Note] Binlog end2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'partition'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'BLACKHOLE'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'ARCHIVE'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'INNODB_CMP'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'INNODB_LOCKS'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'MRG_MYISAM'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'MEMORY'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'CSV'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'MyISAM'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'sha256_password'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'mysql_old_password'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'mysql_native_password'2016-09-18 12:20:41 15881 [Note] Shutting down plugin 'binlog'2016-09-18 12:20:41 15881 [Note] /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
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2016-9-18 13:37:23 | 显示全部楼层


你提供的日志里只有  [ERROR] Can't start server : Bind on unix socket: Input/output error2016-09-18 12:20:41 15881 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?2016-09-18 12:20:41 15881 [ERROR] Aborting 这个错误,这个错误是有其他程序以及占用/tmp/mysql.sock

别没其他错误,是否修改过my.cnf?
把日志用代码形式发
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-11-16 23:52 , Processed in 0.025505 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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