Проблема запуска mysql в ubuntu 20.04 LTS?

Question

Назар Вельков @nazarvelkov

Проблема запуска mysql в ubuntu 20.04 LTS?

Добрый день, помогите пожалуйста работал zabbix на ubuntu 20.04 несколько лет и вдруг перестал запускать mysql
При запуске вот такая ошибка

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

systemctl status mysql

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (start) since Wed 2023-09-20 13:45:01 UTC; 1s ago
    Process: 96020 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
   Main PID: 96028 (mysqld)
     Status: "Server startup in progress"
      Error: 2 (No such file or directory)
      Tasks: 25 (limit: 4595)
     Memory: 479.6M
     CGroup: /system.slice/mysql.service
             └─96028 /usr/sbin/mysqld

сен 20 13:45:01 zabbix systemd[1]: Starting MySQL Community Server...

в журнале journalctl -xe

- Процесс остановки юнита mysql.service был завершен.
сен 20 13:46:01 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Начинается запуск юнита mysql.service
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Начат процесс запуска юнита mysql.service.
сен 20 13:46:05 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- An ExecStart= process belonging to unit mysql.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
сен 20 13:46:05 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
сен 20 13:46:05 zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: Ошибка юнита mysql.service
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Произошел сбой юнита mysql.service.
--
-- Результат: failed.
сен 20 13:46:05 zabbix systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1686.
-- Subject: Назначен автоматический перезапуск юнита
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Назначен автоматический перезапуск юнита mysql.service, так как для него был задан
-- параметр Restart=.
сен 20 13:46:05 zabbix systemd[1]: Stopped MySQL Community Server.
-- Subject: Завершена остановка юнита mysql.service.
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Процесс остановки юнита mysql.service был завершен.
сен 20 13:46:05 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Начинается запуск юнита mysql.service
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Начат процесс запуска юнита mysql.service.

В error.log

mysqld: File './binlog.002664' not found (OS errno 2 - No such file or directory)
2023-09-20T00:03:47.221332Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2023-09-20T00:03:47.221348Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2023-09-20T00:03:47.221393Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-09-20T00:03:48.779791Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34-0ubuntu0.20.04.1)  (Ubuntu).
2023-09-20T00:03:49.363875Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds inst>
2023-09-20T00:03:49.365394Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 2024429
2023-09-20T00:03:49.389227Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-20T00:03:50.178306Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.