Failed to start MariADB Database Server
Background: It's strange, mysql has been running well, suddenly can not connect up, check the process, found mysql processes are gone!
[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.
View mariadb error messages
[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
The analysis found insufficient memory, just restart the server!
Read More:
- Centos 7 | mariadb/mysql | [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
- Solve the problem of general error: 4047 when docker installs MariaDB of nextcloud
- Connection between PHP 7.4 and MySQL (MariaDB) under Ubuntu (kali Linux)
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- [Solved] Tomcat Failed to Start Error: Server Tomcat v8.5 Server at localhost failed to start
- Error: (serious: a child container failed during start) (server component failed to start so Tomcat is unable)
- Server Tomcat v8.0 Server at localhost failed to start.
- Server Tomcat v7.0 server at localhost failed to start
- Ubuntu failed to start sshd with an error: failed to start OpenBSD secure shell server
- How to solve the failed to start switch root error during centos8.1 startup?
- Local can link to the server database, upload jar package to the server will report an error
- [mysql] “Failed to start MySQL Server” error resolution
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- Tencent Cloud server encountered “Active: failed (Result: start-limit)” error when starting lightdm
- Server operation and maintenance 1-failed to start LSB
- Solution to error 2002 (HY000) in MySQL login startup
- Dm7 Dameng database dmrman reports an error OS_ pipe2_ conn_ Server open failed solution
- 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
- Could not create connection to database server. Attempted reconnect 3 times. Giving
- Building Eureka_ Server error: application failed to start with classpath:file :/C:/ProgramFiles/Java/jdk