Bug #47616 MySQL Upgradation
Submitted: 24 Sep 2009 14:35 Modified: 26 Oct 2009 14:13
Reporter: Rajakumar Velu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.85 OS:Linux
Assigned to: CPU Architecture:Any
Tags: 5.0.45 to 5.0.85

[24 Sep 2009 14:35] Rajakumar Velu
Description:
[root@ympdb6 my_x86]# rpm -Uvh MySQL-server-5.0.85-0.glibc23.x86_64.rpm MySQL-client-5.0.85-0.glibc23.x86_64.rpm MySQL-devel-5.0.85-0.glibc23.x86_64.rpm MySQL-shared-5.0.85-0.glibc23.x86_64.rpm MySQL-shared-compat-5.0.85-0.glibc23.x86_64.rpm MySQL-bench-5.0.85-0.glibc23.x86_64.rpm --force --nodeps
Preparing...                ########################################### [100%]
   1:MySQL-shared-compat    ########################################### [ 17%]

******************************************************************
A MySQL server package (mysql-server-5.0.45-7.el5) is installed.

The current MySQL server package is provided by a different
vendor (CentOS) than MySQL AB.  Some files may be installed
to different locations, including log files and the service
startup script in /etc/init.d/.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MySQL-shared-compat package.
- Install the new MySQL packages supplied by MySQL AB
- Ensure that the MySQL server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
error: %pre(MySQL-server-5.0.85-0.glibc23.x86_64) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.85-0.glibc23
   2:MySQL-client           ########################################### [ 33%]
   3:MySQL-devel            ########################################### [ 50%]
   4:MySQL-shared           ########################################### [ 67%]
   5:MySQL-bench            ########################################### [ 83%]
[root@ympdb6 my_x86]#

How to repeat:
we are tried to upgrade the Mysql version from 5.0.45 to 5.0.85, got the above error then we uninstalled the 5.0.45 then installed 5.0.85 then it started working,

the issue I never faced this kind of issue while previous upgradation.

could you update what we have to to on this error, is my action are correct.

Regards,
Rajakumar

Suggested fix:
I have to be clear before my next upgrade.
[24 Sep 2009 15:15] Valeriy Kravchuk
This behavior of our RPM is expected, and you solved the problem correctly, accordign to the messages you got.

As for previous upgrades, had you upgraded from one CentOS RPM to other CentOS RPM?
[24 Oct 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[26 Oct 2009 12:59] Rajakumar Velu
Hi,
issue got fixed please close it

sorry for the delay

Rajakumar
866-257-2321 Ext 6638