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

Upgrade from Ubuntu's MariaDB 5.5.37 to MariaDB's 5.5.38 does not work

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5.38
    • Fix Version/s: 5.5
    • Component/s: None
    • Labels:
    • Environment:
      Ubuntu 14.04 Trusty

      Description

      Packages after installing Ubuntu's MariaDB 5.5.37:

      $ dpkg -l | grep -iP '(maria|mysql)'
      ii  libdbd-mysql-perl                                     4.025-1                                             amd64        Perl5 database interface to the MySQL database
      ii  libmariadbclient18:amd64                              5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database client library
      ii  libmysqlclient18:amd64                                5.5.37-0ubuntu0.14.04.1                             amd64        MySQL database client library
      ii  mariadb-client-5.5                                    5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database client binaries
      ii  mariadb-client-core-5.5                               5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database core client binaries
      ii  mariadb-common                                        5.5.37-0ubuntu0.14.04.1                             all          MariaDB common metapackage
      ii  mariadb-server                                        5.5.37-0ubuntu0.14.04.1                             all          MariaDB database server (metapackage depending on the latest version)
      ii  mariadb-server-5.5                                    5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database server binaries
      ii  mariadb-server-core-5.5                               5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database core server files
      ii  mysql-common                                          5.5.37-0ubuntu0.14.04.1                             all          MySQL database common files, e.g. /etc/mysql/my.cnf
      

      Add MariaDB repo, run apt-get install mariadb-server
      Full output:

      $ sudo apt-get install mariadb-server
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      The following package was automatically installed and is no longer required:
        libjemalloc1
      Use 'apt-get autoremove' to remove it.
      The following extra packages will be installed:
        libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-server-5.5
        mariadb-server-core-5.5
      Suggested packages:
        libterm-readkey-perl tinyca mailx mariadb-test
      The following packages will be upgraded:
        libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-server mariadb-server-5.5
        mariadb-server-core-5.5
      7 upgraded, 0 newly installed, 0 to remove and 222 not upgraded.
      Need to get 10,3 MB of archives.
      After this operation, 1 166 kB disk space will be freed.
      Do you want to continue? [Y/n] y
      Get:1 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server all 5.5.38+maria-1~trusty [2 894 B]
      Get:2 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main libmysqlclient18 amd64 5.5.38+maria-1~trusty [2 858 B]
      Get:3 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main libmariadbclient18 amd64 5.5.38+maria-1~trusty [519 kB]
      Get:4 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-client-core-5.5 amd64 5.5.38+maria-1~trusty [725 kB]
      Get:5 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-client-5.5 amd64 5.5.38+maria-1~trusty [954 kB]
      Get:6 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server-5.5 amd64 5.5.38+maria-1~trusty [4 291 kB]
      Get:7 http://mirror.mephi.ru/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server-core-5.5 amd64 5.5.38+maria-1~trusty [3 840 kB]
      Fetched 10,3 MB in 4s (2 192 kB/s)                     
      Preconfiguring packages ...
      (Reading database ... 163778 files and directories currently installed.)
      Preparing to unpack .../mariadb-server_5.5.38+maria-1~trusty_all.deb ...
      Unpacking mariadb-server (5.5.38+maria-1~trusty) over (5.5.37-0ubuntu0.14.04.1) ...
      Preparing to unpack .../libmysqlclient18_5.5.38+maria-1~trusty_amd64.deb ...
      Unpacking libmysqlclient18 (5.5.38+maria-1~trusty) over (5.5.37-0ubuntu0.14.04.1) ...
      Preparing to unpack .../libmariadbclient18_5.5.38+maria-1~trusty_amd64.deb ...
      Unpacking libmariadbclient18 (5.5.38+maria-1~trusty) over (5.5.37-0ubuntu0.14.04.1) ...
      dpkg: regarding .../mariadb-client-core-5.5_5.5.38+maria-1~trusty_amd64.deb containing mariadb-client-core-5.5:
       mariadb-client-5.5 conflicts with mysql-client-core-5.5
        mariadb-client-core-5.5 provides mysql-client-core-5.5 and is to be installed.
      
      dpkg: error processing archive /var/cache/apt/archives/mariadb-client-core-5.5_5.5.38+maria-1~trusty_amd64.deb (--unpack):
       conflicting packages - not installing mariadb-client-core-5.5
      dpkg: regarding .../mariadb-client-5.5_5.5.38+maria-1~trusty_amd64.deb containing mariadb-client-5.5:
       mariadb-client-core-5.5 conflicts with mysql-client-5.5
        mariadb-client-5.5 provides mysql-client-5.5 and is to be installed.
      
      dpkg: error processing archive /var/cache/apt/archives/mariadb-client-5.5_5.5.38+maria-1~trusty_amd64.deb (--unpack):
       conflicting packages - not installing mariadb-client-5.5
      Preparing to unpack .../mariadb-server-5.5_5.5.38+maria-1~trusty_amd64.deb ...
       * Stopping MariaDB database server mysqld                                                                         [ OK ] 
       * Stopping MariaDB database server mysqld                                                                         [ OK ] 
      Unpacking mariadb-server-5.5 (5.5.38+maria-1~trusty) over (5.5.37-0ubuntu0.14.04.1) ...
      Preparing to unpack .../mariadb-server-core-5.5_5.5.38+maria-1~trusty_amd64.deb ...
      Unpacking mariadb-server-core-5.5 (5.5.38+maria-1~trusty) over (5.5.37-0ubuntu0.14.04.1) ...
      Processing triggers for man-db (2.6.7.1-1) ...
      Processing triggers for ureadahead (0.100.0-16) ...
      Errors were encountered while processing:
       /var/cache/apt/archives/mariadb-client-core-5.5_5.5.38+maria-1~trusty_amd64.deb
       /var/cache/apt/archives/mariadb-client-5.5_5.5.38+maria-1~trusty_amd64.deb
      E: Sub-process /usr/bin/dpkg returned an error code (1)
      

      Packages after the failed upgrade:

      $ dpkg -l | grep -iP '(maria|mysql)'
      ii  libdbd-mysql-perl                                     4.025-1                                             amd64        Perl5 database interface to the MySQL database
      iU  libmariadbclient18                                    5.5.38+maria-1~trusty                               amd64        MariaDB database client library
      iU  libmysqlclient18                                      5.5.38+maria-1~trusty                               amd64        Virtual package to satisfy external depends
      ii  mariadb-client-5.5                                    5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database client binaries
      ii  mariadb-client-core-5.5                               5.5.37-0ubuntu0.14.04.1                             amd64        MariaDB database core client binaries
      ii  mariadb-common                                        5.5.37-0ubuntu0.14.04.1                             all          MariaDB common metapackage
      iU  mariadb-server                                        5.5.38+maria-1~trusty                               all          MariaDB database server (metapackage depending on the latest version)
      iU  mariadb-server-5.5                                    5.5.38+maria-1~trusty                               amd64        MariaDB database server binaries
      iU  mariadb-server-core-5.5                               5.5.38+maria-1~trusty                               amd64        MariaDB database core server files
      ii  mysql-common                                          5.5.37-0ubuntu0.14.04.1                             all          MySQL database common files, e.g. /etc/mysql/my.cnf
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              elenst Elena Stepanova added a comment -

              Those who ran into the problem, can do the following as a workaround (probably it's not the only way, but it seems to work and fix the broken packages):

              sudo apt-get remove mariadb-server mariadb-server-5.5 mariadb-client-5.5 mariadb-client-core-5.5
              sudo apt-get install mariadb-server
              
              $ dpkg -l | grep -iP '(maria|mysql)'
              ii  libdbd-mysql-perl                                     4.025-1                                             amd64        Perl5 database interface to the MySQL database
              ii  libmariadbclient18                                    5.5.38+maria-1~trusty                               amd64        MariaDB database client library
              ii  libmysqlclient18                                      5.5.38+maria-1~trusty                               amd64        Virtual package to satisfy external depends
              ii  mariadb-client-5.5                                    5.5.38+maria-1~trusty                               amd64        MariaDB database client binaries
              ii  mariadb-client-core-5.5                               5.5.38+maria-1~trusty                               amd64        MariaDB database core client binaries
              ii  mariadb-common                                        5.5.37-0ubuntu0.14.04.1                             all          MariaDB common metapackage
              ii  mariadb-server                                        5.5.38+maria-1~trusty                               all          MariaDB database server (metapackage depending on the latest version)
              ii  mariadb-server-5.5                                    5.5.38+maria-1~trusty                               amd64        MariaDB database server binaries
              ii  mariadb-server-core-5.5                               5.5.38+maria-1~trusty                               amd64        MariaDB database core server files
              ii  mysql-common                                          5.5.37-0ubuntu0.14.04.1                             all          MySQL database common files, e.g. /etc/mysql/my.cnf
              

              Optionally, to get a consistent set, one can also run
              sudo apt-get install mariadb-common mysql-common

              ~$ dpkg -l | grep -iP '(maria|mysql)'
              ii  libdbd-mysql-perl                                     4.025-1                                             amd64        Perl5 database interface to the MySQL database
              ii  libmariadbclient18                                    5.5.38+maria-1~trusty                               amd64        MariaDB database client library
              ii  libmysqlclient18                                      5.5.38+maria-1~trusty                               amd64        Virtual package to satisfy external depends
              ii  mariadb-client-5.5                                    5.5.38+maria-1~trusty                               amd64        MariaDB database client binaries
              ii  mariadb-client-core-5.5                               5.5.38+maria-1~trusty                               amd64        MariaDB database core client binaries
              ii  mariadb-common                                        5.5.38+maria-1~trusty                               all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
              ii  mariadb-server                                        5.5.38+maria-1~trusty                               all          MariaDB database server (metapackage depending on the latest version)
              ii  mariadb-server-5.5                                    5.5.38+maria-1~trusty                               amd64        MariaDB database server binaries
              ii  mariadb-server-core-5.5                               5.5.38+maria-1~trusty                               amd64        MariaDB database core server files
              ii  mysql-common                                          5.5.38+maria-1~trusty                               all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
              
              Show
              elenst Elena Stepanova added a comment - Those who ran into the problem, can do the following as a workaround (probably it's not the only way, but it seems to work and fix the broken packages): sudo apt-get remove mariadb-server mariadb-server-5.5 mariadb-client-5.5 mariadb-client-core-5.5 sudo apt-get install mariadb-server $ dpkg -l | grep -iP '(maria|mysql)' ii libdbd-mysql-perl 4.025-1 amd64 Perl5 database interface to the MySQL database ii libmariadbclient18 5.5.38+maria-1~trusty amd64 MariaDB database client library ii libmysqlclient18 5.5.38+maria-1~trusty amd64 Virtual package to satisfy external depends ii mariadb-client-5.5 5.5.38+maria-1~trusty amd64 MariaDB database client binaries ii mariadb-client-core-5.5 5.5.38+maria-1~trusty amd64 MariaDB database core client binaries ii mariadb-common 5.5.37-0ubuntu0.14.04.1 all MariaDB common metapackage ii mariadb-server 5.5.38+maria-1~trusty all MariaDB database server (metapackage depending on the latest version) ii mariadb-server-5.5 5.5.38+maria-1~trusty amd64 MariaDB database server binaries ii mariadb-server-core-5.5 5.5.38+maria-1~trusty amd64 MariaDB database core server files ii mysql-common 5.5.37-0ubuntu0.14.04.1 all MySQL database common files, e.g. /etc/mysql/my.cnf Optionally, to get a consistent set, one can also run sudo apt-get install mariadb-common mysql-common ~$ dpkg -l | grep -iP '(maria|mysql)' ii libdbd-mysql-perl 4.025-1 amd64 Perl5 database interface to the MySQL database ii libmariadbclient18 5.5.38+maria-1~trusty amd64 MariaDB database client library ii libmysqlclient18 5.5.38+maria-1~trusty amd64 Virtual package to satisfy external depends ii mariadb-client-5.5 5.5.38+maria-1~trusty amd64 MariaDB database client binaries ii mariadb-client-core-5.5 5.5.38+maria-1~trusty amd64 MariaDB database core client binaries ii mariadb-common 5.5.38+maria-1~trusty all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) ii mariadb-server 5.5.38+maria-1~trusty all MariaDB database server (metapackage depending on the latest version) ii mariadb-server-5.5 5.5.38+maria-1~trusty amd64 MariaDB database server binaries ii mariadb-server-core-5.5 5.5.38+maria-1~trusty amd64 MariaDB database core server files ii mysql-common 5.5.38+maria-1~trusty all MariaDB database common files (e.g. /etc/mysql/my.cnf)

                People

                • Assignee:
                  otto Otto Kekäläinen
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated: