MySQL（ Percona）莫名挂了，求助

[zhjits]

mysql Ver 14.14 Distrib 5.6.25-73.1, for debian-linux-gnu (x86_64) using 6.3

Aug 04 08:42:25 hostname /etc/init.d/mysql[2078]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 04 08:42:25 hostname /etc/init.d/mysql[2078]: [61B blob data]
Aug 04 08:42:25 hostname /etc/init.d/mysql[2078]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 04 08:42:25 hostname /etc/init.d/mysql[2078]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 04 08:42:25 hostname /etc/init.d/mysql[2078]:
Aug 04 08:42:25 hostname systemd[1]: mysql.service: control process exited, code=exited status=1
Aug 04 08:42:25 hostname systemd[1]: Failed to start LSB: Start and stop the mysql (Percona Server) daemon.
-- Subject: Unit mysql.service has failed
-- Unit mysql.service has failed.
Aug 04 08:42:25 hostname systemd[1]: Unit mysql.service entered failed state.
Aug 04 08:42:25 hostname systemd[1]: mysql.service failed.
Aug 04 08:42:25 hostname mysql[1856]: ...fail!


[zhjits]

150804 09:05:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-08-04 09:05:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-04 09:05:12 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 2836 ...
2015-08-04 09:05:13 2836 [ERROR] Failed to initialize timer component (errno 12).
2015-08-04 09:05:13 2836 [Note] Plugin 'FEDERATED' is disabled.
2015-08-04 09:05:13 2836 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-08-04 09:05:13 2836 [Note] Plugin 'InnoDB' is disabled.
2015-08-04 09:05:13 2836 [ERROR] Function 'innodb' already exists
2015-08-04 09:05:13 2836 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-04 09:05:13 2836 [ERROR] Function 'federated' already exists
2015-08-04 09:05:13 2836 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-04 09:05:13 2836 [ERROR] Function 'blackhole' already exists
2015-08-04 09:05:13 2836 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-04 09:05:13 2836 [ERROR] Function 'archive' already exists
2015-08-04 09:05:13 2836 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-04 09:05:13 2836 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-08-04 09:05:13 2836 [ERROR] Aborting

[ipconfiger]

断过电？

[zhjits]

@ipconfiger 没有，不过是 apt-get upgrade 之后出现的

[henryon]

...自己解决了就好。

[pubby]

之前遇到过跨大版本升级导致启动失败
从5.1.x 升级到 5.6.x

后来 先降到5.5.x 用自带mysql_upgrade 升级数据
再升级到 5.6.x ,mysql_upgrade升级数据后才正常