Hallo Community,
ich wollte auf einem LAMP-Server mysql durch mariadb ersetzen und bin dabei der Anleitung im Wiki MariaDB (Wechsel von MySQL nach MariaDB) gefolgt, habe also alles mit mysql (mysql-server, php7.2-mysql, mysql-common und weitere mysql-Pakete) vom Server runter geschmissen. Natürlich habe ich vorher eine Sicherung der Datenbanken durchgeführt. Danach habe ich mariadb installiert.
Leider läuft der Server nicht und ich werde aus den Meldungen nicht ganz schlau:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | root@hostname /home/user # service mysql start Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details. root@hostname /home/user # systemctl status mariadb.service ● mariadb.service - MariaDB 10.1.38 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: timeout) since Wed 2019-05-08 14:21:12 CEST; 26s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 16372 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 16297 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 16295 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 16294 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 16372 (code=exited, status=0/SUCCESS) Mai 08 14:19:39 hostname systemd[1]: Starting MariaDB 10.1.38 database server... Mai 08 14:19:40 hostname mysqld[16372]: 2019-05-08 14:19:40 140060760763520 [Note] /usr/sbin/mysqld (mysqld 10.1.38-MariaDB-0ubuntu0.18.04.1) starting as process 16372 ... Mai 08 14:21:10 hostname systemd[1]: mariadb.service: Start operation timed out. Terminating. Mai 08 14:21:12 hostname systemd[1]: mariadb.service: Failed with result 'timeout'. Mai 08 14:21:12 hostname systemd[1]: Failed to start MariaDB 10.1.38 database server. root@hostname /home/user # journalctl -xe Mai 08 14:19:23 hostname kernel: audit: type=1400 audit(1557317963.513:117): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:19:23 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:23 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:24 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:24 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:25 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:25 hostname audit[16178]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16178 comm="mysqld" requested_mask Mai 08 14:19:25 hostname systemd[1]: Stopped MariaDB 10.1.38 database server. -- Subject: Unit mariadb.service has finished shutting down -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- Unit mariadb.service has finished shutting down. Mai 08 14:19:39 agu-hochschulen.de systemd[1]: Starting MariaDB 10.1.38 database server... -- Subject: Unit mariadb.service has begun start-up -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- Unit mariadb.service has begun starting up. Mai 08 14:19:40 hostname mysqld[16372]: 2019-05-08 14:19:40 140060760763520 [Note] /usr/sbin/mysqld (mysqld 10.1.38-MariaDB-0ubuntu0.18.04.1) starting as process 16372 ... Mai 08 14:19:40 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:19:40 hostname kernel: kauditd_printk_skb: 6 callbacks suppressed Mai 08 14:19:40 hostname kernel: audit: type=1400 audit(1557317980.557:124): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:20:01 hostname CRON[16420]: pam_unix(cron:session): session opened for user smmsp by (uid=0) Mai 08 14:20:01 hostname CRON[16421]: (smmsp) CMD (test -x /etc/init.d/sendmail && test -x /usr/share/sendmail/sendmail && test -x /usr/lib/sm.bin/sendmail && /usr/share/sendmail/sendmail cron-msp) Mai 08 14:20:01 hostname CRON[16420]: pam_unix(cron:session): session closed for user smmsp Mai 08 14:21:10 hostname systemd[1]: mariadb.service: Start operation timed out. Terminating. Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.165:125): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.269:126): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.365:127): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.465:128): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.569:129): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.669:130): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:10 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:10 hostname kernel: audit: type=1400 audit(1557318070.769:131): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:11 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:11 hostname kernel: audit: type=1400 audit(1557318071.673:132): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:11 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:11 hostname kernel: audit: type=1400 audit(1557318071.693:133): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:12 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:12 hostname audit[16372]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=16372 comm="mysqld" requested_mask Mai 08 14:21:12 hostname kernel: audit: type=1400 audit(1557318072.329:134): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid= Mai 08 14:21:12 hostname systemd[1]: mariadb.service: Failed with result 'timeout'. Mai 08 14:21:12 hostname systemd[1]: Failed to start MariaDB 10.1.38 database server. -- Subject: Unit mariadb.service has failed -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- Unit mariadb.service has failed. -- -- The result is RESULT. lines 1659-1715/1715 (END) |
Hat jemand eine Idee woran es liegt das mariadb nicht laufen will?
Vielen Dank für Euer Wissen
Gruß
Christofer