Bug #59339 after upgraded to 5.5.8 , ran mysql_upgrade, got FATAL ERROR: Upgrade failed

• Submitted: 6 Jan 2011 20:11
• Modified: 6 Jan 2011 21:47
• Reporter: steven tang
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: MySQL 5.5.8
• OS: Linux (mysqlcheck: unknown option '--fix-db-names')
• CPU Architecture: Any

[6 Jan 2011 20:11] steven tang

Description:
After upgraded to MySQL 5.5.8 and then ran mysql_upgrade as suggested by MySQL, I got following FATAL ERROR: Upgrade failed

[root@dev80 data]# mysql -uroot -p<p> -hdev80
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.5.8-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye
[root@dev80 data]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: unknown option '--fix-db-names'
FATAL ERROR: Upgrade failed

How to repeat:
just ran the utility

[6 Jan 2011 20:43] Valeriy Kravchuk

Are you sure that mysql_upgrade from proper version, 5.5.8, is called? Please, send the results of:

which mysql_upgrade

Linux command.

[6 Jan 2011 20:48] steven tang

[root@dev80 data]# which mysql_upgrade
/usr/local/mysql/bin/mysql_upgrade

[root@dev80 data]# mysql_upgrade --help
mysql_upgrade  Ver 1.1 Distrib 5.5.8, for linux2.6 (x86_64)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

MySQL utility for upgrading databases to new MySQL versions.

[6 Jan 2011 20:59] Valeriy Kravchuk

Please, send the results of:

mysqlcheck --version

[6 Jan 2011 21:10] steven tang

Found the problem: in somehow under /usr/bin/, there also some mysql stuff:

[root@dev80 bin]# pwd
/usr/bin
[root@dev80 bin]# dir mysql*
-rwxr-xr-x 1 root root 314568 May 27  2010 mysql*
-rwxr-xr-x 1 root root 110776 May 27  2010 mysqlaccess*
-rwxr-xr-x 1 root root  35144 May 27  2010 mysqladmin*
-rwxr-xr-x 1 root root 112944 May 27  2010 mysqlbinlog*
-rwxr-xr-x 1 root root  30576 May 27  2010 mysqlcheck*
-rwxr-xr-x 1 root root   7632 May 27  2010 mysql_config*
-rwxr-xr-x 1 root root  75184 May 27  2010 mysqldump*
-rwxr-xr-x 1 root root   3245 May 27  2010 mysql_find_rows*
-rwxr-xr-x 1 root root  26160 May 27  2010 mysqlimport*
-rwxr-xr-x 1 root root  28224 May 27  2010 mysqlshow*
-rwxr-xr-x 1 root root  14473 May 27  2010 mysql_tableinfo*
-rwxr-xr-x 1 root root 112136 May 27  2010 mysql_waitpid*
[root@dev80 bin]# del mysql*

Now the mysql_upgrade has been run properly.

[root@dev80 bin]# mysql_upgrade -hdev80 -p<p> 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--host=dev80' 
Running 'mysqlcheck' with connection arguments: '--host=dev80' 
mysql.columns_priv                                 OK
mysql.db                                           OK
...

Thanks,
Steven

[6 Jan 2011 21:47] Valeriy Kravchuk

Good news. The problem was, probably, not a result of any bug in 5.5.8...