Select Page

RPM “multiple packages” oddity, fixed

Patrick Galbraith | | October 31, 2011

I deal with all shipes and sizes, and distributions, of Linux. Each Linux distribution has quirks. Particularly with package management. There are some people who are religious about RPM (Redhat, Centos, Fedora, Suse, etc.) or APT (Debian, Ubuntu, etc). I see both good and bad points of each. In my daily tasks, I just want “Things to Work (TM)”. I had an interesting problem the other day that I found a solution for that I thought I would share.

The problem was on a server that I was trying to install Percona 5.5 on that already had a stock Centos MySQL 5.1 install. I need to uninstall the existing packages:

[root@host]# rpm -e mysql-5.0.77-4.el5_6.6
error: "mysql-5.0.77-4.el5_6.6" specifies multiple packages

Hmm, this is very odd. I’ve never seen this. There is a way to reveal exactly what the problem is:

[root@host]# rpm -q --queryformat "%{name}.%{arch}n" mysql
mysql.x86_64
mysql.i386

Interesting! So, somehow, someone installed both the 64-bit and 32-bit versions of MySQL. Now that I know the exact error, I was able to remove each separately:

[root@host]# rpm -e mysql.x86_64

[root@host]# rpm -e mysql.i386

[root@host]# rpm -qa|grep mysql

Good, the problem is solved!

So, if ever you find yourself in this predicament, you know what to do. This also gives reason to perhaps to refer back to the RPM manual to find other useful tips.

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS