Доброе утро, уважаемые.
Перестал работать сайт системы тикетов (trac).
В логах MySQL выдаеются ошибки следующего характера:
[ERROR] InnoDB: Page [page id: space=0, page number=293] log sequence number 31647540 is in the future! Current system log sequence number 31636$
2018-07-03T05:45:18.542974Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://d$
2018-07-03T05:45:18.543607Z 0 [ERROR] InnoDB: Trying to access page number 4294967295 in space 0, space name innodb_system, which is outside the tablespace bounds. Byte offse$
2018-07-03T05:45:18.543618Z 0 [ERROR] InnoDB: Server exits.
Так же есть ошибки рода
root@lmk:/var/log/mysql# mysqladmin -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Вдруг важно:
при старте вручную
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
failed!
журнал systemctl status mysql.service:
root@lmk:/var/log/mysql# systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Вт 2018-07-03 09:46:49 MSK; 14s ago
Process: 13390 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 13382 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13390 (code=exited, status=1/FAILURE); : 13391 (mysql-systemd-s)
Tasks: 2
Memory: 316.0K
CPU: 280ms
CGroup: /system.slice/mysql.service
└─control
├─13391 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13436 sleep 1
Журнал journalctl -xe:
root@lmk:/var/log/mysql# journalctl -xe
июл 03 09:48:20 lmk audit[13660]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13660/status" pid=13660 comm="mysqld" requested_mask="r" denied
июл 03 09:48:20 lmk kernel: audit: type=1400 audit(1530600500.603:402): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13660/status" pid=13660 comm=
июл 03 09:48:20 lmk systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
июл 03 09:48:50 lmk systemd[1]: Failed to start MySQL Community Server.
-- Subject: Ошибка юнита mysql.service
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Произошел сбой юнита mysql.service.
--
-- Результат: failed.
июл 03 09:48:50 lmk systemd[1]: mysql.service: Unit entered failed state.
июл 03 09:48:50 lmk systemd[1]: mysql.service: Failed with result 'exit-code'.
июл 03 09:48:51 lmk systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
июл 03 09:48:51 lmk systemd[1]: Stopped MySQL Community Server.
-- Subject: Завершена остановка юнита mysql.service.
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Процесс остановки юнита mysql.service был завершен.
июл 03 09:48:51 lmk systemd[1]: Starting MySQL Community Server...
-- Subject: Начинается запуск юнита mysql.service
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Начат процесс запуска юнита mysql.service.
июл 03 09:48:51 lmk audit[13749]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13749/status" pid=13749 comm="mysqld" requested_mask="r" denied
июл 03 09:48:51 lmk audit[13749]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=13749 comm="mysqld" requested_mask="r"
июл 03 09:48:51 lmk audit[13749]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13749/status" pid=13749 comm="mysqld" requested_mask="r" denied
июл 03 09:48:51 lmk kernel: audit: type=1400 audit(1530600531.110:403): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13749/status" pid=13749 comm=
июл 03 09:48:51 lmk kernel: audit: type=1400 audit(1530600531.110:404): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=1374
июл 03 09:48:51 lmk kernel: audit: type=1400 audit(1530600531.110:405): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13749/status" pid=13749 comm=
июл 03 09:48:51 lmk systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
июл 03 09:49:21 lmk systemd[1]: Failed to start MySQL Community Server.
-- Subject: Ошибка юнита mysql.service
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Произошел сбой юнита mysql.service.
--
-- Результат: failed.
июл 03 09:49:21 lmk systemd[1]: mysql.service: Unit entered failed state.
июл 03 09:49:21 lmk systemd[1]: mysql.service: Failed with result 'exit-code'.
Возможно что то еще нужно написать, но я не знаю чего(
Помогите, пожалуйста.