MySQL Bugs: #75391: Repository for Fedora 21 is down

Bug #75391	Repository for Fedora 21 is down
Submitted:	2 Jan 2015 14:37	Modified:	6 Jan 2015 22:21
Reporter:	Joaquin Berlanga	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Package Repos	Severity:	S1 (Critical)
Version:		OS:	Linux (Fedora 21 Workstation)
Assigned to:		CPU Architecture:	Any

Description:
failure: repodata/repomd.xml from mysql-connectors-community: [Errno 256] No more mirrors to try.
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/21/x86_...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"

How to repeat:
The server is down for two days.

Hello Joaquin Berlanga,

Thank you for the report.

Thanks,
Umesh

// On a f21 new build

[root@ushastry Downloads]# cat /etc/*release
Fedora release 21 (Twenty One)
NAME=Fedora
VERSION="21 (Twenty One)"
ID=fedora
VERSION_ID=21
PRETTY_NAME="Fedora 21 (Twenty One)"
ANSI_COLOR="0;34"
CPE_NAME="cpe:/o:fedoraproject:fedora:21"
HOME_URL="https://fedoraproject.org/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"
REDHAT_BUGZILLA_PRODUCT="Fedora"
REDHAT_BUGZILLA_PRODUCT_VERSION=21
REDHAT_SUPPORT_PRODUCT="Fedora"
REDHAT_SUPPORT_PRODUCT_VERSION=21
Fedora release 21 (Twenty One)
Fedora release 21 (Twenty One)

[root@ushastry Downloads]# rpm -Uvh mysql-community-release-fc21-5.noarch.rpm 
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-release-fc21-5   ################################# [100%]
[root@ushastry Downloads]# yum repolist all | grep mysql
mysql56-community/21/x86_64         MySQL 5.6 Community Server   enabled:     17
mysql56-community-source/21         MySQL 5.6 Community Server - disabled
mysql57-community-dmr/21/x86_64     MySQL 5.7 Community Server D disabled
mysql57-community-dmr-source/21     MySQL 5.7 Community Server D disabled
[root@ushastry Downloads]# yum repolist enabled | grep mysql
mysql56-community/21/x86_64         MySQL 5.6 Community Server                17

[root@ushastry Downloads]# yum update
Loaded plugins: langpacks
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:fc21-5 will be updated
---> Package mysql-community-release.noarch 0:fc21-11 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================================================================
 Package                                             Arch                               Version                             Repository                                     Size
================================================================================================================================================================================
Updating:
 mysql-community-release                             noarch                             fc21-11                             mysql56-community                             9.9 k

Transaction Summary
================================================================================================================================================================================
Upgrade  1 Package

Total download size: 9.9 k
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mysql56-community
warning: /var/cache/yum/x86_64/21/mysql56-community/packages/mysql-community-release-fc21-11.noarch.rpm: V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY/s |    0 B  --:--:-- ETA 
Public key for mysql-community-release-fc21-11.noarch.rpm is not installed
mysql-community-release-fc21-11.noarch.rpm                                                                                                               | 9.9 kB  00:00:09     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql-community-release-fc21-5.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction (shutdown inhibited)
Warning: RPMDB altered outside of yum.
  Updating   : mysql-community-release-fc21-11.noarch                                                                                                                       1/2 
  Cleanup    : mysql-community-release-fc21-5.noarch                                                                                                                        2/2 
  Verifying  : mysql-community-release-fc21-11.noarch                                                                                                                       1/2 
  Verifying  : mysql-community-release-fc21-5.noarch                                                                                                                        2/2 

Updated:
  mysql-community-release.noarch 0:fc21-11                                                                                                                                      

Complete!
[root@ushastry Downloads]# yum repolist enabled | grep mysql
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/21/x86_...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/21/x86_...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-tools-community/fc/21/x86_64/re...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
mysql-connectors-community/21/x86_64     MySQL Connectors Community            0
mysql-tools-community/21/x86_64          MySQL Tools Community                 0
mysql56-community/21/x86_64              MySQL 5.6 Community Server           17

[root@ushastry Downloads]# yum repolist all | grep mysql
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/21/x86_...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/21/x86_...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-tools-community/fc/21/x86_64/re...: [Errno 14] curl#6 - "Could not resolve host: tyr77.no.oracle.com"
Trying other mirror.
mysql-connectors-community/21/x86_64 MySQL Connectors Community  enabled:      0
mysql-connectors-community-source/21 MySQL Connectors Community  disabled
mysql-tools-community/21/x86_64      MySQL Tools Community       enabled:      0
mysql-tools-community-source/21      MySQL Tools Community - Sou disabled
mysql56-community/21/x86_64          MySQL 5.6 Community Server  enabled:     17
mysql56-community-source/21          MySQL 5.6 Community Server  disabled
mysql57-community-dmr/21/x86_64      MySQL 5.7 Community Server  disabled
mysql57-community-dmr-source/21      MySQL 5.7 Community Server  disabled

Hi Joaquin,

please try following command to fix this issue:

 $ sudo rpm -Uvh --oldpackage http://repo.mysql.com/mysql-community-release-fc21.rpm

To verify fix, run some yum commands:

# Clean metadata:
 
 $ sudo yum clean metadata

# Then run yum update twice to verify repos works as expected:

 $ sudo yum update

 $ sudo yum update

Hi, Terje

It seems that problem apears when I apply the fc21-11 update (with fc21-5 it works).

greetings
Joaquin Berlanga
 
the outputs are:

[root@XXX ~]# rpm -q mysql-community-release
mysql-community-release-fc21-11.noarch

[root@XXX ~]# cat /etc/yum.repos.d/mysql-community.repo 
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-connectors-community/fc/$releas...
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-tools-community/fc/$releasever/...
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-5.6-community/fc/$releasever/$b...
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Note: MySQL 5.7 is currently in development. For use at your own risk.
# Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://tyr77.no.oracle.com/mysql-uat/repos-stage/yum/mysql-5.7-community/fc/$releasever/$b...
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Hi Terje,

I followed your instructions and yum has recovered package 21.5.
The repositories have been cleaned and reload again with yum update

Everything is ok now.

When the new repository update is ready, you can tell me to prove it, I have a netbook for tests that I do not use for anything else, I have no problem to experiment.

Greetings