Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
N/A
-
None
Description
- Install MariaDB-common, e.g. from 10.9, on RHEL
- Try to install MariaDB-server from bb-11.0-danielblack-preview-
MDEV-30203-fix
Transaction check error:
|
file /usr/lib64/mysql from install of MariaDB-server-11.0.1-1.el7_9.x86_64 conflicts with file from package MariaDB-common-10.9.4-1.el7.centos.x86_64
|
file /usr/share/mysql from install of MariaDB-server-11.0.1-1.el7_9.x86_64 conflicts with file from package MariaDB-common-10.9.4-1.el7.centos.x86_64
|
file /usr/lib64/mysql/plugin from install of MariaDB-server-11.0.1-1.el7_9.x86_64 conflicts with file from package MariaDB-common-10.9.4-1.el7.centos.x86_64
|
It doesn't happen with MariaDB 10.10 server over the same 10.9 MariaDB-common.
Attachments
Issue Links
- is caused by
-
MDEV-30203 Move mysql symlinks to different package
-
- Closed
-
Activity
Simpler case. Two repos "mariadb" - public 10.9 repo. MariaDB2.repo/bb-11.0-danielblack-preview-MDEV-30203-pkgtest - updated version.
rhel8 without MariaDB installed |
|
[root@citest-1 dan]# vi /etc/yum.repos.d/MariaDB2.repo
|
[root@citest-1 dan]# yum install MariaDB-common-10.9.4
|
Updating Subscription Management repositories.
|
Last metadata expiration check: 0:04:59 ago on Wed 08 Feb 2023 06:25:25 PM EST.
|
Dependencies resolved.
|
===========================================================================================================================================================================================================
|
Package Architecture Version Repository Size
|
===========================================================================================================================================================================================================
|
Installing:
|
MariaDB-common x86_64 10.9.4-1.el8 mariadb 88 k
|
Installing dependencies:
|
MariaDB-shared x86_64 10.9.5-1.el8 mariadb 119 k
|
|
Transaction Summary
|
===========================================================================================================================================================================================================
|
Install 2 Packages
|
...
|
Running transaction
|
Preparing : 1/1
|
Running scriptlet: MariaDB-shared-10.9.5-1.el8.x86_64 1/2
|
Installing : MariaDB-shared-10.9.5-1.el8.x86_64 1/2
|
Running scriptlet: MariaDB-shared-10.9.5-1.el8.x86_64 1/2
|
Running scriptlet: MariaDB-common-10.9.4-1.el8.x86_64 2/2
|
Installing : MariaDB-common-10.9.4-1.el8.x86_64 2/2
|
Running scriptlet: MariaDB-common-10.9.4-1.el8.x86_64 2/2
|
Verifying : MariaDB-common-10.9.4-1.el8.x86_64 1/2
|
Verifying : MariaDB-shared-10.9.5-1.el8.x86_64 2/2
|
Installed products updated.
|
|
Installed:
|
MariaDB-common-10.9.4-1.el8.x86_64 MariaDB-shared-10.9.5-1.el8.x86_64
|
|
Complete!
|
[root@citest-1 dan]# vi /etc/yum.repos.d/MariaDB2.repo
|
[root@citest-1 dan]# yum install MariaDB-server
|
Updating Subscription Management repositories.
|
MariaDB bb-11.0-danielblack-preview-MDEV-30203-pkgtestrepo (build 32350) 1.5 kB/s | 3.0 kB 00:02
|
Dependencies resolved.
|
===========================================================================================================================================================================================================
|
Package Architecture Version Repository Size
|
===========================================================================================================================================================================================================
|
Installing:
|
MariaDB-server x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 27 M
|
Upgrading:
|
MariaDB-common x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 88 k
|
Installing dependencies:
|
|
Complete!
|
[root@citest-1 dan]# yum list installed | grep -i mariadb
|
MariaDB-client.x86_64 11.0.0-1.el8 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-client-compat.noarch 11.0.0-1.el8 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-common.x86_64 11.0.0-1.el8 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-server.x86_64 11.0.0-1.el8 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-server-compat.noarch 11.0.0-1.el8 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-shared.x86_64 10.9.5-1.el8 @mariadb
|
galera-4.x86_64 26.4.14-1.el8 @mariadb
|
[root@citest-1 dan]# rpm -ql MariaDB-shared
|
/etc/my.cnf.d
|
/etc/my.cnf.d/client.cnf
|
/usr/lib/.build-id
|
/usr/lib/.build-id/f4
|
/usr/lib/.build-id/f4/2c02f8524309327714f2487363d4ea10da3d84
|
/usr/lib64/libmariadb.so.3
|
Client works with older shared library, so not doing anything here:
[root@citest-1 dan]# systemctl start mariadb.service
|
[root@citest-1 dan]# mariadb
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 3
|
Server version: 11.0.0-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> \s
|
--------------
|
mariadb from 11.0.0-MariaDB, client 15.2 for Linux (x86_64) using EditLine wrapper
|
Will condense fixes with MDEV-30571 into bb-11.0-all-builders
same on rhel7 |
Installed:
|
MariaDB-common.x86_64 0:10.9.5-1.el7.centos MariaDB-compat.x86_64 0:10.9.5-1.el7.centos
|
|
Replaced:
|
mariadb-libs.x86_64 1:5.5.68-1.el7
|
|
Complete!
|
[root@localhost ~]# yum install MariaDB-server
|
...
|
Installed:
|
MariaDB-server.x86_64 0:11.0.0-1.el7_9
|
|
Dependency Installed:
|
MariaDB-client.x86_64 0:11.0.0-1.el7_9 MariaDB-client-compat.noarch 0:11.0.0-1.el7_9 MariaDB-server-compat.noarch 0:11.0.0-1.el7_9 boost-program-options.x86_64 0:1.53.0-28.el7
|
galera-4.x86_64 0:26.4.14-1.el7.centos libaio.x86_64 0:0.3.109-13.el7 lsof.x86_64 0:4.87-6.el7 pcre2.x86_64 0:10.23-2.el7
|
perl.x86_64 4:5.16.3-299.el7_9 perl-Carp.noarch 0:1.26-244.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7
|
perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-Encode.x86_64 0:2.51-7.el7 perl-Exporter.noarch 0:5.68-3.el7
|
perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7 perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7
|
perl-HTTP-Tiny.noarch 0:0.033-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PathTools.x86_64 0:3.40-5.el7
|
perl-PlRPC.noarch 0:0.2020-14.el7 perl-Pod-Escapes.noarch 1:1.04-299.el7_9 perl-Pod-Perldoc.noarch 0:3.20-4.el7 perl-Pod-Simple.noarch 1:3.28-4.el7
|
perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 perl-Socket.x86_64 0:2.010-5.el7 perl-Storable.x86_64 0:2.45-3.el7
|
perl-Text-ParseWords.noarch 0:3.29-4.el7 perl-Time-HiRes.x86_64 4:1.9725-3.el7 perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7
|
perl-libs.x86_64 4:5.16.3-299.el7_9 perl-macros.x86_64 4:5.16.3-299.el7_9 perl-parent.noarch 1:0.225-244.el7 perl-podlators.noarch 0:2.5.1-3.el7
|
perl-threads.x86_64 0:1.87-4.el7 perl-threads-shared.x86_64 0:1.43-6.el7 pv.x86_64 0:1.4.6-1.el7 socat.x86_64 0:1.7.3.2-2.el7
|
|
Dependency Updated:
|
MariaDB-common.x86_64 0:11.0.0-1.el7_9
|
|
Complete!
|
[root@localhost ~]# yum list installed | grep -i mariadb
|
MariaDB-client.x86_64 11.0.0-1.el7_9 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-client-compat.noarch 11.0.0-1.el7_9 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-common.x86_64 11.0.0-1.el7_9 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-compat.x86_64 10.9.5-1.el7.centos @mariadb
|
MariaDB-server.x86_64 11.0.0-1.el7_9 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
MariaDB-server-compat.noarch 11.0.0-1.el7_9 @MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest
|
galera-4.x86_64 26.4.14-1.el7.centos @mariadb
|
So common is updated. Compat isn't, but its a soft dependency used by postfix et al.
Pused to bb-11.0-all-builders.
The conflict was apparently happening due to different permissions on the files in test packages comparing to the release ones (as the test packages were built in a different environment). I re-run the same test with packages built by that test environment vs those built by buildbot (same revision, b66cbe1876) – there is no conflict when the buildbot ones are used, while it is still reproducible with the packages built elsewhere. So I close it as not-a-bug.
bb-11.0-danielblack-preview-
MDEV-30203-pkgtest (1615bf32bcdf3fe787891c456efdbcd7b8bc1e32)https://ci.mariadb.org/32350/amd64-rhel-8-rpm-autobake/rpms/
rhel8
[root@citest-1 dan]# cat /etc/yum.repos.d/MariaDB.repo
# MariaDB 10.9 RedHatEnterpriseLinux repository list - created 2023-02-08 07:20 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
# baseurl = https://rpm.mariadb.org/10.9/rhel/$releasever/$basearch
baseurl = http://mirror.aarnet.edu.au/pub/MariaDB/yum/10.9/rhel/$releasever/$basearch
# gpgkey= https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey=http://mirror.aarnet.edu.au/pub/MariaDB/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
module_hotfixes=1
[root@citest-1 dan]# sudo yum install MariaDB-server MariaDB-client
Updating Subscription Management repositories.
MariaDB 59 kB/s | 3.4 kB 00:00
Dependencies resolved.
==================================================================================================================================
Package Arch Version Repository Size
==================================================================================================================================
Installing:
MariaDB-client x86_64 10.9.5-1.el8 mariadb 15 M
MariaDB-server x86_64 10.9.5-1.el8 mariadb 26 M
...
(success)
[root@citest-1 dan]# cat /etc/yum.repos.d/MariaDB2.repo
[MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest]
name=MariaDB bb-11.0-danielblack-preview-MDEV-30203-pkgtestrepo (build 32350)
baseurl=https://ci.mariadb.org/32350/amd64-rhel-8-rpm-autobake/rpms
gpgcheck=0
module_hotfixes=1
[root@citest-1 dan]# yum update
Updating Subscription Management repositories.
MariaDB bb-11.0-danielblack-preview-MDEV-30203-pkgtestrepo (build 32350) 44 kB/s | 204 kB 00:04
Last metadata expiration check: 0:00:02 ago on Wed 08 Feb 2023 03:18:12 AM EST.
Dependencies resolved.
==================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================
Upgrading:
MariaDB-client x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 16 M
MariaDB-common x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 88 k
MariaDB-server x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 27 M
MariaDB-shared x86_64 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 120 k
Installing dependencies:
liburing x86_64 1.0.7-3.el8 rhel-8-for-x86_64-appstream-rpms 24 k
Installing weak dependencies:
MariaDB-client-compat noarch 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 12 k
MariaDB-server-compat noarch 11.0.0-1.el8 MariaDB-bb-11.0-danielblack-preview-MDEV-30203-pkgtest 9.1 k
Transaction Summary
==================================================================================================================================
Install 3 Packages
Upgrade 4 Packages
Total download size: 43 M
Is this ok [y/N]: y
Downloading Packages:
(1/7): liburing-1.0.7-3.el8.x86_64.rpm 30 kB/s | 24 kB 00:00
(2/7): MariaDB-client-compat-11.0.0-1.el8.noarch.rpm 7.3 kB/s | 12 kB 00:01
(3/7): MariaDB-server-compat-11.0.0-1.el8.noarch.rpm 3.9 kB/s | 9.1 kB 00:02
(4/7): MariaDB-common-11.0.0-1.el8.x86_64.rpm 73 kB/s | 88 kB 00:01
(5/7): MariaDB-shared-11.0.0-1.el8.x86_64.rpm 183 kB/s | 120 kB 00:00
(6/7): MariaDB-client-11.0.0-1.el8.x86_64.rpm 524 kB/s | 16 MB 00:32
(7/7): MariaDB-server-11.0.0-1.el8.x86_64.rpm 574 kB/s | 27 MB 00:47
----------------------------------------------------------------------------------------------------------------------------------
Total 890 kB/s | 43 MB 00:49
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Running scriptlet: MariaDB-shared-11.0.0-1.el8.x86_64 1/1
Running scriptlet: MariaDB-common-11.0.0-1.el8.x86_64 1/1
Running scriptlet: MariaDB-client-11.0.0-1.el8.x86_64 1/1
Running scriptlet: MariaDB-client-compat-11.0.0-1.el8.noarch 1/1
Running scriptlet: MariaDB-server-compat-11.0.0-1.el8.noarch 1/1
Running scriptlet: MariaDB-server-11.0.0-1.el8.x86_64 1/1
Preparing : 1/1
Running scriptlet: MariaDB-shared-11.0.0-1.el8.x86_64 1/1
Running scriptlet: MariaDB-shared-11.0.0-1.el8.x86_64 1/11
Upgrading : MariaDB-shared-11.0.0-1.el8.x86_64 1/11
Running scriptlet: MariaDB-shared-11.0.0-1.el8.x86_64 1/11
Running scriptlet: MariaDB-common-11.0.0-1.el8.x86_64 2/11
Upgrading : MariaDB-common-11.0.0-1.el8.x86_64 2/11
Running scriptlet: MariaDB-common-11.0.0-1.el8.x86_64 2/11
Installing : liburing-1.0.7-3.el8.x86_64 3/11
Running scriptlet: MariaDB-client-11.0.0-1.el8.x86_64 4/11
Upgrading : MariaDB-client-11.0.0-1.el8.x86_64 4/11
Running scriptlet: MariaDB-client-11.0.0-1.el8.x86_64 4/11
Running scriptlet: MariaDB-client-compat-11.0.0-1.el8.noarch 5/11
Installing : MariaDB-client-compat-11.0.0-1.el8.noarch 5/11
Running scriptlet: MariaDB-client-compat-11.0.0-1.el8.noarch 5/11
Running scriptlet: MariaDB-server-compat-11.0.0-1.el8.noarch 6/11
Installing : MariaDB-server-compat-11.0.0-1.el8.noarch 6/11
Running scriptlet: MariaDB-server-compat-11.0.0-1.el8.noarch 6/11
Running scriptlet: MariaDB-server-11.0.0-1.el8.x86_64 7/11
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.9.5-1.el8.x86_64) is installed.
Upgrading directly from MySQL 10.9 to MariaDB 11.0 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-11.0.0-1.el8.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server
Running scriptlet: MariaDB-client-10.9.5-1.el8.x86_64 8/11
error: MariaDB-server-11.0.0-1.el8.x86_64: install failed
error: MariaDB-server-10.9.5-1.el8.x86_64: erase skipped
Cleanup : MariaDB-client-10.9.5-1.el8.x86_64 8/11
Running scriptlet: MariaDB-client-10.9.5-1.el8.x86_64 8/11
Running scriptlet: MariaDB-common-10.9.5-1.el8.x86_64 9/11
Cleanup : MariaDB-common-10.9.5-1.el8.x86_64 9/11
Running scriptlet: MariaDB-common-10.9.5-1.el8.x86_64 9/11
Running scriptlet: MariaDB-shared-10.9.5-1.el8.x86_64 10/11
Cleanup : MariaDB-shared-10.9.5-1.el8.x86_64 10/11
Running scriptlet: MariaDB-shared-10.9.5-1.el8.x86_64 10/11
Running scriptlet: MariaDB-shared-11.0.0-1.el8.x86_64 10/11
Running scriptlet: MariaDB-common-11.0.0-1.el8.x86_64 10/11
Running scriptlet: MariaDB-client-11.0.0-1.el8.x86_64 10/11
Running scriptlet: MariaDB-client-compat-11.0.0-1.el8.noarch 10/11
Running scriptlet: MariaDB-server-compat-11.0.0-1.el8.noarch 10/11
Running scriptlet: MariaDB-shared-10.9.5-1.el8.x86_64 10/11
Verifying : MariaDB-client-compat-11.0.0-1.el8.noarch 1/11
Verifying : MariaDB-server-compat-11.0.0-1.el8.noarch 2/11
Verifying : liburing-1.0.7-3.el8.x86_64 3/11
Verifying : MariaDB-client-11.0.0-1.el8.x86_64 4/11
Verifying : MariaDB-client-10.9.5-1.el8.x86_64 5/11
Verifying : MariaDB-common-11.0.0-1.el8.x86_64 6/11
Verifying : MariaDB-common-10.9.5-1.el8.x86_64 7/11
Verifying : MariaDB-server-11.0.0-1.el8.x86_64 8/11
Verifying : MariaDB-server-10.9.5-1.el8.x86_64 9/11
Verifying : MariaDB-shared-11.0.0-1.el8.x86_64 10/11
Verifying : MariaDB-shared-10.9.5-1.el8.x86_64 11/11
Installed products updated.
Upgraded:
MariaDB-client-11.0.0-1.el8.x86_64 MariaDB-common-11.0.0-1.el8.x86_64 MariaDB-shared-11.0.0-1.el8.x86_64
Installed:
MariaDB-client-compat-11.0.0-1.el8.noarch MariaDB-server-compat-11.0.0-1.el8.noarch liburing-1.0.7-3.el8.x86_64
Failed:
MariaDB-server-10.9.5-1.el8.x86_64 MariaDB-server-11.0.0-1.el8.x86_64
Error: Transaction failed
So self conflicts avoided.
[root@citest-1 dan]# yum remove MariaDB-server
Updating Subscription Management repositories.
Dependencies resolved.
================================================================================================================================================================
Package Architecture Version Repository Size
================================================================================================================================================================
Removing:
MariaDB-server x86_64 10.9.5-1.el8 @mariadb 121 M
Removing unused dependencies:
boost-program-options x86_64 1.66.0-13.el8 @rhel-8-for-x86_64-appstream-rpms 523 k
galera-4 x86_64 26.4.14-1.el8 @mariadb 62 M
libaio x86_64 0.3.112-1.el8 @rhel-8-for-x86_64-baseos-rpms 93 k
lsof x86_64 4.93.2-1.el8 @rhel-8-for-x86_64-baseos-rpms 623 k
socat x86_64 1.7.4.1-1.el8 @rhel-8-for-x86_64-appstream-rpms 1.2 M
Transaction Summary
================================================================================================================================================================
Remove 6 Packages
Freed space: 186 M
Is this ok [y/N]: y
Running transaction check
Error: transaction check vs depsolve:
MariaDB-server >= 11.0.0 is needed by (installed) MariaDB-server-compat-11.0.0-1.el8.noarch
To diagnose the problem, try running: 'rpm -Va --nofiles --nodigest'.
You probably have corrupted RPMDB, running 'rpm --rebuilddb' might fix the issue.
[root@citest-1 dan]# rpm -qa | grep -i '^mysql-'
[root@citest-1 dan]#
[root@citest-1 dan]# rpm -Va --nofiles --nodigest
Unsatisfied dependencies for MariaDB-server-10.9.5-1.el8.x86_64:
MariaDB-server < 11.0.0 conflicts with (installed) MariaDB-common-11.0.0-1.el8.x86_64
MariaDB-server < 11.0.0 conflicts with (installed) MariaDB-client-11.0.0-1.el8.x86_64
Unsatisfied dependencies for MariaDB-common-11.0.0-1.el8.x86_64:
MariaDB-server < 11.0.0 conflicts with (installed) MariaDB-common-11.0.0-1.el8.x86_64
Unsatisfied dependencies for MariaDB-client-11.0.0-1.el8.x86_64:
MariaDB-server < 11.0.0 conflicts with (installed) MariaDB-client-11.0.0-1.el8.x86_64
Unsatisfied dependencies for MariaDB-server-compat-11.0.0-1.el8.noarch:
MariaDB-server >= 11.0.0 is needed by (installed) MariaDB-server-compat-11.0.0-1.el8.noarch
So support-files/rpm/server-prein.sh appears in need of a large update.