Issue

机器断电，重启之后，发现mariadb服务启动不了

Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[1]: Starting MariaDB 10.1 database server...
Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[105086]: Failed at step USER spawning /usr/libexec/mysql-check-socket: No such process
Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[1]: mariadb.service: control process exited, code=exited status=217
Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[1]: Failed to start MariaDB 10.1 database server.
Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[1]: Unit mariadb.service entered failed state.
Sep 19 08:37:34 cloud-sz-kolla-b13-01.sz.cloud.genomics.cn systemd[1]: mariadb.service failed.

查看mariadb服务文件

[Unit]
Description=MariaDB 10.1 database server
After=syslog.target
After=network.target

[Service]
Type=notify
User=mysql
Group=mysql

ExecStartPre=/usr/libexec/mysql-check-socket

但系统中没有mysql用户

# id mysql
id: mysql: no such user

在/etc/passwd，/etc/group中添加user, group ，再启动mariadb服务,服务启动成功，但数据库并没有成功启动

                                                                                                2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: The log sequence numbers 45852950 and 45852950 in ibdata files do not match the log sequence number 45852970 in the ib_logfiles!
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Database was not shutdown normally!
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Starting crash recovery.
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Restoring possible half-written data pages
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: from the doublewrite buffer...
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-19  9:08:42 140172666583232 [Note] InnoDB: Waiting for purge to start
2018-09-19  9:08:42 140172666583232 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 45852970
2018-09-19  9:08:42 140171777382144 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-09-19  9:08:42 140172666583232 [Note] Plugin 'FEEDBACK' is disabled.
2018-09-19  9:08:42 140172666583232 [Warning] GSSAPI plugin : default principal 'mariadb/cloud-sz-kolla-b13-01.sz.cloud.genomics.cn@' not found in keytab
2018-09-19  9:08:42 140172666583232 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty.
2018-09-19  9:08:42 140172666583232 [ERROR] Plugin 'gssapi' init function returned error.
2018-09-19  9:08:42 140172666583232 [Note] Recovering after a crash using tc.log
2018-09-19  9:08:42 140172666583232 [Note] Starting crash recovery...
2018-09-19  9:08:42 140172666583232 [Note] Crash recovery finished.
2018-09-19  9:08:42 140172666583232 [Note] Server socket created on IP: '::'.
2018-09-19  9:08:42 140172577716992 [ERROR] mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 13 "Permission denied")
2018-09-19  9:08:42 140172577716992 [ERROR] Can't start server: can't create PID file: Permission denied

权限问题 # chown mysql:mysql /var/run/mariadb

解决。

todaygood / linux-lab

Failed at step USER spawning /usr/libexec/mysql-check-socket: No such process #3

Issue