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

    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

      Attachments

        Issue Links

          Activity

            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)

            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)

            I consider this irrelevant. Nobody should have a need to downgrade from official Ubuntu repos and MariaDB 5.5 to the upstream provided repos with outdated packaging.

            Upgrades to 10.1 or 10.2 from MariaDB.org repos are relevant, as those versions are not yet available in Debian/Ubuntu, but this 5.5. is not relevant.

            otto Otto Kekäläinen added a comment - I consider this irrelevant. Nobody should have a need to downgrade from official Ubuntu repos and MariaDB 5.5 to the upstream provided repos with outdated packaging. Upgrades to 10.1 or 10.2 from MariaDB.org repos are relevant, as those versions are not yet available in Debian/Ubuntu, but this 5.5. is not relevant.

            People

              otto Otto Kekäläinen
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.