Bug #73113 yum update fails when community repo enabld and mariadb-embedded-devel installed
Submitted: 25 Jun 2014 13:24 Modified: 29 Jul 2014 21:11
Reporter: Ramana Yeruva Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Package Repos and Docker Images Severity:S3 (Non-critical)
Version:5.6.19 OS:Any
Assigned to: CPU Architecture:Any

[25 Jun 2014 13:24] Ramana Yeruva
Description:
clean system
clean data directory(if exists)
install community repo file
install mariadb-embedded-devel.i686
update yum repository

How to repeat:
yum -y remove 'mysql*
yum -y remove 'maria*'
rm -rf /var/lib/mysql
rm -rf /etc/my.cnf
wget http://tyr77.no.oracle.com/mysql-uat/repos-stage/mysql-community-release-el7-11.noarch.rpm
yum -y install mysql-community-release-el7-11.noarch.rpm
yum-complete-transaction --cleanup-only
yum clean all
yum clean all
yum --disablerepo=\* --enablerepo=mysql55-community clean metadata
yum --disablerepo=\* --enablerepo=mysql56-community clean metadata
yum --disablerepo=\* --enablerepo=mysql57-community-dmr clean metadata
yum --disablerepo=\* --enablerepo=mysql55-community list 'mysql-community*'
yum --disablerepo=\* --enablerepo=mysql56-community list 'mysql-community*'
yum --disablerepo=\* --enablerepo=mysql57-community-dmr list
'mysql-community*'

yum -y install mariadb-embedded-devel.i686

yum -y update<--observe conflicts
Resolving Dependencies
--> Running transaction check
---> Package mariadb-devel.i686 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-32) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.i686
---> Package mariadb-libs.i686 1:5.5.35-3.el7 will be obsoleted
---> Package mysql-community-devel.i686 0:5.6.19-3.el7 will be obsoleting
---> Package mysql-community-libs.i686 0:5.6.19-3.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-32) = 5.6.19-3.el7 for package: mysql-community-libs-5.6.19-3.el7.i686
--> Running transaction check
---> Package mariadb-devel.i686 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-32) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.i686
---> Package mysql-community-common.i686 0:5.6.19-3.el7 will be installed
--> Finished Dependency Resolution
Error: Package: 1:mariadb-embedded-devel-5.5.35-3.el7.i686 (@optional)
           Requires: mariadb-devel(x86-32) = 1:5.5.35-3.el7
           Removing: 1:mariadb-devel-5.5.35-3.el7.i686 (@os)
               mariadb-devel(x86-32) = 1:5.5.35-3.el7
           Obsoleted By: mysql-community-devel-5.6.19-3.el7.i686 (mysql56-community)
               Not found
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Detailed log:
https://clustra.no.oracle.com/~sysqa/MySQL_Testing_Accessible/DistrosRepository/Reports/EL...

Suggested fix:
on preliminary analysis by Terje found that
community repo doesn't have mysql-community-embebbed-devel.i686 where mariadb has on latest version of EL7 but doesn't have on previous version of EL7

previous release results for same scenario:
https://clustra.no.oracle.com/~sysqa/MySQL_Testing_Accessible/DistrosRepository/Reports/EL...
[25 Jun 2014 13:27] Ramana Yeruva
Posted by developer:
 
https://clustra.no.oracle.com/~sysqa/MySQL_Testing_Accessible/DistrosRepository/Reports/EL...
[25 Jun 2014 13:51] Ramana Yeruva
Posted by developer:
 
