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?
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!
Accepted Answer
Hi there,
I could suggest a few things:
- Make sure that you have enough disk space:
df -h
If not, clear some files or add some extra storage
- Make sure that you have enough RAM:
free -m
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
- Finally make sure that your INNODB buffer size does not exceed the available memory on the server. You check that in the MariaDB configuration file. The configuration file is typically located at
/etc/mysql/mariadb.conf.d/50-server.cnf.
Best,
Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.