Impossible de lancer MySQL

**jaykay123** · 31/01/2020, 21h12

Hello !

Je suis nouveau sur le forum et d'habitude, je n'ai pas besoin de devoir m'inscrire sur un forum pour trouver une solution, je trouve d'habitude mes réponses sur la toile !

Alors voilà, j'ai un de mes sites qui a crashé du jour au lendemain, sans aucune raison ou action...

Après investigation, je comprend que c'est la BDD qui à un soucis.
1
Le constat final est que j'ai complétement réinstaller mon serveur en sauvegardant les fichiers FRM et ibdata1 mais, j'ai éxactement le même soucis qu'avant. Impossible de lancer MySQL...

Voici les différents logs...

200131 20:38:24 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
200131 20:38:24 [Note] Plugin 'FEDERATED' is disabled.
200131 20:38:24 InnoDB: The InnoDB memory heap is disabled
200131 20:38:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200131 20:38:24 InnoDB: Compressed tables use zlib 1.2.8
200131 20:38:24 InnoDB: Using Linux native AIO
200131 20:38:24 InnoDB: Initializing buffer pool, size = 128.0M
200131 20:38:24 InnoDB: Completed initialization of buffer pool
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 5.
InnoDB: You may have to recover from a backup.
200131 20:38:24  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex

● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Fri 2020-01-31 20:46:11 CET; 3min 25s ago
  Process: 9524 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 11676 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jan 31 20:46:11 vps587352.ovh.net /etc/init.d/mysql[12407]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf...ted in
Jan 31 20:46:11 vps587352.ovh.net /etc/init.d/mysql[12407]: [61B blob data]
Jan 31 20:46:11 vps587352.ovh.net /etc/init.d/mysql[12407]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq...' (2)'
Jan 31 20:46:11 vps587352.ovh.net /etc/init.d/mysql[12407]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 31 20:46:11 vps587352.ovh.net /etc/init.d/mysql[12407]:
Jan 31 20:46:11 vps587352.ovh.net mysql[11676]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . .... failed!
Jan 31 20:46:11 vps587352.ovh.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jan 31 20:46:11 vps587352.ovh.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jan 31 20:46:11 vps587352.ovh.net systemd[1]: Unit mysql.service entered failed state.

A première vue, ce serait la BDD qui est corrompue... des idées ?

Merci !
Emilien

**chrtophe** · 01/02/2020, 09h14

Pour commencer, on ne copie pas une base de données en prenant les fichiers tels quels mais en faisant un dump (commande mysqldump).

D'après tes logs, mysql ne démarre pas, il faut commencer par effacer le fichier le fichier /var/run/mysqld/mysqld.sock si il y en a un.

Essayes un mysqlcheck nom _de_la_base

Ensuite essayes d'ajouter :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

innodb_force_recovery=4

dans ton fichier my.cnf, puis de démarrer/redémarrer mysql.

**jaykay123** · 01/02/2020, 19h29

Je n'ai pas de fichier mysqld.sock justement...

en faisant le check :

mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect

J'ai rajouter la ligne que tu m'as préconisé et toujours pareil :

Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

root@vps587352:~# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Sat 2020-02-01 19:28:29 CET; 28s ago
  Process: 4909 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Feb 01 19:28:29 vps587352.ovh.net /etc/init.d/mysql[5638]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ...ted in
Feb 01 19:28:29 vps587352.ovh.net /etc/init.d/mysql[5638]: [61B blob data]
Feb 01 19:28:29 vps587352.ovh.net /etc/init.d/mysql[5638]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysql...' (2)'
Feb 01 19:28:29 vps587352.ovh.net /etc/init.d/mysql[5638]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Feb 01 19:28:29 vps587352.ovh.net /etc/init.d/mysql[5638]:
Feb 01 19:28:29 vps587352.ovh.net mysql[4909]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . ... failed!
Feb 01 19:28:29 vps587352.ovh.net systemd[1]: mysql.service: control process exited, code=exited status=1
Feb 01 19:28:29 vps587352.ovh.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Feb 01 19:28:29 vps587352.ovh.net systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.

root@vps587352:~# journalctl -xn
-- Logs begin at Sat 2020-02-01 06:32:38 CET, end at Sat 2020-02-01 19:29:25 CET. --
Feb 01 19:29:12 vps587352.ovh.net sshd[5649]: pam_unix(sshd:auth): check pass; user unknown
Feb 01 19:29:12 vps587352.ovh.net sshd[5649]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=vps06.bubbleswa
Feb 01 19:29:14 vps587352.ovh.net sshd[5649]: Failed password for invalid user admin from 176.31.128.45 port 59620 ssh2
Feb 01 19:29:14 vps587352.ovh.net sshd[5649]: Received disconnect from 176.31.128.45: 11: Bye Bye [preauth]
Feb 01 19:29:23 vps587352.ovh.net sshd[5651]: Invalid user mc from 128.199.199.217
Feb 01 19:29:23 vps587352.ovh.net sshd[5651]: input_userauth_request: invalid user mc [preauth]
Feb 01 19:29:23 vps587352.ovh.net sshd[5651]: pam_unix(sshd:auth): check pass; user unknown
Feb 01 19:29:23 vps587352.ovh.net sshd[5651]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=128.199.199.217
Feb 01 19:29:24 vps587352.ovh.net sshd[5651]: Failed password for invalid user mc from 128.199.199.217 port 45584 ssh2
Feb 01 19:29:25 vps587352.ovh.net sshd[5651]: Received disconnect from 128.199.199.217: 11: Bye Bye [preauth]

Merci à tous !