Bug #40292 Re-install of rpm fails
Submitted: 24 Oct 2008 0:16 Modified: 28 Feb 2009 14:29
Reporter: Michelle Caisse Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.1.29-rc OS:Linux (2.4.21-32.EL)
Assigned to: Assigned Account CPU Architecture:Any

[24 Oct 2008 0:16] Michelle Caisse 
Description:
Package MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm installs correctly the first time, but gives an error on reinstallation after being uninstalled.

[qauser@qa-rhas3-ia64 michelle]$ sudo rpm -ivh MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm
Preparing...                ########################################### [100%]
   1:MySQL-server-advanced-g########################################### [100%]
ERROR: 1136  Column count doesn't match value count at row 1
081024  1:33:20 [ERROR] Aborting

081024  1:33:20 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

How to repeat:
sudo rpm -ivh MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm

sudo rpm -e MySQL-server-advanced-gpl-5.1.29-0.rhel3

sudo rpm -ivh MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm
[24 Oct 2008 0:24] Michelle Caisse 
screen dump of commands and output

Attachment: screendump.txt (text/plain), 5.92 KiB.
[24 Oct 2008 0:28] Michelle Caisse 
/var/lib/mysql/qa-rhas3-ia64.mysql.com.err

Attachment: qa-rhas3-ia64.mysql.com.err (application/octet-stream, text), 12.78 KiB.
[10 Nov 2008 20:13] Michelle Caisse 
I confirmed that this problem exists with MySQL-server-5.1.30-0.glibc23.ia64.rpm and MySQL-server-advanced-5.1.30-0.rhel3.ia64.rpm. 

In spite of the error message, the server does start.

Please provide instructions for a manual work-around to do cleanup that the uninstall is apparently not doing.
[10 Nov 2008 22:07] Michelle Caisse 
This problem was due to an older mysql installation on the test machine. The rpms are fine.
[10 Nov 2008 22:55] Michelle Caisse 
RPM install should not give an error message when installing over an older version.
[29 Jan 2009 14:29] Kent Boortz 
Could you please specify what kind of install was there before the upgrade,
that did interfere? Also, was a MySQL server running when upgrading?

Would help a lot if I would get more details how to reproduce this
problem, or clarification if I misunderstood.
[1 Mar 2009 0: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".