MySQL Bugs: #18516: mysql_upgrade missing in binary packages

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

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.

I have the same problem with the i386 package.

Please, check with a newer version, 5.0.20a, and inform about the results.

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

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

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

mysql_upgrade is now included in the RPMs,
and will be called during RPM upgrade.

More details will be added to this report.

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

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

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

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

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.

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

Noted in 5.0.23, 5.1.12 changelogs.

mysql_upgrade was missing from binary MySQL distributions.