[MDEV-6326] Upgrade from Ubuntu's MariaDB 5.5.37 to MariaDB's 5.5.38 does not work Created: 2014-06-11  Updated: 2016-11-25  Resolved: 2016-11-25

Status: Closed
Project: MariaDB Server
Component/s: Platform Debian
Affects Version/s: 5.5.38
Fix Version/s: 5.5.54

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Otto Kekäläinen
Resolution: Won't Fix Votes: 0
Labels: packaging
Environment:

Ubuntu 14.04 Trusty

Issue Links:
Blocks
is blocked by MDEV-6284 Merge downstream Debian/Ubuntu packag... Closed

 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



 Comments   
Comment by Elena Stepanova [ 2014-06-11 ]

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)

Comment by Otto Kekäläinen [ 2016-11-25 ]

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.

Generated at Thu Feb 08 07:11:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.