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_CLUSTER $_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 ] && systemctl 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ésultat 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ésultat 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.