Génération NTEntraideLinuxAutres OSLinux DebianMariaDB: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
MariaDB: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
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 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
=E2=97=8F 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=3D/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUST=
ER
$_WSREP_START_POSITION (code=3Dkilled, signal=3DABRT)
Process: 2304 ExecStartPre=3D/bin/sh -c [ ! -e /usr/bin/galera_recovery ]
&& VAR=3D || VAR=3D`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemct=
l
set-environment _WSREP_START_POSITION=3D$VAR || exit 1 (code=3Dexited,
status=3D0/SUCCESS)
Process: 2301 ExecStartPre=3D/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=3Dexited, status=3D0/SUCCESS)
Process: 2298 ExecStartPre=3D/usr/bin/install -m 755 -o mysql -g root -d
/var/run/mysqld (code=3Dexited, status=3D0/SUCCESS)
Main PID: 2402 (code=3Dkilled, signal=3DABRT)
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=3Dkilled, status=3D6/ABRT
juil. 25 13:12:28 XXXXXXXX.123-456-789.zz systemd[1]: Failed to start
MariaDB database server.
-- Subject: L'unit=C3=A9 (unit) mariadb.service a =C3=A9chou=C3=A9
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--=20
-- L'unit=C3=A9 (unit) mariadb.service a =C3=A9chou=C3=A9, avec le r=C3=A9s=
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=C3=A9 (unit) mariadb.service a termin=C3=A9 son arr=C3=
=AAt
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--=20
-- L'unit=C3=A9 (unit) mariadb.service a termin=C3=A9 son arr=C3=AAt.
juil. 25 13:12:33 XXXXXXXX.123-456-789.zz systemd[1]: Starting MariaDB
database server...
-- Subject: L'unit=C3=A9 (unit) mariadb.service a commenc=C3=A9 =C3=A0 d=C3=
=A9marrer
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--=20
-- L'unit=C3=A9 (unit) mariadb.service a commenc=C3=A9 =C3=A0 d=C3=A9marrer=
.
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=3Dkilled, status=3D6/ABRT
juil. 25 13:12:34 XXXXXXXX.123-456-789.zz systemd[1]: Failed to start
MariaDB database server.
-- Subject: L'unit=C3=A9 (unit) mariadb.service a =C3=A9chou=C3=A9
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--=20
-- L'unit=C3=A9 (unit) mariadb.service a =C3=A9chou=C3=A9, avec le r=C3=A9s=
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'.