Please Help mon yunohost et semi mort

#1

Bonjour,
je ne sais pas ce qu’il c’est passé mais je n’accéde plus à mes apps depuis interface utilisateur yunohost

et ma boite mail est inondé chaque heure de ce mail :

Reading package lists...
Building dependency tree...
Reading state information...
yunohost is already the newest version (3.5.2.2).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
3 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mariadb-server-10.1 (10.1.38-0+deb9u1) ...
debconf: unable to initialize frontend: Dialog
debconf: (TERM is not set, so the dialog frontend is not usable.)
debconf: falling back to frontend: Readline
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (>= 10.1.38-0+deb9u1); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of yunohost:
 yunohost depends on mariadb-server; however:
  Package mariadb-server is not configured yet.

dpkg: error processing package yunohost (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 mariadb-server
 yunohost
E: Sub-process /usr/bin/dpkg returned an error code (1)

et

/etc/cron.daily/logrotate:
amysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1

que faire pour réparer mon yunohost svp

#2

Bonsoir,
Je sais pas pourquoi, on dirait une mise à jour (update ?) qui bloque !
Tu fais tes maj par l’interface Yunohost ou par apt update, apt dist-upgrade ?

#3

Peut être as tu configuré unattended upgrade (pour faire des mises à jour automatiques) ?

Ton problème c’est que mariadb ne se met pas à jour.

As tu des apps qui installent des sources list particuliers ?

ls /etc/apt/sources.list.d

Peut être que forcer l’installation peut fonctionner, mai sje n’en suis pas du tout certains ? As tu une sauvegarde de ta base de données ?

Essaie ces commandes en refusant de désinstaller yunohost si jamais la question est posée:

service mysql start
apt update
apt full-upgrade
apt install -f
1 Like
#4

Oui je confirme.

Au vu du message mariadb ne s’est pas mis à jour. Donc forcément l’accès à l’interface Web nécessitant le sql, cela ne fonctionnera pas.

Essaye effectivement de forcer la config comme l’indique ljf.

N’hésite pas à nous poster le résultat de tes logs. J’avais eu un souci équivalent sur une debian (pas ynh) avec mariadb que j’ai pu résoudre mais je préfère vérifier les logs pour ne pas aiguiller vers une solution si ce n’est pas la bonne.

#6

Tu es peut être chez Scaleway ?

#7

Il semblerait que d’autres fassent le même genre de choses.
Ça ne coûte rien de regarder le /etc/machine-id quoi qu’il arrive :wink:

#8

ça veut rien savoir :

3 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mariadb-server-10.1 (10.1.38-0+deb9u1) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (>= 10.1.38-0+deb9u1); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of yunohost:
 yunohost depends on mariadb-server; however:
  Package mariadb-server is not configured yet.

dpkg: error processing package yunohost (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 mariadb-server
 yunohost
E: Sub-process /usr/bin/dpkg returned an error code (1)
#9

impossible de démmarer Mysql :

:/home/admin# service mysql start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

je sais plus quoi faire la

#10

systemctl status mariadb.service

#11

voici ce que j’ai :

● mariadb.service - MariaDB 10.1.38 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2019-06-05 18:12:00 BST; 23h ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 964 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 796 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: 657 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 623 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 964 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1996099376 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 127032531
Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1421865792 [Note] InnoDB: Dumping buffer pool(s) not yet started
Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1996099376 [Note] Plugin 'FEEDBACK' is disabled.
Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1996099376 [Note] Recovering after a crash using tc.log
Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1996099376 [ERROR] Can't init tc log
Jun 05 18:11:57 domaine.fr mysqld[964]: 2019-06-05 18:11:57 1996099376 [ERROR] Aborting
Jun 05 18:12:00 domaine.fr systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 05 18:12:00 domaine.fr systemd[1]: Failed to start MariaDB 10.1.38 database server.
Jun 05 18:12:00 domaine.fr systemd[1]: mariadb.service: Unit entered failed state.
Jun 05 18:12:00 domaine.fr systemd[1]: mariadb.service: Failed with result 'exit-code'.

qu’en pensez vous svp

#12

Tu peux tenter :

rm /var/lib/mysql/tc.log
systemctl restart mariadb
1 Like
#13

j’ai ça :

● mariadb.service - MariaDB 10.1.38 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2019-06-06 17:52:34 BST; 8s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1536 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1533 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 1453 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: 1447 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1437 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 1505 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─1505 /usr/sbin/mysqld

Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] InnoDB: Highest supported file format is Barracuda.
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] InnoDB: 128 rollback segment(s) are active.
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] InnoDB: Waiting for purge to start
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 127033037
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1417671488 [Note] InnoDB: Dumping buffer pool(s) not yet started
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] Plugin 'FEEDBACK' is disabled.
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] Server socket created on IP: '::'.
Jun 06 17:52:33 domaine.fr mysqld[1505]: 2019-06-06 17:52:33 1996353328 [Note] /usr/sbin/mysqld: ready for connections.
Jun 06 17:52:33 domaine.fr mysqld[1505]: Version: '10.1.38-MariaDB-0+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Raspbian 9.0
Jun 06 17:52:34 domaine.fr systemd[1]: Started MariaDB 10.1.38 database server.

je retente une mise à jour oupas .?

#14

Yep :wink:

#15

bein nikel je suis à jour :

image

je comprend pas trop le pourquoi du comment

mais tout refonctionne