在公司的测试环境中,发现所有数据均不展示,经排查发现为MySQL的问题,重启后报如下错误:
[root@mysql-common-01 ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start) since Tue 2021-09-28 10:29:50 CST; 2s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 2868 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Control: 2892 (mysqld)
CGroup: /system.slice/mysqld.service
├─2892 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
└─2895 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Sep 28 10:29:50 mysql-common-01 systemd[1]: Starting MySQL Server…
排查后是磁盘空间满了,无法启动,清理空间后服务科正常启用