mariadb启动报错:Failed to start MariaDB database server

àì夳堔傛蜴生んèń 2022-05-21 11:12 628阅读 0赞

**mariadb启动报错:Failed to start MariaDB database server**

背景：很奇怪，mysql一直运行好好的，突然连不上去了，查看进程，发现mysql进程都没有了！！！
    
    [root@host-39-108-217-12 mariadb]# systemctl status mariadb.service
    mariadb.service - MariaDB database server
    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
    Active: failed (Result: exit-code) since Fri 2018-07-06 08:54:32 CST; 1min 18s ago
    Process: 29269 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
    Process: 29268 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
    Process: 29238 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
    Main PID: 29268 (code=exited, status=0/SUCCESS)
    
    Jul 06 08:54:31 host-39-108-217-12 systemd[1]: Starting MariaDB database server...
    Jul 06 08:54:31 host-39-108-217-12 mariadb-prepare-db-dir[29238]: Database MariaDB is probably initialized in /var/lib/mysql/data already, nothing is done.
    Jul 06 08:54:31 host-39-108-217-12 mysqld_safe[29268]: 180706 08:54:31 mysqld_safe Logging to '/var/lib/mysql/logs/mariadb.log'.
    Jul 06 08:54:31 host-39-108-217-12 mysqld_safe[29268]: 180706 08:54:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data
    Jul 06 08:54:32 host-39-108-217-12 systemd[1]: mariadb.service: control process exited, code=exited status=1
    Jul 06 08:54:32 host-39-108-217-12 systemd[1]: Failed to start MariaDB database server.
    Jul 06 08:54:32 host-39-108-217-12 systemd[1]: Unit mariadb.service entered failed state.
    Jul 06 08:54:32 host-39-108-217-12 systemd[1]: mariadb.service failed.
    
    查看mariadb错误信息
    [root@host-39-108-217-12 mariadb]#  grep 'ERROR' /var/lib/mysql/logs/mariadb.log 
    180706  8:47:23 [ERROR] Plugin 'InnoDB' init function returned error.
    180706  8:47:23 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180706  8:47:23 [ERROR] Unknown/unsupported storage engine: InnoDB
    180706  8:47:23 [ERROR] Aborting
    180706  8:48:48 [ERROR] Plugin 'InnoDB' init function returned error.
    180706  8:48:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180706  8:48:48 [ERROR] Unknown/unsupported storage engine: InnoDB
    180706  8:48:48 [ERROR] Aborting
    180706  8:49:38 [ERROR] Plugin 'InnoDB' init function returned error.
    180706  8:49:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180706  8:49:38 [ERROR] Unknown/unsupported storage engine: InnoDB
    180706  8:49:38 [ERROR] Aborting
    180706  8:54:31 [ERROR] Plugin 'InnoDB' init function returned error.
    180706  8:54:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180706  8:54:31 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
    180706  8:54:31 [ERROR] Unknown/unsupported storage engine: InnoDB
    180706  8:54:31 [ERROR] Aborting
    
    经分析发现内存不足，重启一下服务器即可！！！