KeyWeb
11111111111Rating 1.00 (1 Vote)
В какой-то момент перестал запускаться MariaDB сервер, в момент запуска выдавая ошибку:
...
See "systemctl status mariadb.service" and "journalctl -xe" for details.
...
Просмотр journalctl -xe тоже ничего не дал:
mysql-check-socket[27119]: Socket file /var/lib/mysql/mysql.sock exists.
mysql-check-socket[27119]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically.
mysql-prepare-db-dir[27144]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
mysql-prepare-db-dir[27144]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.
mysqld[27182]: 2018-03-28 13:33:07 140081143724224 [Note] /usr/libexec/mysqld (mysqld 10.2.13-MariaDB) starting as process 27182 ...
systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
systemd[1]: Failed to start MariaDB 10.2 database server.
systemd[1]: mariadb.service: Unit entered failed state.
systemd[1]: mariadb.service: Failed with result 'exit-code'.
Смотрим лог:
tail -f /var/log/mariadb/mariadb.log
В результате в моем логе следующая инфа:
[Note] Recovering after a crash using tc.log
[ERROR] Recovery failed! You must enable all engines that were enabled at the moment of the crash
[ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
[ERROR] Can't init tc log
[ERROR] Aborting
Ищем tc.log и удаляем / переименовываем / перемещаем куда-либо, пробуем запустить сервис MariaDB:
systemctl restart mariadb.service
Done!

Добавить комментарий


Обновить
Защитный код

KeyWeb

Сейчас 187 гостей и ни одного зарегистрированного пользователя на сайте

Вверх
Вниз