Soucis avec MariaDB sur Debian 9
Bonsoir,
Hier soir, suite à un "apt update" mariadb-server-10.1.44 est devenue mariadb-server-10.1.45 et depuis le serveur MySQL ne fonctionne plus!!
Et donc, mon serveur Owncloud!!
La mise à jour n'a pas mis à jours les tables innoDB, bilan mariadb-server refusait de démarrer
apres, de nombreuses tentatives:
**apt remove --purge mariadb mysql** **apt autoremove** **apt autoclean**
nettoyage des dossier MySQL:
<<code>>
/etc/mysql/
/var/lib/mysql/
/usr/share/mysql/
/var/log/mysql/
/var/run/mysql/
apt update && apt upgrade <</code>>
Puis réinstallation :
**apt install mariadb-server**
j'obtiens inlassablement la même réponse: ---------------------------------------
# sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: default-mysql-server libdbd-mysql-perl libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common Suggested packages: mailx mariadb-test netcat-openbsd tinyca The following NEW packages will be installed: default-mysql-server libdbd-mysql-perl libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common mysql-server 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. Need to get 21.7 MB/22.6 MB of archives. After this operation, 182 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://deb.debian.org/debian stretch/main amd64 mariadb-common all 10.1.45-0+deb9u1 [28.6 kB] Get:2 http://deb.debian.org/debian stretch/main amd64 mariadb-client-core-10.1 amd64 10.1.45-0+d eb9u1 [5127 kB] Get:3 http://deb.debian.org/debian stretch/main amd64 mariadb-client-10.1 amd64 10.1.45-0+deb9u1 [5923 kB] Get:4 http://deb.debian.org/debian stretch/main amd64 mariadb-server-core-10.1 amd64 10.1.45-0+d eb9u1 [5239 kB] Get:5 http://deb.debian.org/debian stretch/main amd64 mariadb-server-10.1 amd64 10.1.45-0+deb9u1 [5343 kB] Fetched 21.7 MB in 0s (56.6 MB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. (Reading database ... 138716 files and directories currently installed.) Preparing to unpack .../mysql-common_5.8+1.0.2_all.deb ... Unpacking mysql-common (5.8+1.0.2) ... Selecting previously unselected package mariadb-common. Preparing to unpack .../mariadb-common_10.1.45-0+deb9u1_all.deb ... Unpacking mariadb-common (10.1.45-0+deb9u1) ... Selecting previously unselected package mariadb-client-core-10.1. Preparing to unpack .../mariadb-client-core-10.1_10.1.45-0+deb9u1_amd64.deb ... Unpacking mariadb-client-core-10.1 (10.1.45-0+deb9u1) ... Selecting previously unselected package mariadb-client-10.1. Preparing to unpack .../mariadb-client-10.1_10.1.45-0+deb9u1_amd64.deb ... Unpacking mariadb-client-10.1 (10.1.45-0+deb9u1) ... Selecting previously unselected package mariadb-server-core-10.1. Preparing to unpack .../mariadb-server-core-10.1_10.1.45-0+deb9u1_amd64.deb ... Unpacking mariadb-server-core-10.1 (10.1.45-0+deb9u1) ... Setting up mysql-common (5.8+1.0.2) ... update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in a uto mode Setting up mariadb-common (10.1.45-0+deb9u1) ... update-alternatives: using /etc/mysql/mariadb.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode Selecting previously unselected package mariadb-server-10.1. (Reading database ... 138872 files and directories currently installed.) Preparing to unpack .../mariadb-server-10.1_10.1.45-0+deb9u1_amd64.deb ... /var/lib/mysql: found previous version 10.1 Unpacking mariadb-server-10.1 (10.1.45-0+deb9u1) ... Selecting previously unselected package default-mysql-server. Preparing to unpack .../default-mysql-server_1.0.2_all.deb ... Unpacking default-mysql-server (1.0.2) ... Selecting previously unselected package libmariadbclient18:amd64. Preparing to unpack .../libmariadbclient18_10.1.45-0+deb9u1_amd64.deb ... Unpacking libmariadbclient18:amd64 (10.1.45-0+deb9u1) ... Selecting previously unselected package libdbd-mysql-perl. Preparing to unpack .../libdbd-mysql-perl_4.041-2_amd64.deb ... Unpacking libdbd-mysql-perl (4.041-2) ... Selecting previously unselected package mysql-server. Preparing to unpack .../mysql-server_5.5.9999+default_amd64.deb ... Unpacking mysql-server (5.5.9999+default) ... Setting up mariadb-server-core-10.1 (10.1.45-0+deb9u1) ... Setting up mariadb-client-core-10.1 (10.1.45-0+deb9u1) ... Setting up libmariadbclient18:amd64 (10.1.45-0+deb9u1) ... Processing triggers for libc-bin (2.24-11+deb9u4) ... Processing triggers for systemd (232-25+deb9u12) ... Processing triggers for man-db (2.7.6.1-2) ... Setting up libdbd-mysql-perl (4.041-2) ... Setting up mariadb-client-10.1 (10.1.45-0+deb9u1) ... Setting up mariadb-server-10.1 (10.1.45-0+deb9u1) ... /var/lib/dpkg/info/mariadb-server-10.1.postinst: line 18: 564 Done echo "$p assword_column_fix_query" 565 Aborted | $MYSQL_BOOTSTRAP 2>&1 566 | $ERR_LOGGER dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 134 dpkg: dependency problems prevent configuration of default-mysql-server: default-mysql-server depends on mariadb-server-10.1; however: Package mariadb-server-10.1 is not configured yet. dpkg: error processing package default-mysql-server (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on default-mysql-server; however: Package default-mysql-server is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Processing triggers for systemd (232-25+deb9u12) ... Errors were encountered while processing: mariadb-server-10.1 default-mysql-server mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) #
---------------------------------------
Ma dernière tentative en date :
apt-get remove --purge apache2 mysql php apt autoremove apt autoclean apt update && apt upgrade affichage de la page index.html du serveur OK apt install apache2 libapache2-mod-php affichage de la page info.php OK apt install mysql-server Message idem au précédent NOTOK
Log apt/history.log
Start-Date: 2020-07-23 20:02:47 Commandline: apt install mysql-server Install: mariadb-common:amd64 (10.1.45-0+deb9u1, automatic), mysql-server:amd64 (5.5.9999+default), mariadb-server-core-10.1:amd64 (10.1.45-0+deb9u1, automatic), mariadb-server-10.1:amd64 (10.1.45-0+deb9u1, automatic), default-mysql-server:amd64 (1.0.2, automatic), mysql-common:amd64 (5.8+1.0.2, automatic), mariadb-client-10.1:amd64 (10.1.45-0+deb9u1, automatic), mariadb-client-core-10.1:amd64 (10.1.45-0+deb9u1, automatic), libdbd-mysql-perl:amd64 (4.041-2, automatic), libmariadbclient18:amd64 (10.1.45-0+deb9u1, automatic) Error: Sub-process /usr/bin/dpkg returned an error code (1) End-Date: 2020-07-23 20:03:01
Log : dpkg.log
2020-07-23 20:02:47 startup archives unpack 2020-07-23 20:02:48 install mysql-common:all <none> 5.8+1.0.2 2020-07-23 20:02:48 status half-installed mysql-common:all 5.8+1.0.2 2020-07-23 20:02:48 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:48 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:48 install mariadb-common:all <none> 10.1.45-0+deb9u1 2020-07-23 20:02:48 status half-installed mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:48 status unpacked mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:48 status unpacked mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:49 install mariadb-client-core-10.1:amd64 <none> 10.1.45-0+deb9u1 2020-07-23 20:02:49 status half-installed mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:49 status triggers-pending man-db:amd64 2.7.6.1-2 2020-07-23 20:02:49 status unpacked mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:49 status unpacked mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:50 install mariadb-client-10.1:amd64 <none> 10.1.45-0+deb9u1 2020-07-23 20:02:50 status half-installed mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:50 status unpacked mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:50 status unpacked mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:51 install mariadb-server-core-10.1:amd64 <none> 10.1.45-0+deb9u1 2020-07-23 20:02:51 status half-installed mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:51 status unpacked mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:51 status unpacked mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:52 startup packages configure 2020-07-23 20:02:52 configure mysql-common:all 5.8+1.0.2 <none> 2020-07-23 20:02:52 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 status unpacked mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 status half-configured mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 status installed mysql-common:all 5.8+1.0.2 2020-07-23 20:02:52 configure mariadb-common:all 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:52 status unpacked mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:52 status unpacked mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:52 status half-configured mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:52 status installed mariadb-common:all 10.1.45-0+deb9u1 2020-07-23 20:02:53 startup archives unpack 2020-07-23 20:02:53 install mariadb-server-10.1:amd64 <none> 10.1.45-0+deb9u1 2020-07-23 20:02:53 status half-installed mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:53 status triggers-pending systemd:amd64 232-25+deb9u12 2020-07-23 20:02:54 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:54 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:54 install default-mysql-server:all <none> 1.0.2 2020-07-23 20:02:54 status half-installed default-mysql-server:all 1.0.2 2020-07-23 20:02:55 status unpacked default-mysql-server:all 1.0.2 2020-07-23 20:02:55 status unpacked default-mysql-server:all 1.0.2 2020-07-23 20:02:55 install libmariadbclient18:amd64 <none> 10.1.45-0+deb9u1 2020-07-23 20:02:55 status triggers-pending libc-bin:amd64 2.24-11+deb9u4 2020-07-23 20:02:55 status half-installed libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:55 status unpacked libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:55 status unpacked libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:55 install libdbd-mysql-perl:amd64 <none> 4.041-2 2020-07-23 20:02:55 status half-installed libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:55 status unpacked libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:56 status unpacked libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:56 install mysql-server:amd64 <none> 5.5.9999+default 2020-07-23 20:02:56 status half-installed mysql-server:amd64 5.5.9999+default 2020-07-23 20:02:56 status unpacked mysql-server:amd64 5.5.9999+default 2020-07-23 20:02:56 status unpacked mysql-server:amd64 5.5.9999+default 2020-07-23 20:02:56 startup packages configure 2020-07-23 20:02:56 configure mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:56 status unpacked mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:56 status half-configured mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:56 status installed mariadb-server-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:56 configure mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:56 status unpacked mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 status half-configured mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 status installed mariadb-client-core-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 configure libmariadbclient18:amd64 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:57 status unpacked libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 status half-configured libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 status installed libmariadbclient18:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:57 trigproc libc-bin:amd64 2.24-11+deb9u4 <none> 2020-07-23 20:02:57 status half-configured libc-bin:amd64 2.24-11+deb9u4 2020-07-23 20:02:57 status installed libc-bin:amd64 2.24-11+deb9u4 2020-07-23 20:02:57 trigproc systemd:amd64 232-25+deb9u12 <none> 2020-07-23 20:02:57 status half-configured systemd:amd64 232-25+deb9u12 2020-07-23 20:02:57 status installed systemd:amd64 232-25+deb9u12 2020-07-23 20:02:57 trigproc man-db:amd64 2.7.6.1-2 <none> 2020-07-23 20:02:57 status half-configured man-db:amd64 2.7.6.1-2 2020-07-23 20:02:58 status installed man-db:amd64 2.7.6.1-2 2020-07-23 20:02:58 configure libdbd-mysql-perl:amd64 4.041-2 <none> 2020-07-23 20:02:58 status unpacked libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:58 status half-configured libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:58 status installed libdbd-mysql-perl:amd64 4.041-2 2020-07-23 20:02:58 configure mariadb-client-10.1:amd64 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:58 status unpacked mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status half-configured mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status installed mariadb-client-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 configure mariadb-server-10.1:amd64 10.1.45-0+deb9u1 <none> 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status triggers-pending systemd:amd64 232-25+deb9u12 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:58 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:59 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:59 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:59 status unpacked mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:02:59 status half-configured mariadb-server-10.1:amd64 10.1.45-0+deb9u1 2020-07-23 20:03:00 trigproc systemd:amd64 232-25+deb9u12 <none> 2020-07-23 20:03:00 status half-configured systemd:amd64 232-25+deb9u12 2020-07-23 20:03:00 status installed systemd:amd64 232-25+deb9u12
Si quelqu'un a une idée je suis preneur! là je seche...
Merci pour votre aide, Cordialement, Laurent
Answer Answered by Laurent LAFORGE in this comment.
bonjour,
J'ai depuis réglé mon souci ;)
il y avait un souci sur les droit du dossier /tmp
Je l'ai modifié dans my.cnf:
tmpdir = /var/lib/mysql/tmpdir avec les droits mysql:mysql
Puis, j'ai supprimé les deux fichiers de log innodb et hop