Question
mariadb.service won't start
- Posted on March 6, 2022
- ApacheMariaDBMySQL
Asked by BubblyAquamarineSeaweed
Ubuntu-Version: Ubuntu 20.04 (Focal Fossa)
systemctl status mariadb.service
shows me :
mariadb.service - MariaDB 10.3.34 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Sun 2022-03-06 22:35:05 CET; 40s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 6300 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 6311 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6318 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _W>
Process: 6333 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 6333 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Mär 06 22:35:04 ubuntusrv mysqld[6333]: 2022-03-06 22:35:04 0 [Note] InnoDB: Starting shutdown...
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [ERROR] Plugin 'InnoDB' init function returned error.
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [Note] Plugin 'FEEDBACK' is disabled.
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Mär 06 22:35:05 ubuntusrv mysqld[6333]: 2022-03-06 22:35:05 0 [ERROR] Aborting
Mär 06 22:35:05 ubuntusrv systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mär 06 22:35:05 ubuntusrv systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mär 06 22:35:05 ubuntusrv systemd[1]: Failed to start MariaDB 10.3.34 database server.
The previous mysql 8.3 worked Where did I go wrong?
Submit an answer
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Get our biweekly newsletter
Sign up for Infrastructure as a Newsletter.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Become a contributor
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Hi there,
I could suggest a few things:
If not, clear some files or add some extra storage
You could add some extra RAM and add a SWAP file to have some extra buffer:
https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-22-04
/etc/mysql/mariadb.conf.d/50-server.cnf.Best,
Bobby