[[Support] Linuxserver.io - MariaDB]

Hello All,

 

A bit of a noob so bear with me. My server had an abrupt restart, when I fired it back up I'm getting a loop in my MariaDB dockers logs:

 

2021-01-10T18:36:03.756651Z mysqld_safe Starting mysqld daemon with databases from /config/databases

2021-01-10T18:35:59.906132Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

I also found (with the help of these forums) the .err (eefb016d5e2e.err) file:

 

2021-01-10  9:58:24 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2021-01-10  9:58:24 0 [ERROR] Aborting

 

After more digging I tried to issue the following:

 

mysqld --tc-heuristic-recover=ROLLBACK

 

and

 

mysqld --tc-heuristic-recover=COMMIT

 

No luck get the following error:

 

mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2021-01-10T18:39:27.714646Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2021-01-10T18:39:27.714711Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2021-01-10T18:39:27.714732Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-10T18:39:27.714961Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
2021-01-10T18:39:27.714971Z 0 [ERROR] Aborting

 

Appreciate any and all guidance/help