The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Mariadb start fail

Hello,

I am reaching out to you because I recently changed my linux server for a new one and after installing Mariadb on it while at the same time, adding a database for one of my site from my old server, I can't make Mariadb start properly.

I have been trying to find an answer for hours now and I've searched all over the internet and tried many different things but none of them seem to work.

I get this error log from "journalctl -xeu mariadb.service" :

déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: Starting MariaDB 11.1.3 database server... déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [Warning] Can't create test file '/var/lib/mysql/P-KSWEB-A-01.lower-test' (Errcode: 13 "Permission denied") déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [Note] Starting MariaDB 11.1.3-MariaDB-1:11.1.3+mariaubu2204 source revision 0f5613a25f27b8034645226a48c2dc1aa4562281 as process 4713 déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] mariadbd: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied") déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] Aborting déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: mariadb.service: Failed with result 'exit-code'. déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: Failed to start MariaDB 11.1.3 database server. déc. 07 19:31:41 P-KSWEB-A-01 systemd[1]: Starting MariaDB 11.1.3 database server...

and this one when checking at "systemctl status mariadb" :

× mariadb.service - MariaDB 11.1.3 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 Thu 2023-12-07 19:31:41 CET; 21h ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 4894 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 4895 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 4897 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 4926 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Main PID: 4926 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" CPU: 75ms

Would you please have an idea of what might cause this and how to resolve it ?

Thank you so much in advance for your help and have a beautiful day.

Kind Regards, ml25

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.