LINUX.ORG.RU

Избранные сообщения Palamar

Форум — Admin

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

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

 ,

Palamar
()