MariaDB: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Le
Hugues MORIN
--001a11477cb61b4f200555242c81
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Bonjour a tous


J'ai un probleme qu'il faut que je resolve tres vite car c'est
professionnel.

J'ai un serveur dedie chez OVH que j'ai recemment reinstaller en Stretch.
Le serveur fontionne jusqu'a maintenant avec le noyau fourni par OVH
(4.9.33 ou un truc comme ca)

J'ai installele noyau officiel de debian
4.9.0-3-amd64 #1 SMP Debian 4.9.30-2+deb9u2 (2017-06-26) x86_64 GNU/Linux

J'ai modifie le grub pour qu'il soit pris en compte et j'ai reboote

Le serveur demarre mais pas MariaDB
J'obtiens l'erreur:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Je ne comprends ce qui a pu se passer, comme l'indique le message d'erreur,
mysqld.sock n'est plus present dans '/var/run/mysqld/ O_O !!!

Si je tente:
root@XXXXXXXX:/# systemctl start mariadb.service
Job for mariadb.service failed because a fatal signal was delivered to the
control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

root@XXXXXXXX:/home# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor
preset: enabled)
Active: activating (auto-restart) (Result: signal) since Tue 2017-07-25
13:11:56 UTC; 2s ago
Process: 2402 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUST=
ER
$_WSREP_START_POSITION (code=killed, signal=ABRT)
Process: 2304 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ]
&& VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemct=
l
set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited,
status=0/SUCCESS)
Process: 2301 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2298 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d
/var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2402 (code=killed, signal=ABRT)
Status: "InnoDB: Error: space header page consists of zero bytes in
tablespace ./rcpresta16114/ps_jm_pagecache_mods.ibd (table
rcpresta16114/ps_jm_pagecache_mods)"
Tasks: 0 (limit: 4915)
CGroup: /system.slice/mariadb.service

juil. 25 13:11:56 XXXXXXXX.123-456-789.zz systemd[1]: Failed to start
MariaDB database server.
juil. 25 13:11:56 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Unit
entered failed state.
juil. 25 13:11:56 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service:
Failed with result 'signal'.


root@XXXXXXXX:/home# journalctl -xe
juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Main
process exited, code=killed, status=6/ABRT
juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: Failed to start
MariaDB database server.
-- Subject: L'unité (unit) mariadb.service a échoué
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- L'unité (unit) mariadb.service a échoué, avec le rés=
ultat failed.
juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Unit
entered failed state.
juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service:
Failed with result 'signal'.
juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service:
Service hold-off time over, scheduling restart.
juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]: Stopped MariaDB
database server.
-- Subject: L'unité (unit) mariadb.service a terminé son arr=
t
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- L'unité (unit) mariadb.service a terminé son arrêt.
juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]: Starting MariaDB
database server
-- Subject: L'unité (unit) mariadb.service a commencé à d=
marrer
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- L'unité (unit) mariadb.service a commencé à démarrer=
.
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz mysqld[3173]: 2017-07-25 13:12:34
139646942978624 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1)
starting as process 3173
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Main
process exited, code=killed, status=6/ABRT
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: Failed to start
MariaDB database server.
-- Subject: L'unité (unit) mariadb.service a échoué
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- L'unité (unit) mariadb.service a échoué, avec le rés=
ultat failed.
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Unit
entered failed state.
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service:
Failed with result 'signal'.


Voila pour l'instant ce que j'ai pu trouver.


Cordialement
Hugues

--001a11477cb61b4f200555242c81
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir="ltr"><div><div><div><div><div>Bonjour a tous<br><br><br></div>J=
&#39;ai un probleme qu&#39;il faut que je resolve tres vite car c&#39;est p=
rofessionnel.<br><br></div>J&#39;ai un serveur dedie chez OVH que j&#39;ai =
recemment reinstaller en Stretch.<br></div>Le serveur fontionne jusqu&#39;a=
maintenant avec le noyau fourni par OVH (4.9.33 ou un truc comme ca)<br><b=
r></div>J&#39;ai installele noyau officiel de debian <br>4.9.0-3-amd64 #1 S=
MP Debian 4.9.30-2+deb9u2 (2017-06-26) x86_64 GNU/Linux<br><br></div><div>J=
&#39;ai modifie le grub pour qu&#39;il soit pris en compte et j&#39;ai rebo=
ote<br><br></div><div>Le serveur demarre mais pas MariaDB<br></div><div>J&#=
39;obtiens l&#39;erreur:<br>ERROR 2002 (HY000): Can&#39;t connect to local =
MySQL server through socket &#39;/var/run/mysqld/mysqld.sock&#39; (2 &quot;=
No such file or directory&quot;)<br><br></div><div>Je ne comprends ce qui a=
pu se passer, comme l&#39;indique le message d&#39;erreur, mysqld.sock n&#=
39;est plus present dans &#39;/var/run/mysqld/     O_O =
!!!<br><br></div><div>Si je tente:<br>root@XXXXXXXX:/# systemctl start mari=
adb.service<br>Job for mariadb.service failed because a fatal signal was de=
livered to the control process.<br>See &quot;systemctl status mariadb.servi=
ce&quot; and &quot;journalctl -xe&quot; for details.<br><br>root@XXXXXXXX:/=
home# systemctl status mariadb.service<br>● mariadb.service - Maria=
DB database server<br>   Loaded: loaded (/lib/systemd/system/mari=
adb.service; enabled; vendor preset: enabled)<br>   Active: activ=
ating (auto-restart) (Result: signal) since Tue 2017-07-25 13:11:56 UTC; 2s=
ago<br>  Process: 2402 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WS=
REP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)<br>=
  Process: 2304 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recov=
