Too many MySQLs?

[premierhosting]

Code: Select all

# rpm -qa | grep mysql
asl-php-mysql-5.2.17-1.el5.art
mysql-5.1.56-1.el5.art
php-mysql-5.3.8-1.el5.art
mysql-libs-5.1.59-1.el5.art
mysql-5.1.57-1.el5.art
mysql-5.1.58-1.el5.art
mysql-5.1.58-2.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-5.1.59-1.el5.art
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-server-5.1.59-1.el5.art

Does that look like too many MySQL's to anyone else?

[scott]

It sure does! The remove event happens after the %post event, so if that fails remove never happens. Check to see if you're getting errors on something when you upgrade

[premierhosting]

/usr/share/info/dir is an empty file, that's all for errors.

How would one go about fixing it, without breaking anything?

[scott]

look at the triggers & scripts used in the package:

rpm -q --scripts <packagename> and then work backwards from there. Fix whatever that is failing on and it should be good to go

[premierhosting]

Code: Select all

[root@server1 info]#  rpm -q --scripts mysql-5.1.57-1.el5.art
preinstall scriptlet (using /bin/sh):
/usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash \
        -c "MySQL Server" -u 27 mysql > /dev/null 2>&1 || :
postinstall scriptlet (using /bin/sh):
/sbin/install-info /usr/share/info/mysql.info.gz /usr/share/info/dir
preuninstall scriptlet (using /bin/sh):
if [ $1 = 0 ]; then
    /sbin/install-info --delete /usr/share/info/mysql.info.gz /usr/share/info/dir || :
fi

I rebuilt /usr/share/info/dir because it had gotten toasted by some rpmsave function. Rebuilt it like this:

Code: Select all

rm dir
for f in * ; do install-info $f dir ; done

Still have too many mysqls

Code: Select all

[root@server1 info]# rpm -qa | grep mysql
asl-php-mysql-5.2.17-1.el5.art
mysql-5.1.56-1.el5.art
php-mysql-5.3.8-1.el5.art
mysql-libs-5.1.59-1.el5.art
mysql-5.1.57-1.el5.art
mysql-5.1.58-1.el5.art
mysql-5.1.58-2.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-5.1.59-1.el5.art
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-server-5.1.59-1.el5.art

Ran the postinstall script, no changes to rpm list.

Code: Select all

/sbin/install-info /usr/share/info/mysql.info.gz /usr/share/info/dir

Any more suggestions? Does this mean those other mysqls are actually there or just in an RPM db somewhere?

Code: Select all

[root@server1 bin]# ./mysql --version
./mysql  Ver 14.14 Distrib 5.1.59, for redhat-linux-gnu (x86_64) using readline 5.1

Code: Select all

[root@server1 rpm]# rpm -qf /usr/bin/mysql
mysql-5.1.56-1.el5.art
mysql-5.1.57-1.el5.art
mysql-5.1.58-1.el5.art
mysql-5.1.58-2.el5.art
mysql-5.1.59-1.el5.art

[mikeshinn]

Have you tried removing mysql (backup everything first) and then installing it?

[hostingguy]

can you just use yum or rpm to remove the ones you dont want?

like
rpm -e mysql-5.1.57-1.el5.art --nodeps

Or does that kill them all then?

[premierhosting]

I was too afraid to remove mysqls. So I just kept upgrading, and the upgrade before this one from atomic-testing cleaned up after itself and the previous unclean upgrades.