The Ultimate Guide to High Availability with MariaDB

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

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.