Bug #59364 Upgrading MySQL 5.1.41 to 5.5.8 got [ERROR] Aborting
Submitted: 7 Jan 2011 22:20 Modified: 10 Jan 2011 16:01
Reporter: steven tang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.41 OS:Linux
Assigned to:

[7 Jan 2011 22:20] steven tang
Description:
Currently I am running MySQL 5.1.41 with InnoDB plugin 1.0.6. I want to upgrade it to latest MySQL 5.5.8. 

[root@dev80 mysql]# pwd
/usr/local/mysql

[root@dev80 mysql]# dir
total 208
drwxr-xr-x 13 mysql mysql   4096 Dec 15 10:50 ./
drwxr-xr-x 14 root  root    4096 Jan  7 14:07 ../
drwxr-xr-x  2 mysql mysql   4096 Jan  6 10:06 bin/
-rw-r--r--  1 mysql mysql  17987 Dec  3 09:58 COPYING
drwxr-xr-x  5 mysql mysql   4096 Jan  7 14:09 data/
drwxr-xr-x  2 mysql mysql   4096 Dec 15 10:50 docs/
drwxr-xr-x  3 mysql mysql   4096 Dec 15 10:50 include/
-rw-r--r--  1 mysql mysql  12386 Dec 15 11:31 INSTALL-BINARY
drwxr-xr-x  3 mysql mysql   4096 Dec 15 10:50 lib/
drwxr-xr-x  4 mysql mysql   4096 Dec 15 10:50 man/
drwxr-xr-x 10 mysql mysql   4096 Dec 15 10:50 mysql-test/
-rw-r--r--  1 mysql mysql 113534 Dec  3 09:58 README
drwxr-xr-x  2 mysql mysql   4096 Dec 15 10:50 scripts/
drwxr-xr-x 27 mysql mysql   4096 Dec 15 10:50 share/
drwxr-xr-x  4 mysql mysql   4096 Dec 15 10:50 sql-bench/
drwxr-xr-x  2 mysql mysql   4096 Dec 15 10:50 support-files/

I copied my 5.1.41 mysql database to 5.5.8 installation location:
  /usr/local/mysql/data/mysql

and run following:

[root@dev80 mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
110107 14:04:01 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
ERROR: 1136  Column count doesn't match value count at row 1
110107 14:04:01 [ERROR] Aborting

110107 14:04:01 [Note] ./bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
./data for more information.

You can try to start the mysqld daemon with:

    shell> ./bin/mysqld --skip-grant &

and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> ./bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in ./data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the ./bin/mysqlbug script!

Even I fixed comment from char(64) to text, but I still got:

[root@dev80 mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1136  Column count doesn't match value count at row 1
110107 14:09:00 [ERROR] Aborting

...

How to repeat:
just run:

# scripts/mysql_install_db --user=mysql
[7 Jan 2011 22:29] Peter Laursen
Will this help: 
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html

"start the server with the --skip-grant-tables option to cause it to skip the normal grant table checks, then run mysql_upgrade. ... Then stop the server and restart it normally."

Peter
(not a MySQL person)
[8 Jan 2011 9:15] Valerii Kravchuk
Please, check if Peter's suggestion helps you to solve the problem.
[10 Jan 2011 16:01] steven tang
It does work.

Thanks,
Steven