[lroot@vitro77 repository_code]# yum install mariadb-embedded-devel.x86_64
epel                                                                                                                                               | 3.7 kB  00:00:00     
errata                                                                                                                                             | 2.9 kB  00:00:00     
optional                                                                                                                                           |  951 B  00:00:00     
os                                                                                                                                                 | 3.6 kB  00:00:00     
(1/5): os/x86_64/group_gz                                                                                                                          | 133 kB  00:00:00     
(2/5): errata/x86_64/primary_db                                                                                                                    | 4.8 kB  00:00:00     
(3/5): os/x86_64/primary_db                                                                                                                        | 3.9 MB  00:00:00     
(4/5): epel/group_gz                                                                                                                               | 163 kB  00:00:02     
(5/5): epel/primary_db                                                                                                                             | 1.9 MB  00:00:05     
optional/primary                                                                                                                                   | 1.2 MB  00:00:04     
optional                                                                                                                                                        4087/4087
Resolving Dependencies
--> Running transaction check
---> Package mariadb-embedded-devel.x86_64 1:5.5.35-3.el7 will be installed
--> Processing Dependency: mariadb-devel(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
--> Processing Dependency: mariadb-embedded(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
--> Processing Dependency: libmysqld.so.18()(64bit) for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.35-3.el7 will be installed
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-devel-5.5.35-3.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:mariadb-devel-5.5.35-3.el7.x86_64
---> Package mariadb-embedded.x86_64 1:5.5.35-3.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================================================================
 Package                                           Arch                              Version                                    Repository                           Size
==========================================================================================================================================================================
Installing:
 mariadb-embedded-devel                            x86_64                            1:5.5.35-3.el7                             optional                            7.3 M
Installing for dependencies:
 mariadb-devel                                     x86_64                            1:5.5.35-3.el7                             os                                  743 k
 mariadb-embedded                                  x86_64                            1:5.5.35-3.el7                             optional                            3.6 M
 mariadb-libs                                      x86_64                            1:5.5.35-3.el7                             os                                  752 k

Transaction Summary
==========================================================================================================================================================================
Install  1 Package (+3 Dependent packages)

Total download size: 12 M
Installed size: 48 M
Is this ok [y/d/N]: y
Downloading packages:
(1/4): mariadb-devel-5.5.35-3.el7.x86_64.rpm                                                                                                       | 743 kB  00:00:00     
(2/4): mariadb-libs-5.5.35-3.el7.x86_64.rpm                                                                                                        | 752 kB  00:00:00     
(3/4): mariadb-embedded-5.5.35-3.el7.x86_64.rpm                                                                                                    | 3.6 MB  00:00:11     
(4/4): mariadb-embedded-devel-5.5.35-3.el7.x86_64.rpm                                                                                              | 7.3 MB  00:00:21     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                     582 kB/s |  12 MB  00:00:21     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : 1:mariadb-embedded-5.5.35-3.el7.x86_64                                                                                                                 1/4 
  Installing : 1:mariadb-libs-5.5.35-3.el7.x86_64                                                                                                                     2/4 
  Installing : 1:mariadb-devel-5.5.35-3.el7.x86_64                                                                                                                    3/4 
  Installing : 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64                                                                                                           4/4 
  Verifying  : 1:mariadb-devel-5.5.35-3.el7.x86_64                                                                                                                    1/4 
  Verifying  : 1:mariadb-libs-5.5.35-3.el7.x86_64                                                                                                                     2/4 
  Verifying  : 1:mariadb-embedded-5.5.35-3.el7.x86_64                                                                                                                 3/4 
  Verifying  : 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64                                                                                                           4/4 

Installed:
  mariadb-embedded-devel.x86_64 1:5.5.35-3.el7                                                                                                                            

Dependency Installed:
  mariadb-devel.x86_64 1:5.5.35-3.el7                    mariadb-embedded.x86_64 1:5.5.35-3.el7                    mariadb-libs.x86_64 1:5.5.35-3.el7                   

Complete!
[lroot@vitro77 repository_code]# yum install mysql-community-release-el7-11.noarch.rpm 
Examining mysql-community-release-el7-11.noarch.rpm: mysql-community-release-el7-11.noarch
Marking mysql-community-release-el7-11.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el7-11 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================================================================
 Package                                      Arch                        Version                       Repository                                                   Size
==========================================================================================================================================================================
Installing:
 mysql-community-release                      noarch                      el7-11                        /mysql-community-release-el7-11.noarch                      4.6 k

Transaction Summary
==========================================================================================================================================================================
Install  1 Package

Total size: 4.6 k
Installed size: 4.6 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-release-el7-11.noarch                                                                                                                  1/1 
  Verifying  : mysql-community-release-el7-11.noarch                                                                                                                  1/1 

Installed:
  mysql-community-release.noarch 0:el7-11                                                                                                                                 

Complete!
[lroot@vitro77 repository_code]# source clean.sh 
No unfinished transactions left.
Cleaning repos: epel errata mysql-connectors-community mysql-tools-community mysql56-community optional os
Cleaning up everything
Cleaning repos: epel errata mysql-connectors-community mysql-tools-community mysql56-community optional os
Cleaning up everything
Cleaning repos: mysql55-community
2 metadata files removed
2 sqlite files removed
0 metadata files removed
Cleaning repos: mysql56-community
0 metadata files removed
0 sqlite files removed
0 metadata files removed
Cleaning repos: mysql57-community-dmr
2 metadata files removed
2 sqlite files removed
0 metadata files removed
mysql55-community                                                                                                                                  | 2.5 kB  00:00:00     
mysql55-community/x86_64/primary_db                                                                                                                |  33 kB  00:00:00     
Installed Packages
mysql-community-release.noarch                                                el7-11                                               @/mysql-community-release-el7-11.noarch
Available Packages
mysql-community-bench.x86_64                                                  5.5.38-3.el7                                         mysql55-community                      
mysql-community-client.i686                                                   5.5.38-3.el7                                         mysql55-community                      
mysql-community-client.x86_64                                                 5.5.38-3.el7                                         mysql55-community                      
mysql-community-common.i686                                                   5.5.38-3.el7                                         mysql55-community                      
mysql-community-common.x86_64                                                 5.5.38-3.el7                                         mysql55-community                      
mysql-community-devel.i686                                                    5.5.38-3.el7                                         mysql55-community                      
mysql-community-devel.x86_64                                                  5.5.38-3.el7                                         mysql55-community                      
mysql-community-embedded.x86_64                                               5.5.38-3.el7                                         mysql55-community                      
mysql-community-embedded-devel.x86_64                                         5.5.38-3.el7                                         mysql55-community                      
mysql-community-libs.i686                                                     5.5.38-3.el7                                         mysql55-community                      
mysql-community-libs.x86_64                                                   5.5.38-3.el7                                         mysql55-community                      
mysql-community-server.x86_64                                                 5.5.38-3.el7                                         mysql55-community                      
mysql-community-test.x86_64                                                   5.5.38-3.el7                                         mysql55-community                      
mysql56-community                                                                                                                                  | 2.5 kB  00:00:00     
mysql56-community/x86_64/primary_db                                                                                                                |  35 kB  00:00:00     
Installed Packages
mysql-community-release.noarch                                                el7-11                                               @/mysql-community-release-el7-11.noarch
Available Packages
mysql-community-bench.x86_64                                                  5.6.19-3.el7                                         mysql56-community                      
mysql-community-client.i686                                                   5.6.19-3.el7                                         mysql56-community                      
mysql-community-client.x86_64                                                 5.6.19-3.el7                                         mysql56-community                      
mysql-community-common.i686                                                   5.6.19-3.el7                                         mysql56-community                      
mysql-community-common.x86_64                                                 5.6.19-3.el7                                         mysql56-community                      
mysql-community-devel.i686                                                    5.6.19-3.el7                                         mysql56-community                      
mysql-community-devel.x86_64                                                  5.6.19-3.el7                                         mysql56-community                      
mysql-community-embedded.x86_64                                               5.6.19-3.el7                                         mysql56-community                      
mysql-community-embedded-devel.x86_64                                         5.6.19-3.el7                                         mysql56-community                      
mysql-community-libs.i686                                                     5.6.19-3.el7                                         mysql56-community                      
mysql-community-libs.x86_64                                                   5.6.19-3.el7                                         mysql56-community                      
mysql-community-server.x86_64                                                 5.6.19-3.el7                                         mysql56-community                      
mysql-community-test.x86_64                                                   5.6.19-3.el7                                         mysql56-community                      
mysql57-community-dmr                                                                                                                              | 2.5 kB  00:00:00     
mysql57-community-dmr/x86_64/primary_db                                                                                                            |  21 kB  00:00:00     
Installed Packages
mysql-community-release.noarch                                             el7-11                                                  @/mysql-community-release-el7-11.noarch
Available Packages
mysql-community-client.i686                                                5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-client.x86_64                                              5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-common.i686                                                5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-common.x86_64                                              5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-devel.i686                                                 5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-devel.x86_64                                               5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-embedded.x86_64                                            5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-embedded-devel.x86_64                                      5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-libs.i686                                                  5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-libs.x86_64                                                5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-server.x86_64                                              5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
mysql-community-test.x86_64                                                5.7.4-0.3.m14.el7                                       mysql57-community-dmr                  
[lroot@vitro77 repository_code]# yum update
epel                                                                                                                                               | 3.7 kB  00:00:00     
errata                                                                                                                                             | 2.9 kB  00:00:00     
mysql-connectors-community                                                                                                                         | 2.5 kB  00:00:00     
mysql-tools-community                                                                                                                              | 2.5 kB  00:00:00     
optional                                                                                                                                           |  951 B  00:00:00     
os                                                                                                                                                 | 3.6 kB  00:00:00     
(1/7): errata/x86_64/primary_db                                                                                                                    | 4.8 kB  00:00:00     
(2/7): os/x86_64/group_gz                                                                                                                          | 133 kB  00:00:00     
(3/7): os/x86_64/primary_db                                                                                                                        | 3.9 MB  00:00:00     
(4/7): mysql-connectors-community/x86_64/primary_db                                                                                                | 6.6 kB  00:00:00     
(5/7): mysql-tools-community/x86_64/primary_db                                                                                                     | 4.3 kB  00:00:00     
(6/7): epel/group_gz                                                                                                                               | 163 kB  00:00:02     
(7/7): epel/primary_db                                                                                                                             | 1.9 MB  00:00:05     
optional/primary                                                                                                                                   | 1.2 MB  00:00:04     
optional                                                                                                                                                        4087/4087
Resolving Dependencies
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be obsoleted
---> Package mysql-community-devel.x86_64 0:5.6.19-3.el7 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.19-3.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.19-3.el7 for package: mysql-community-libs-5.6.19-3.el7.x86_64
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.19-3.el7 will be installed
--> Finished Dependency Resolution
Error: Package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64 (@optional)
           Requires: mariadb-devel(x86-64) = 1:5.5.35-3.el7
           Removing: 1:mariadb-devel-5.5.35-3.el7.x86_64 (@os)
               mariadb-devel(x86-64) = 1:5.5.35-3.el7
           Obsoleted By: mysql-community-devel-5.6.19-3.el7.x86_64 (mysql56-community)
               Not found
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[lroot@vitro77 repository_code]# yum --disablerepo=\* --enablerepo=mysql56-community update 'mysql-community*'
Resolving Dependencies
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be obsoleted
---> Package mysql-community-devel.x86_64 0:5.6.19-3.el7 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.19-3.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.19-3.el7 for package: mysql-community-libs-5.6.19-3.el7.x86_64
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.35-3.el7 will be obsoleted
--> Processing Dependency: mariadb-devel(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.19-3.el7 will be installed
--> Finished Dependency Resolution
Error: Package: 1:mariadb-embedded-devel-5.5.35-3.el7.x86_64 (@optional)
           Requires: mariadb-devel(x86-64) = 1:5.5.35-3.el7
           Removing: 1:mariadb-devel-5.5.35-3.el7.x86_64 (@os)
               mariadb-devel(x86-64) = 1:5.5.35-3.el7
           Obsoleted By: mysql-community-devel-5.6.19-3.el7.x86_64 (mysql56-community)
               Not found
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[25 Jun 2014 16:55] Ramana Yeruva
Posted by developer:
 
similar symptoms:
https://clustra.no.oracle.com/~sysqa/MySQL_Testing_Accessible/DistrosRepository/Reports/EL...
https://clustra.no.oracle.com/~sysqa/MySQL_Testing_Accessible/DistrosRepository/Reports/EL...
[29 Jul 2014 21:11] Daniel So
A fix of the issue has been included in the upcoming release of the MySQL 5.5.39, 5.6.20, and 5.7.5-m15 MySQL Yum Repository packages for EL7 platforms.