[Debian] - Soucis avec MariaDB sur Debian 9

Répondre
Avatar du membre
LM2I_Laurent
Administrateur - Site Admin
Messages : 279
Enregistré le : jeu. 27 août 2009 17:00

[Debian] - Soucis avec MariaDB sur Debian 9

Message par LM2I_Laurent »

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:

Code : Tout sélectionner

apt remove --purge mariadb mysql

apt autoremove

apt autoclean
nettoyage des dossier MySQL:

Code : Tout sélectionner

/etc/mysql/ 
/var/lib/mysql/ 
/usr/share/mysql/ 
/var/log/mysql/ 
/var/run/mysql/

apt update && apt upgrade 
Puis réinstallation :

Code : Tout sélectionner

apt install mariadb-server
j'obtiens inlassablement la même réponse:

Code : Tout sélectionner

# 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 :

Code : Tout sélectionner

apt-get remove --purge apache2 mysql* php*
apt autoremove
apt autoclean
apt update && apt upgrade
affichage de la page index.html du serveur OK

Code : Tout sélectionner

apt install apache2 libapache2-mod-php
affichage de la page info.php OK

Code : Tout sélectionner

apt install mysql-server
Message idem au précédent NOTOK
Log apt/history.log

Code : Tout sélectionner

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

Code : Tout sélectionner

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 d'avance....


@+
Laurent
Image
Webmaster
http://www.lm2i.fr
http://www.lm2i.eu

Image Image Image Image
.
Avatar du membre
LM2I_Laurent
Administrateur - Site Admin
Messages : 279
Enregistré le : jeu. 27 août 2009 17:00

Re: [Debian] - Soucis avec MariaDB sur Debian 9

Message par LM2I_Laurent »

Tentative commande: apt-get dist-upgrade:

Code : Tout sélectionner

# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
4 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up mariadb-server-10.1 (10.1.45-0+deb9u1) ...
/var/lib/dpkg/info/mariadb-server-10.1.postinst: line 18:  5183 Done                                                                                           echo "$password_column_fix_query"
      5184 Aborted                 | $MYSQL_BOOTSTRAP 2>&1
      5185                       | $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
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (>= 10.1.45-0+deb9u1); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 default-mysql-server
 mysql-server
 mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
#
Meme résultat !!


Je continue à chercher...
@+
Laurent
Image
Webmaster
http://www.lm2i.fr
http://www.lm2i.eu

Image Image Image Image
.
Avatar du membre
LM2I_Laurent
Administrateur - Site Admin
Messages : 279
Enregistré le : jeu. 27 août 2009 17:00

Re: [Debian] - Soucis avec MariaDB sur Debian 9

Message par LM2I_Laurent »

Tentative commande: apt -f install:
Même résultat !!

Code : Tout sélectionner

# apt -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
4 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mariadb-server-10.1 (10.1.45-0+deb9u1) ...
/var/lib/dpkg/info/mariadb-server-10.1.postinst: line 18: 14051 Done                    echo "$password_column_fix_query"
     14052 Aborted                 | $MYSQL_BOOTSTRAP 2>&1
     14053                       | $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
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (>= 10.1.45-0+deb9u1); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 default-mysql-server
 mysql-server
 mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
#
Je continue à chercher...
@+
Laurent
Image
Webmaster
http://www.lm2i.fr
http://www.lm2i.eu

Image Image Image Image
.
Répondre