MYSQL 启动报错 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to
使用PHP查询mysql数据库时,查询速度很慢。于是我重复服务器上的mysql服务 结果 mysql链接不上了,解决了几个小时才能解决。下面总结一下解决的办法
一、报错情况
当我输入以下启动命令进行启动时 发现无法启动了
service mysqld start
MariaDB/mysql
无法启动,日志文件出现如下报错:
[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
详细报错如下图:
1、可能的原因
PLESK
更新过程失败,mysql
链接数据库出现错误消息如下:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
...
Trying to start service mysql... failed
...
server.example.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
server.example.com systemd[1]: Failed to start MariaDB 10.2.13 database server.
server.example.com systemd[1]: Unit mariadb.service entered failed state.
server.example.com systemd[1]: mariadb.service failed.
二、解决办法
ssh连接到服务器,进入到数据目录下,一般在my.cnf
中设置过存储路径,找到即可centos7.9+mariadb路径是/etc/mysql/mariadb.conf.d/server.cnf
):
移除掉aria_log_control
文件:
cd /var/lib/mysql/
# 先更换一下aria_log_control,免得直接删除报错
mv aria_log_control aria_log_control.old
# 重启服务器
service mysqld restart
如果能启动了可以忽略下面的命令,使用命令更新Plesk
:
plesk installer --select-release-current --reinstall-patch --upgrade-installed-components