ery ] &amp;&amp; VAR= ||   VAR=`/usr/bin/galera_recovery`; [ =
$? -eq 0 ]   &amp;&amp; systemctl set-environment _WSREP_START_PO=
SITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)<br>  Proce=
ss: 2301 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START=
_POSITION (code=exited, status=0/SUCCESS)<br>  Process: 2298 ExecS=
tartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=
=exited, status=0/SUCCESS)<br> Main PID: 2402 (code=killed, sign=
al=ABRT)<br>   Status: &quot;InnoDB: Error: space header page c=
onsists of zero bytes in tablespace ./rcpresta16114/ps_jm_pagecache_mods.ib=
d (table rcpresta16114/ps_jm_pagecache_mods)&quot;<br>    Ta=
sks: 0 (limit: 4915)<br>   CGroup: /system.slice/mariadb.service<=
br><br>juil. 25 13:11:56 XXXXXXXX.123-456-789.zz systemd[1]: Failed to star=
t MariaDB database server.<br>juil. 25 13:11:56 XXXXXXXX.123-456-789.zz sys=
temd[1]: mariadb.service: Unit entered failed state.<br>juil. 25 13:11:56 X=
XXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Failed with result &#39=
;signal&#39;.<br><br><br>root@XXXXXXXX:/home# journalctl -xe<br>juil. 25 13=
:12:28 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Main process ex=
ited, code=killed, status=6/ABRT<br>juil. 25 13:12:28 XXXXXXXX.123-456-=
789.zz systemd[1]: Failed to start MariaDB database server.<br>-- Subject: =
L&#39;unité (unit) mariadb.service a échoué<br>-- Defined-By=
: systemd<br>-- Support: <a href="https://www.debian.org/support">https:/=
/www.debian.org/support</a><br>-- <br>-- L&#39;unité (unit) mariadb.se=
rvice a échoué, avec le résultat failed.<br>juil. 25 13:12:2=
8 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Unit entered failed =
state.<br>juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.ser=
vice: Failed with result &#39;signal&#39;.<br>juil. 25 13:12:33 XXXXXXXX.12=
3-456-789.zz systemd[1]: mariadb.service: Service hold-off time over, sched=
uling restart.<br>juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]: Sto=
pped MariaDB database server.<br>-- Subject: L&#39;unité (unit) mariad=
b.service a terminé son arrêt<br>-- Defined-By: systemd<br>-- Sup=
port: <a href="https://www.debian.org/support">https://www.debian.org/sup=
port</a><br>-- <br>-- L&#39;unité (unit) mariadb.service a termin=
son arrêt.<br>juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]=
: Starting MariaDB database server<br>-- Subject: L&#39;unité (unit=
) mariadb.service a commencé à démarrer<br>-- Defined-By: sy=
stemd<br>-- Support: <a href="https://www.debian.org/support">https://www=
.debian.org/support</a><br>-- <br>-- L&#39;unité (unit) mariadb.servic=
e a commencé à démarrer.<br>juil. 25 13:12:34 XXXXXXXX.123-4=
56-789.zz mysqld[3173]: 2017-07-25 13:12:34 139646942978624 [Note] /usr/sbi=
n/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as process 3173 <br>=
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Main=
process exited, code=killed, status=6/ABRT<br>juil. 25 13:12:34 XXXXXX=
XX.123-456-789.zz systemd[1]: Failed to start MariaDB database server.<br>-=
- Subject: L&#39;unité (unit) mariadb.service a échoué<br>--=
Defined-By: systemd<br>-- Support: <a href="https://www.debian.org/suppo=
rt">https://www.debian.org/support</a><br>-- <br>-- L&#39;unité (unit)=
mariadb.service a échoué, avec le résultat failed.<br>juil.=
25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: mariadb.service: Unit ente=
red failed state.<br>juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: =
mariadb.service: Failed with result &#39;signal&#39;.<br><br><br></div><div=
>Voila pour l&#39;instant ce que j&#39;ai pu trouver.<br></div><div><br><br=
></div><div>Cordialement<br></div><div>Hugues<br></div><div><br><br><br></d=
iv></div>

--001a11477cb61b4f200555242c81--
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Publicité
Poster une réponse
Anonyme