Ubuntu-fr

Fabzz

Bug start ubuntu et mysql

Bonjour,

Jeudi, mon serveur fonctionnais bien mais depuis 2 jours, impossible de lancer Apache et mysql

Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
 failed!

Journal file /var/log/journal/b5b602f6f2ef4513b35e2a95ff3acf9e/system.journal is truncated, ignoring file.
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: action 'action 2' (module 'builtin:omfile') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 rsyslogd[1285]: file '8' write error: No space left on device [v8.32.0 try http://www.rsyslog.com/e/2027 ]
Mar 18 12:48:50 s21827515 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mar 18 12:48:50 s21827515 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 102.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Mar 18 12:48:50 s21827515 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has finished shutting down.
Mar 18 12:48:50 s21827515 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has begun starting up.
Mar 18 12:48:50 s21827515 audit[16986]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=16986 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Mar 18 12:48:50 s21827515 kernel: audit: type=1400 audit(1552909730.962:94688): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=16986 comm="mysqld" requested_mask="r" denied_mask="r" fsu
Mar 18 12:48:51 s21827515 audit[16991]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=16991 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=112 ouid=0
Mar 18 12:48:51 s21827515 kernel: audit: type=1400 audit(1552909731.014:94689): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=16991 comm="mysqld" requested_mask="r" denied_mask="r" fsu
lines 1062-1123/1123 (END)

Je suis un peu perdu, quelqu'un peut m'expliquer ?

Merci beaucoup !

inbox

Re : Bug start ubuntu et mysql

Salut,

L'une de tes partitions n'a plus de place disponible :

No space left on device

Pour trouver d’où vient le problème, passe les commandes suivantes :

df -H

df -i

A+

---

Un problème résolu ? Indiquez le en modifiant le titre du sujet.

Fabzz

Re : Bug start ubuntu et mysql

Effectivement j'ai plus de place dans /var

Filesystem             Size  Used Avail Use% Mounted on
udev                   4.2G     0  4.2G   0% /dev
tmpfs                  835M  309M  527M  37% /run
/dev/md1               4.2G  725M  3.5G  18% /
/dev/vg00/usr          5.2G  1.3G  3.6G  27% /usr
tmpfs                  4.2G  4.1k  4.2G   1% /dev/shm
tmpfs                  5.3M     0  5.3M   0% /run/lock
tmpfs                  4.2G     0  4.2G   0% /sys/fs/cgroup
/dev/mapper/vg00-var   5.2G  5.2G     0 100% /var
/dev/mapper/vg00-home  5.2G   11M  4.9G   1% /home
tmpfs                  835M     0  835M   0% /run/user/0
tmpfs                  835M     0  835M   0% /run/user/1000

C'est possible d'augmenter la taille ?

Fabzz

Re : Bug start ubuntu et mysql

Pour info, j'ai encore environs 200 GB en SSD non utilise !

Fabzz

Re : Bug start ubuntu et mysql

J'ai réussi !

Pour ceux qui tombe ici voici les manip à faire !

pour augmenter la partition var : lvextend -L +100G /dev/mapper/vg00-var ( pour ajouter 100 GB )
et ensuite : resize2fs /dev/vg00/var ( pour valider l'ajout des GB )

Oubliez pas de redémarrer apache et mysql !

++