Problème MYSQL

[sameheddine]

Bonjour,
J'ai télécharger la VM ZAbbix 4.2 elle a marché correctement mais depuis 1 semaine j'ai ce message d'erreur:

Database error

• Error connecting to database: No such file or directory

Rien n'a été modifier sur la VM.

quand je veux démarrer mysql j'ai ça:

root@zabbix:/home/appliance# service mysql stop
root@zabbix:/home/appliance# service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@zabbix:/home/appliance#
root@zabbix:/home/appliance#
root@zabbix:/home/appliance# 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 Mon 2019-07-08 12:40:17 CET; 11s ago
Process: 5236 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 5227 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 5236 (code=exited, status=1/FAILURE); : 5237 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
└─control
├─5237 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─5276 sleep 1

Jul 08 12:40:17 zabbix systemd[1]: Starting MySQL Community Server...
Jul 08 12:40:19 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
root@zabbix:/home/appliance#
root@zabbix:/home/appliance#
root@zabbix:/home/appliance#
root@zabbix:/home/appliance# journalctl -xe
-- Unit mysql.service has finished shutting down.
Jul 08 12:39:16 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has begun starting up.
Jul 08 12:39:16 zabbix audit[5057]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5057/status" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:16 zabbix audit[5057]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:39:16 zabbix audit[5057]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5057/status" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:16 zabbix kernel: audit: type=1400 audit(1562585956.982:142): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5057/status" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:16 zabbix kernel: audit: type=1400 audit(1562585956.982:143): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:39:16 zabbix kernel: audit: type=1400 audit(1562585956.982:144): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5057/status" pid=5057 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:18 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 08 12:39:47 zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Jul 08 12:39:47 zabbix systemd[1]: mysql.service: Unit entered failed state.
Jul 08 12:39:47 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 08 12:39:47 zabbix systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jul 08 12:39:47 zabbix systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jul 08 12:39:47 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has begun starting up.
Jul 08 12:39:47 zabbix audit[5145]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5145/status" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:47 zabbix audit[5145]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:39:47 zabbix audit[5145]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5145/status" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:47 zabbix kernel: audit: type=1400 audit(1562585987.491:145): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5145/status" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:47 zabbix kernel: audit: type=1400 audit(1562585987.491:146): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:39:47 zabbix kernel: audit: type=1400 audit(1562585987.491:147): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5145/status" pid=5145 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:39:49 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jul 08 12:40:17 zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Jul 08 12:40:17 zabbix systemd[1]: mysql.service: Unit entered failed state.
Jul 08 12:40:17 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 08 12:40:17 zabbix systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jul 08 12:40:17 zabbix systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jul 08 12:40:17 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman.../systemd-devel
--
-- Unit mysql.service has begun starting up.
Jul 08 12:40:17 zabbix audit[5236]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5236/status" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:40:17 zabbix audit[5236]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:40:17 zabbix audit[5236]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5236/status" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:40:18 zabbix kernel: audit: type=1400 audit(1562586017.999:148): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5236/status" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:40:18 zabbix kernel: audit: type=1400 audit(1562586017.999:149): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=0
Jul 08 12:40:18 zabbix kernel: audit: type=1400 audit(1562586017.999:150): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/5236/status" pid=5236 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Jul 08 12:40:19 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

root@zabbix:/home/appliance#
root@zabbix:/home/appliance# ps aux |grep mysql
root 5330 0.0 0.0 20672 3048 ? Ss 12:40 0:00 /bin/bash /usr/share/mysql/mysql-systemd-start post
root 5406 0.0 0.0 22348 940 pts/0 S+ 12:41 0:00 grep --color=auto mysql
root@zabbix:/home/appliance#

[steve.destivelle]

Hello,

est-ce que tu peux nous dire s'il reste de la place sur ta VM ?
Est-ce que le FS n'est pas en lecture seule ?
D'autres processus peuvent démarrer ou c'est juste lié à MySQL ?

Steve

[sameheddine]

hello Steve,
voici la taille de la VM:
root@zabbix:/home/appliance# df -h
Filesystem Size Used Avail Use% Mounted on
udev 2.0G 0 2.0G 0% /dev
tmpfs 396M 41M 355M 11% /run
/dev/mapper/zabbix--vg-root 5.1G 5.1G 0 100% /
tmpfs 2.0G 0 2.0G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 2.0G 0 2.0G 0% /sys/fs/cgroup
/dev/sda1 472M 175M 273M 40% /boot
root@zabbix:/home/appliance#

D'autres processus peuvent démarrer ou c'est juste lié à MySQL ? ==> c'est juste lié a MySQL, le service apache démarre correctement
Est-ce que le FS n'est pas en lecture seule ? ==> je n'ai pas fais de modification au niveau de FS j'ai installé la VM avec le VMDK fourni par zabbix

[sameheddine]

voici le message d'erreur depuis l'interface web

[steve.destivelle]

Bonsoir,

le FS / est plein comme le dit le retour de la commande de -h

/dev/mapper/zabbix--vg-root 5.1G 5.1G 0 100% /

Steve