Background

There is a bit of an annoying error that I get whenever I issue yum commands against my Linux CentOS host.

Error

The error reads :-

Image

Textual

Repository packages-microsoft-com-prod is listed more than once in the configuration

Troubleshooting

Yum Repository

/etc/yum.repos.d

Objective

Let us look into our /etc/yum.repos.d folder and see which files reference packages-microsoft-com-prod

Command

Syntax

grep -r [repository] /etc/yum.repos.d

Sample

grep -r packages-microsoft-com-prod /etc/yum.repos.d

Output

Output – Image

Output – Text

grep -r packages-microsoft-com-prod /etc/yum.repos.d

/etc/yum.repos.d/microsoft.repo:[packages-microsoft-com-prod]
/etc/yum.repos.d/microsoft.repo:name=packages-microsoft-com-prod

/etc/yum.repos.d/msprod.repo:[packages-microsoft-com-prod]
/etc/yum.repos.d/msprod.repo:name=packages-microsoft-com-prod

/etc/yum.repos.d/mssql-release.repo:[packages-microsoft-com-prod]
/etc/yum.repos.d/mssql-release.repo:name=packages-microsoft-com-prod

Explanation

The following files reference packages-microsoft-com-prod

1. /etc/yum.repos.d/microsoft.repo
2. /etc/yum.repos.d/msprod.repo
3. /etc/yum.repos.d/mssql-release.repo

Why so many files

Google to the Rescue

1) microsoft.repo

Googled on microsoft.repo and ended up here :-

Docs > PowerShell > Scripting
Installing PowerShell Core on Linux
Link

The relevant curl command reads :-

# Register the Microsoft RedHat repository
curl https://packages.microsoft.com/config/rhel/7/prod.repo | sudo tee /etc/yum.repos.d/microsoft.repo

If one downloads https://packages.microsoft.com/config/rhel/7/prod.repo, it will read

[packages-microsoft-com-prod]
name=packages-microsoft-com-prod
baseurl=https://packages.microsoft.com/rhel/7/prod/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc

We see that issuing curl and capturing its output via tee, creates a new file, microsoft.repo.

The targeted repository is packages-microsoft-com-prod.

2) msprod.repo

Googled on msprod.repo and ended up here :-

Docs > SQL > SQL Server on Linux > Concepts > Install  >Install SQL Server tools
Install sqlcmd and bcp the SQL Server command-line tools on Linux
Link

The relevant command reads :-

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

If one downloads https://packages.microsoft.com/config/rhel/7/prod.repo, it will read

[packages-microsoft-com-prod]
name=packages-microsoft-com-prod
baseurl=https://packages.microsoft.com/rhel/7/prod/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc

We see that issuing curl creates a new file, msprod.repo, but the repository is packages-microsoft-com-prod.

3) mssql-release.repo

Googled on mssql-release.repo and ended up here :-

Docs > SQL > SQL Server on Linux > Concepts > Install > Configure repositories
Configure repositories for installing and upgrading SQL Server on Linux
Link

The relevant command reads :-

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-preview.repo

If one downloads https://packages.microsoft.com/config/rhel/7/prod.repo, it will read

[packages-microsoft-com-mssql-server-preview]
name=packages-microsoft-com-mssql-server-preview
baseurl=https://packages.microsoft.com/rhel/7/mssql-server-preview/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc

We see that issuing curl creates a new file, mssql-server.repo, and the repository is packages-microsoft-com-mssql-server-preview.

Remediation

Sourcing

Here is how we got our various repo files

1. File :- /etc/yum.repos.d/microsoft.repo
   • Source :- Installing Powershell
   • Repository :- packages-microsoft-com-prod
2. /etc/yum.repos.d/msprod.repo
   • Source :- Installing Microsoft SQL Server v2017
   • Repository :- packages-microsoft-com-prod
3. /etc/yum.repos.d/mssql-server.repo
   • Source :- Upgrading Microsoft SQL Server from v2017 to v2019
   • Repository :- packages-microsoft-com-mssql-server-preview

Duplicates

The duplicate files in our case are /etc/yum.repos.d/microsoft.repo and /etc/yum.repos.d/msprod.repo.

Remove

Decision

We will remove /etc/yum.repos.d/msprod.repo

Syntax

sudo rm /etc/yum.repos.d/[file].repo

Sample

sudo rm /etc/yum.repos.d/msprod.repo

Review

Outline

Here are some tools one can use to go see if things are well.

1. yum repolist
2. yum check

Tasks

yum repolist

Sample

yum repolist all | grep microsoft

Output

Explanation

1. Once we removed the duplicate repository file, we are left with the following repositories
   • package-microsoft-com-mssql-server-preview
   • packages-microsoft-com-prod

yum check

Sample

yum check all

Output

Sample – Time

time yum check all

Output

Explanation

1. Issuing, yum check all, took about 12 1/2 minutes on my host.

Summary

Another beginner mistake.

Created duplicated repo files.

The fact that they are pointing at the same repository is causing a bit of havoc.