Bug #18516 mysql_upgrade missing in binary packages
Submitted: 26 Mar 2006 11:06 Modified: 3 Jul 2006 18:46
Reporter: Aaron Judd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.0.20a, 5.0.19 OS:Any (all)
Assigned to: Joerg Bruehe CPU Architecture:Any

[26 Mar 2006 11:06] Aaron Judd
Description:
I couldn't find mysql_upgrade in any of the x86_64 rpm's.. only the source

# rpm -qpl MySQL-server-5.0.19-0.glibc23.x86_64.rpm  |grep upgrade
warning: MySQL-server-5.0.19-0.glibc23.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
[root@svr01 mysql_5]# 

How to repeat:
Look in the rpm's...

Suggested fix:
Add it.
[28 Mar 2006 9:04] Alan Robinson
I have the same problem with the i386 package.
[27 Apr 2006 15:50] Valeriy Kravchuk
Please, check with a newer version, 5.0.20a, and inform about the results.
[27 Apr 2006 16:44] Aaron Judd
Not in server/x86_64 rpm:

*******************************************************
rpm -qpl MySQL-server-standard-5.0.20a-0.rhel3.x86_64.rpm 

warning: MySQL-server-standard-5.0.20a-0.rhel3.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
/etc/init.d/mysql
/etc/logrotate.d/mysql
/usr/bin/my_print_defaults
/usr/bin/myisam_ftdump
/usr/bin/myisamchk
/usr/bin/myisamlog
/usr/bin/myisampack
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_create_system_tables
/usr/bin/mysql_explain_log
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysql_install_db
/usr/bin/mysql_secure_installation
/usr/bin/mysql_setpermission
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_zap
/usr/bin/mysqlbug
/usr/bin/mysqld_multi
/usr/bin/mysqld_safe
/usr/bin/mysqlhotcopy
/usr/bin/mysqltest
/usr/bin/perror
/usr/bin/replace
/usr/bin/resolve_stack_dump
/usr/bin/resolveip
/usr/bin/safe_mysqld
/usr/lib64/mysql/mysqld.sym
/usr/sbin/mysqld
/usr/sbin/mysqlmanager
/usr/sbin/rcmysql
/usr/share/doc/MySQL-server-standard-5.0.20a
/usr/share/doc/MySQL-server-standard-5.0.20a/COPYING
/usr/share/doc/MySQL-server-standard-5.0.20a/README
/usr/share/doc/MySQL-server-standard-5.0.20a/my-huge.cnf
/usr/share/doc/MySQL-server-standard-5.0.20a/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-standard-5.0.20a/my-large.cnf
/usr/share/doc/MySQL-server-standard-5.0.20a/my-medium.cnf
/usr/share/doc/MySQL-server-standard-5.0.20a/my-small.cnf
/usr/share/info/mysql.info.gz
/usr/share/man/man1/mysql_fix_privilege_tables.1.gz
/usr/share/man/man1/mysql_zap.1.gz
/usr/share/man/man1/mysqld.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/perror.1.gz
/usr/share/man/man1/replace.1.gz
/usr/share/mysql
/usr/share/mysql/binary-configure
/usr/share/mysql/charsets
/usr/share/mysql/charsets/Index.xml
/usr/share/mysql/charsets/README
/usr/share/mysql/charsets/armscii8.xml
/usr/share/mysql/charsets/ascii.xml
/usr/share/mysql/charsets/cp1250.xml
/usr/share/mysql/charsets/cp1251.xml
/usr/share/mysql/charsets/cp1256.xml
/usr/share/mysql/charsets/cp1257.xml
/usr/share/mysql/charsets/cp850.xml
/usr/share/mysql/charsets/cp852.xml
/usr/share/mysql/charsets/cp866.xml
/usr/share/mysql/charsets/dec8.xml
/usr/share/mysql/charsets/geostd8.xml
/usr/share/mysql/charsets/greek.xml
/usr/share/mysql/charsets/hebrew.xml
/usr/share/mysql/charsets/hp8.xml
/usr/share/mysql/charsets/keybcs2.xml
/usr/share/mysql/charsets/koi8r.xml
/usr/share/mysql/charsets/koi8u.xml
/usr/share/mysql/charsets/latin1.xml
/usr/share/mysql/charsets/latin2.xml
/usr/share/mysql/charsets/latin5.xml
/usr/share/mysql/charsets/latin7.xml
/usr/share/mysql/charsets/macce.xml
/usr/share/mysql/charsets/macroman.xml
/usr/share/mysql/charsets/swe7.xml
/usr/share/mysql/czech
/usr/share/mysql/czech/errmsg.sys
/usr/share/mysql/danish
/usr/share/mysql/danish/errmsg.sys
/usr/share/mysql/dutch
/usr/share/mysql/dutch/errmsg.sys
/usr/share/mysql/english
/usr/share/mysql/english/errmsg.sys
/usr/share/mysql/errmsg.txt
/usr/share/mysql/estonian
/usr/share/mysql/estonian/errmsg.sys
/usr/share/mysql/fill_help_tables.sql
/usr/share/mysql/french
/usr/share/mysql/french/errmsg.sys
/usr/share/mysql/german
/usr/share/mysql/german/errmsg.sys
/usr/share/mysql/greek
/usr/share/mysql/greek/errmsg.sys
/usr/share/mysql/hungarian
/usr/share/mysql/hungarian/errmsg.sys
/usr/share/mysql/italian
/usr/share/mysql/italian/errmsg.sys
/usr/share/mysql/japanese
/usr/share/mysql/japanese/errmsg.sys
/usr/share/mysql/korean
/usr/share/mysql/korean/errmsg.sys
/usr/share/mysql/mi_test_all
/usr/share/mysql/mi_test_all.res
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/mysql-log-rotate
/usr/share/mysql/mysql.server
/usr/share/mysql/mysql_fix_privilege_tables.sql
/usr/share/mysql/ndb-config-2-node.ini
/usr/share/mysql/norwegian
/usr/share/mysql/norwegian-ny
/usr/share/mysql/norwegian-ny/errmsg.sys
/usr/share/mysql/norwegian/errmsg.sys
/usr/share/mysql/polish
/usr/share/mysql/polish/errmsg.sys
/usr/share/mysql/portuguese
/usr/share/mysql/portuguese/errmsg.sys
/usr/share/mysql/romanian
/usr/share/mysql/romanian/errmsg.sys
/usr/share/mysql/russian
/usr/share/mysql/russian/errmsg.sys
/usr/share/mysql/serbian
/usr/share/mysql/serbian/errmsg.sys
/usr/share/mysql/slovak
/usr/share/mysql/slovak/errmsg.sys
/usr/share/mysql/spanish
/usr/share/mysql/spanish/errmsg.sys
/usr/share/mysql/swedish
/usr/share/mysql/swedish/errmsg.sys
/usr/share/mysql/ukrainian
/usr/share/mysql/ukrainian/errmsg.sys

