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/.

Unable to start mariadb due DDL recovery/log [Errcode: 13]

I’m encountering an issue while trying to start MariaDB with the command sudo mariadbd-safe start. The error messages I get are:

2024-07-22 20:19:20 0 [Note] Starting MariaDB 11.4.2-MariaDB source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 3621 2024-07-22 20:19:20 0 [ERROR] mariadbd: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied") 2024-07-22 20:19:20 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log 2024-07-22 20:19:20 0 [ERROR] Aborting

It seems to be a permission issue with the file ddl_recovery.log. How can I resolve this?

Answer Answered by Daniel Black in this comment.

by giving it create/write permissions to the MariaDB data directory for the user that ends up running on the mariadbd process.

I see you've used sudo mariadbd-safe, this is probably to a mysql user.

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.