Erreur mysql - relocation error

Krakinou · December 2, 2017, 10:21am

Bonjour,
Depuis hier soir, j’ai un problème étrange avec mysql:
Quand je tente de démarrer le service j’ai ça:

Dec 02 10:35:03 YunoHost systemd[1]: Starting LSB: Start and stop the mysql database server daemon... Dec 02 10:35:03 YunoHost mysql[4748]: /usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:03 YunoHost mysql[4748]: Starting MariaDB database server: mysqld/usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time referen Dec 02 10:35:05 YunoHost mysql[4748]: /usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:06 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:07 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:08 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:09 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:10 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:11 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:12 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:13 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:14 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:15 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:16 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:17 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:18 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:19 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:20 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:21 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:22 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:23 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:24 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:25 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:26 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:27 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:29 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:30 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:31 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:32 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:33 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:34 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:35 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:35 YunoHost mysql[4748]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@-<E9> not defined in file with link time reference Dec 02 10:35:35 YunoHost /etc/init.d/mysql[5180]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Dec 02 10:35:35 YunoHost /etc/init.d/mysql[5180]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Dec 02 10:35:35 YunoHost /etc/init.d/mysql[5180]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")' Dec 02 10:35:35 YunoHost /etc/init.d/mysql[5180]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Dec 02 10:35:35 YunoHost /etc/init.d/mysql[5180]: Dec 02 10:35:35 YunoHost mysql[4748]: failed! Dec 02 10:35:35 YunoHost systemd[1]: mysql.service: control process exited, code=exited status=1 Dec 02 10:35:35 YunoHost systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. Dec 02 10:35:35 YunoHost systemd[1]: Unit mysql.service entered failed state.

Une tentative de réinstallation me donne ça:

[code]root@YunoHost:/var/log # apt-get install --reinstall mysql-server mysql-server-5.5 mariadb-client-10.0 mariadb-client-core-10.0 mariadb-server mariadb-server-10.0 mariadb-server-core-10.0
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mariadb-server-10.0 : Breaks: mysql-server but 5.5.57-0+deb8u1 is to be installed
Breaks: mysql-server-5.5 but 5.5.57-0+deb8u1 is to be installed
Breaks: virtual-mysql-server
mariadb-server-core-10.0 : Conflicts: mysql-server-5.5 but 5.5.57-0+deb8u1 is to be installed
mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.57-0+deb8u1) but it is not going to be installed
Depends: mysql-server-core-5.5 (>= 5.5.57-0+deb8u1) but it is not going to be installed
Breaks: virtual-mysql-server
E: Unable to correct problems, you have held broken packages.[/code]

Bref, je ne sais pas trop quoi faire. Je ne vois pas bien quelle action j’aurai pu faire qui aurait amené à cette situtation…
Je suis sur un raspberry Pi3 avec yunohost 2.7.2.
Merci de votre aide!
Krakinou

ppr · December 2, 2017, 11:23am

Bonjour @Krakinou ,

Il me semble que YunoHost n’utilise plus MySQL mais MariaDB.
La commande aptitude plutôt que apt-get te donnera a priori plus de détails et d’options quant au résultat de la commande.

ppr

Krakinou · December 2, 2017, 11:54am

Hello et merci
Effectivement:

[code]root@YunoHost:/var/log # aptitude reinstall mysql-common
The following packages will be REINSTALLED:
mysql-common
0 packages upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 1 not upgraded.
Need to get 0 B/84.2 kB of archives. After unpacking 0 B will be used.
[master c10da5c] saving uncommitted changes in /etc prior to apt run
Author: root root@localhost
1 file changed, 1 insertion(+), 1 deletion(-)
(Reading database … 44459 files and directories currently installed.)
Preparing to unpack …/mysql-common_5.5.57-0+deb8u1_all.deb …
Unpacking mysql-common (5.5.57-0+deb8u1) over (5.5.57-0+deb8u1) …
Setting up mysql-common (5.5.57-0+deb8u1) …

root@YunoHost:/var/log # systemctl start mysql
Job for mysql.service failed. See ‘systemctl status mysql.service’ and ‘journalctl -xn’ for details.
root@YunoHost:/var/log # journalctl -xn -a
– Logs begin at Sat 2017-12-02 10:14:34 CET, end at Sat 2017-12-02 12:52:08 CET. –
Dec 02 12:52:08 YunoHost mysql[6500]: ./usr/sbin/mysqld: relocation error: /usr/sbin/mysqld: symbol feof, version 8@- not defined in file with link time reference
Dec 02 12:52:08 YunoHost /etc/init.d/mysql[6947]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Dec 02 12:52:08 YunoHost /etc/init.d/mysql[6947]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Dec 02 12:52:08 YunoHost /etc/init.d/mysql[6947]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)'
Dec 02 12:52:08 YunoHost /etc/init.d/mysql[6947]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Dec 02 12:52:08 YunoHost /etc/init.d/mysql[6947]:
Dec 02 12:52:08 YunoHost mysql[6500]: failed!
Dec 02 12:52:08 YunoHost systemd[1]: mysql.service: control process exited, code=exited status=1
Dec 02 12:52:08 YunoHost systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
– Subject: Unit mysql.service has failed
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit mysql.service has failed.

– The result is failed.
Dec 02 12:52:08 YunoHost systemd[1]: Unit mysql.service entered failed state.[/code]

mais ça ne fonctionne toujours pas :’(

ppr · December 2, 2017, 1:49pm

@Krakinou ,

Alors je dirais foutu pour foutu, faire une sauvegarde de tout ce que tu pourras et récupère la en suivant la documentation ici :
https://yunohost.org/#/backup_fr

Ensuite, il faudrait plutôt essayer d’installer MariaDB, fork de MySQL, plutôt que MySQL :

sudo aptitude install mariadb-server

Source : Installer MariaDB sur Raspbian

Pour finir, un peu de nettoyage dans les paquets qui ne sont plus utiles, une mise à jour de la liste des paquets, une mise à niveau des paquets et un nettoyage de la liste des paquets :

sudo aptitude autoremove && sudo aptitude update && sudo aptitude upgrade && sudo aptitude autoclean

ppr

Krakinou · December 2, 2017, 3:32pm

@ppr
Merci pour tes conseils
De ce que j’ai compris, c’est bien mariadb qui est installer sur yunohost, même si on utilise le service mysql…

J’ai tenté de faire ce que tu proposais mais ça n’a rien donné. Je vais réinstaller une sauvegarde…
Mais j’aime pas ça, les choses qui arrêtent de fonctionner d’un coup d’un seul sans qu’on sache pourquoi…

ppr · December 2, 2017, 6:17pm

Bon courage pour la réinstallation de ta sauvegarde @Krakinou .
Peut-être 2 pistes à tout hasard :

ta carte micro-SD qui commencerait-elle à être défectueuse ?
une coupure de courant soudaine ?
En ce qui concerne la seconde piste, c’est ce qui m’était arrivé et avait corrompu des tables que je n’avais pu récupérer. Du coup réinstallation complète. C’est pour ça que j’essaie de maintenir ce tuto https://avignu.wiki.tuxfamily.org/doku.php?id=documentation:yunohost-jessie-v2.7.x-rpi3b

ppr