LINUX.ORG.RU
решено ФорумAdmin

после перезагрузки не стартует mariadb

 ,


2

1

mariadb ставил из офф репозитория.Всё работало до перезагрузки.Перезагрузился служба не стартует,удалил всё,установил заново,после перезагрузки такая же проблема.Конфиги не правил,все по дэфолту.Подскажите где искать проблему?С mysql особо не дружу.


palamar@home:~$ sudo /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.
 failed!

palamar@home:~$ journalctl -xe
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: Waiting for purge to start
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] InnoDB: 5.7.21 started; log sequence number 44849714
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140299082897152 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Plugin 'FEEDBACK' is disabled.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Server socket created on IP: '127.0.0.1'.
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] mysql.user has no `Event_priv` column at position 29
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at posit
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Di
Мар 17 15:03:36 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Reading of all Master_info entries succeded
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] Added new Master_info '' to hash table
Мар 17 15:03:36 home mysqld[6373]: 2018-03-17 15:03:36 140300180158656 [Note] /usr/sbin/mysqld: ready for connections.
Мар 17 15:03:36 home mysqld[6373]: Version: '10.2.13-MariaDB-10.2.13+maria~xenial-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary
Мар 17 15:03:36 home kernel: audit: type=1400 audit(1521291816.893:43): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:03:37 home mysqld[6373]: 2018-03-17 15:03:37 140299082897152 [Note] InnoDB: Buffer pool(s) load completed at 180317 15:03:37
Мар 17 15:03:58 home sshd[6414]: Bad protocol version identification '\003' from 10.10.10.10 port 54943
Мар 17 15:05:06 home systemd[1]: mariadb.service: Start operation timed out. Terminating.
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299674679040 [Note] /usr/sbin/mysqld (unknown): Normal shutdown
Мар 17 15:05:06 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299124860672 [Note] InnoDB: FTS optimize thread exiting.
Мар 17 15:05:06 home kernel: audit: type=1400 audit(1521291906.672:44): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299674679040 [Note] InnoDB: Starting shutdown...
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299082897152 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Мар 17 15:05:06 home mysqld[6373]: 2018-03-17 15:05:06 140299082897152 [Note] InnoDB: Buffer pool(s) dump completed at 180317 15:05:06
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] InnoDB: Shutdown completed; log sequence number 44849742
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Мар 17 15:05:07 home mysqld[6373]: 2018-03-17 15:05:07 140299674679040 [Note] /usr/sbin/mysqld: Shutdown complete
Мар 17 15:05:07 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:07 home audit[6373]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
Мар 17 15:05:07 home kernel: audit: type=1400 audit(1521291907.515:45): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:07 home kernel: audit: type=1400 audit(1521291907.515:46): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" e
Мар 17 15:05:07 home systemd[1]: Failed to start MariaDB 10.2.13 database server.
-- Subject: Ошибка юнита mariadb.service
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Произошел сбой юнита mariadb.service.
-- 
-- Результат: failed.
Мар 17 15:05:07 home systemd[1]: mariadb.service: Unit entered failed state.
Мар 17 15:05:07 home systemd[1]: mariadb.service: Failed with result 'timeout'.
Мар 17 15:05:07 home sudo[6194]: pam_unix(sudo:session): session closed for user root

Пальцем в небо, но

aa-disable /usr/sbin/mysqld
systemctl start mariadb

vwvol
()
Ответ на: комментарий от Palamar

По умолчанию была установлена слишком жесткая политика безопасности этой вот штукой

https://ru.wikipedia.org/wiki/AppArmor

Раз помогло, ставь отметку решено.

Twissel ★★★★★
()
Последнее исправление: Twissel (всего исправлений: 1)
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.