[MDEV-9796] MariaDB cannot be installed from MariaDB's repo on openSUSE 13, SLES12: conflict with the default repo Created: 2016-03-27  Updated: 2020-04-22  Resolved: 2017-05-18

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform SUSE
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-22329 Packages issues when upgrading Open
Relates
relates to MDEV-9584 Upgrading MariaDB 5.5 to 10.1.11 fail... Stalled
relates to MDEV-9766 Testing for MDEV-9584 (Relaxed rules ... Stalled
Sprint: 10.1.14

 Description   

rpm -qa | grep -iE 'maria|mysql|galera|percona'
# none
sudo zypper install -y MariaDB-server MariaDB-client
...
Resolving package dependencies...
 
Problem: mariadb-client-5.5.46-13.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.13-1.x86_64
 Solution 1: Following actions will be done:
  do not install MariaDB-client-10.1.13-1.x86_64
  do not install MariaDB-server-10.1.13-1.x86_64
 Solution 2: do not install mariadb-client-5.5.46-13.1.x86_64

Same for 5.5, 10.0.

The workaround is to specify the repo:

sudo zypper install -y --from mariadb MariaDB-server MariaDB-client
...
Resolving package dependencies...
 
The following 6 NEW packages are going to be installed:
  boost-license1_53_0 galera libboost_program_options1_53_0 MariaDB-client 
  MariaDB-common MariaDB-server 
 
6 new packages to install.

Installation test in buildbot does not catch it because it installs actual RPMs files rather than refers to a repo, and installing files also works. That's another workaround, although in general less convenient than specifying the repo.



 Comments   
Comment by Elena Stepanova [ 2016-03-27 ]

I've added the above-mentioned workaround to the buildbot tests, if it ever gets fixed, please reassign it back to me so I could remove it.

Comment by Elena Stepanova [ 2016-03-28 ]

It turns out we even have a note about in the repo configurator:
https://downloads.mariadb.org/mariadb/repositories/#mirror=netinch&distro_release=opensuse13-amd64--opensuse13&distro=openSUSE&version=10.1

Comment by Elena Stepanova [ 2016-03-31 ]

When MariaDB 10.1 is installed over the default mariadb provided by openSUSE, the workaround does not help:

rpm -qa | grep -iE 'maria|mysql|galera|percona'
mariadb-errormessages-5.5.46-13.1.x86_64
libmysqlclient18-5.5.46-13.1.x86_64
mariadb-client-5.5.46-13.1.x86_64
mariadb-5.5.46-13.1.x86_64
 
sudo zypper --non-interactive --no-gpg-checks install -y --from local MariaDB-server MariaDB-client
..
2 Problems:
Problem: mariadb-client-5.5.46-13.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.14-1.x86_64
Problem: mariadb-5.5.46-13.1.x86_64 conflicts with namespace:otherproviders(mysql-server) provided by MariaDB-server-10.1.14-1.x86_64
 
Problem: mariadb-client-5.5.46-13.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.14-1.x86_64
 Solution 1: deinstallation of mariadb-client-5.5.46-13.1.x86_64
 Solution 2: do not install MariaDB-client-10.1.14-1.x86_64

Comment by Elena Stepanova [ 2016-03-31 ]

Same for installing over mysql-community-server:

Problem: mysql-community-server-client-5.6.28-7.19.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.14-1.x86_64
Problem: mysql-community-server-5.6.28-7.19.1.x86_64 conflicts with namespace:otherproviders(mysql-server) provided by MariaDB-server-10.1.14-1.x86_64
 
Problem: mysql-community-server-client-5.6.28-7.19.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.14-1.x86_64

Comment by Sergei Golubchik [ 2017-05-18 ]

I don't think we can fix it. zypper compares package names case-insensitively, and SUSE repository has mariadb-client package:

$ sudo zypper -v install mArIaDb-cLiEnT
Selecting 'MariaDB-client-10.1.24-1.x86_64' from repository 'local' for installation.
Selecting 'mariadb-client-5.5.46-13.1.x86_64' from repository 'openSUSE-13.1-Update' for installation.
Problem: mariadb-client-5.5.46-13.1.x86_64 conflicts with namespace:otherproviders(mysql-client) provided by MariaDB-client-10.1.24-1.x86_64
 Solution 1: do not install mariadb-client-5.5.46-13.1.x86_64
 Solution 2: do not install MariaDB-client-10.1.24-1.x86_64
 
Choose from above solutions by number or cancel [1/2/c] (c): 

See? Letter case does not matter, both packages are selected. Not selected as dependencies, directly selected by the command line.

On the other hand, installing our packages over SUSE ones, works without any additional options:

$ sudo zypper -v in mariadb-client
Selecting 'MariaDB-client-10.1.24-1.x86_64' from repository 'cpack' for installation.
'mariadb-client' is already installed.
No update candidate for 'mariadb-client-5.5.46-13.1.x86_64'. The highest available version is already installed.
 
The following 2 NEW packages are going to be installed:
  MariaDB-client  10.1.24-1
  MariaDB-common  10.1.24-1
 
The following package is going to be REMOVED:
  mariadb-client  5.5.46-13.1
 
2 new packages to install, 1 to remove.
Overall download size: 28.3 MiB. After the operation, additional 152.2 MiB will 
be used.
Continue? [y/n/? shows all options] (y): 

Apparently zypper treats it as an upgrade and a higher version wins.

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