************************************************
and client:
************************************************
rpm -qpl MySQL-client-standard-5.0.20a-0.rhel3.x86_64.rpm 
warning: MySQL-client-standard-5.0.20a-0.rhel3.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
/usr/bin/msql2mysql
/usr/bin/mysql
/usr/bin/mysql_client_test
/usr/bin/mysql_find_rows
/usr/bin/mysql_tableinfo
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/bin/mysqlimport
/usr/bin/mysqlshow
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlshow.1.gz

*********************************************
Not in 386 either:
*********************************************

 rpm -qpl MySQL-server-standard-5.0.20a-0.rhel3.i386.rpm |grep upgrade
warning: MySQL-server-standard-5.0.20a-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
[root@web3 ~]# mysql_upgrade
-bash: mysql_upgrade: command not found
[20 Jun 2006 20:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7962
[20 Jun 2006 20:41] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7967
[20 Jun 2006 20:52] Joerg Bruehe
mysql_upgrade is now included in the RPMs,
and will be called during RPM upgrade.

More details will be added to this report.
[22 Jun 2006 12:28] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8066
[23 Jun 2006 10:17] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8134
[27 Jun 2006 16:48] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8333
[27 Jun 2006 18:18] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8344
[28 Jun 2006 10:47] Joerg Bruehe
In fact, the binary "mysql_upgrade" had been missing in all packages, not just the RPMs. This had gone undetected because its name is that of the (old) shell script.

This error has now been corrected: Starting from 5.0.23 (and 5.1.12-beta), all binary packages (tar.gz as well as the platform-specific RPM, PKG, depot, dmg; also on Windows) will contain the binary "mysql_upgrade".

Note that this tool cannot yet be called reliably during an upgrade of the MySQL software, so it is the user's (DBA etc.) responsibility to call the tool after the software upgrade has been finished.
[29 Jun 2006 9:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8469
[3 Jul 2006 18:46] Paul DuBois
Noted in 5.0.23, 5.1.12 changelogs.

mysql_upgrade was missing from binary MySQL distributions.