Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15859

MariaDB 10.2.13~14 Impossible to make SST with libmariadbclient18 (from MariaDB)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2.13, 10.2.14
    • Fix Version/s: 10.2
    • Component/s: Galera SST
    • Labels:
      None
    • Environment:
      Debian 9.4 install from MariaDB repository

      Description

      FOUND : the problem come from --defaults-file with : (look it's not loaded in particular order or combined with an other option).

      First I tried to upgrade my galera cluster from 10.2.12 to 10.2.13, i stopped one node to upgrade and put back, but the node fail to IST and then fail to SST. (I pushed a bug about this : https://jira.mariadb.org/browse/MDEV-15453?filter=-2)

      Then when we tried to deploy a new cluster :
      At begining we asked ourself why the upgrade of password failed with SALT (https://docs.saltstack.com/en/latest/ref/states/all/salt.states.mysql_user.html). in fact I think this trouble and the sst is exactly the same the cannot connect to mysql (particular sign, you can see : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      (or whatever you put in /root/.my.cnf)
      It's mean that all stuff witch use salt are falling also. I don't know where it is in the code but i know it's linked with : "libmariadbclient18" and special options of client to connect to MySQL/MariaDB

      Work :

      ii  libmariadbclient18:amd64          10.1.26-0+deb9u1               amd64        MariaDB database client library
      

      (i don't know why Debian installed this version for mariadb 10.2.13)

      Not Work :
      (with apt-get upgrade)

      ii  libmariadbclient18                10.2.13+maria~stretch          amd64        Virtual package to satisfy external depends
      

      Full listing :
      Work :

       dpkg -l | grep -E "mysql|maria" 
      ii  libdbd-mysql-perl                 4.041-2                        amd64        Perl5 database interface to the MariaDB/MySQL database
      ii  libmariadbclient18:amd64          10.1.26-0+deb9u1               amd64        MariaDB database client library
      ii  mariadb-backup-10.2               10.2.13+maria~stretch          amd64        Backup tool for MariaDB server
      ii  mariadb-client-10.2               10.2.13+maria~stretch          amd64        MariaDB database client binaries
      ii  mariadb-client-core-10.2          10.2.13+maria~stretch          amd64        MariaDB database core client binaries
      ii  mariadb-common                    10.2.13+maria~stretch          all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
      ii  mariadb-server-10.2               10.2.13+maria~stretch          amd64        MariaDB database server binaries
      ii  mariadb-server-core-10.2          10.2.13+maria~stretch          amd64        MariaDB database core server files
      ii  mysql-common                      10.2.13+maria~stretch          all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
      ii  python-mysqldb                    1.3.7-1.1                      amd64        Python interface to MySQL
      

      not work :

      ii  libdbd-mysql-perl                 4.041-2                        amd64        Perl5 database interface to the MariaDB/MySQL database
      ii  libmariadb3                       10.2.13+maria~stretch          amd64        MariaDB database client library
      ii  libmariadbclient18                10.2.13+maria~stretch          amd64        Virtual package to satisfy external depends
      ii  mariadb-backup-10.2               10.2.13+maria~stretch          amd64        Backup tool for MariaDB server
      ii  mariadb-client-10.2               10.2.13+maria~stretch          amd64        MariaDB database client binaries
      ii  mariadb-client-core-10.2          10.2.13+maria~stretch          amd64        MariaDB database core client binaries
      ii  mariadb-common                    10.2.13+maria~stretch          all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
      ii  mariadb-server-10.2               10.2.13+maria~stretch          amd64        MariaDB database server binaries
      ii  mariadb-server-core-10.2          10.2.13+maria~stretch          amd64        MariaDB database core server files
      ii  mysql-common                      10.2.13+maria~stretch          all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
      ii  python-mysqldb                    1.3.7-1.1                      amd64        Python interface to MySQL
      

        Attachments

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              Aurelien_LEQUOY Aurélien LEQUOY
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: