Bug #31654 Upgrade from 5.0.45-0 to 5.1.22-0 failed
Submitted: 16 Oct 2007 22:34 Modified: 22 Mar 2008 20:24
Reporter: Donovan Hsieh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.22-0 OS:Linux
Assigned to: Assigned Account CPU Architecture:Any

[16 Oct 2007 22:34] Donovan Hsieh
Description:
rpm -e MySQL-server-community-5.0.45-0.rhel4.i386.rpm
rpm -Uvh MySQL-server-community-5.1.22-0.rhel4.i386.rpm 
warning: MySQL-server-community-5.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
ERROR: 1136  Column count doesn't match value count at row 1
071016 15:07:53 [ERROR] Aborting

071016 15:07:53 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

cat rac1.mycorpdomain.com.err
071016 15:33:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
071016 15:33:04  InnoDB: Started; log sequence number 0 425424240
071016 15:33:04 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
071016 15:33:04 [Note] Starting MySQL Cluster Binlog Thread
071016 15:33:04 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50122. Please use mysql_upgrade to fix this error.
071016 15:33:04 [ERROR] mysql.user has no `Event_priv` column at position 29
071016 15:33:04 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
071016 15:33:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.22-rc-community'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)

How to repeat:
rpm -e MySQL-server-community-5.0.45-0.rhel4.i386.rpm
rpm -Uvh MySQL-server-community-5.1.22-0.rhel4.i386.rpm 
warning: MySQL-server-community-5.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
ERROR: 1136  Column count doesn't match value count at row 1
071016 15:07:53 [ERROR] Aborting

071016 15:07:53 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!
[22 Feb 2008 20:24] Sveta Smirnova
Thank you for the report.

I could not repeat described behavior with versions 5.0.45 and 5.1.22 in my environment. Please try with current versions 5.0.51a and 5.1.23 and inform us about results.
[23 Mar 2008 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".