Ben_hosted

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