Issued:
2009-12-23
Updated:
2009-12-23

RHBA-2009:1693 - mysql bug fix update

Synopsis

mysql bug fix update

Type/Severity

Bug Fix Advisory

Topic

Updated mysql packages that fix a bug are now available.

Description

MySQL is a multi-user, multi-threaded SQL database server. MySQL is a client/server implementation consisting of a server daemon (mysqld) and many different client programs and libraries.

These updated mysql packages fix a bug which occurred after updating the mysql packages from version 5.0.45, which was released as a part of Red Hat Enterprise Linux 5.2, to version 5.0.77, which was released as part of the Red Hat Enterprise Linux 5.4 update. A MySQL slave server could crash during replication if a DATE or DATETIME type was compared to the result of the NAME_CONST() function, which commonly happens when stored procedures are used alongside replication. Also, following such a crash, the slave server would be restarted, perform crash recovery, and then crash again once it reached the same point where it performs the comparison, and repeat this cycle continuously. This has been fixed in these updated packages so that the slave server does not crash during replication if a DATE or DATETIME type is compared with the result of the NAME_CONST() function. (BZ#538731)

All mysql users, and especially those using replication, are advised to upgrade to these updated packages, which resolve this issue.

Solution

Before applying this update, make sure that all previously-released errata relevant to your system have been applied.

This update is available via Red Hat Network. Details on how to use the Red Hat Network to apply this update are available at This content is not included.http://kbase.redhat.com/faq/docs/DOC-11259

Affected Products

ProductVersionArch
Red Hat Enterprise Linux for x86_64 - Extended Update Support5.4x86_64
Red Hat Enterprise Linux for x86_64 - Extended Update Support5.4ia64
Red Hat Enterprise Linux for x86_64 - Extended Update Support5.4i386
Red Hat Enterprise Linux for Power, big endian5ppc
Red Hat Enterprise Linux for Power, big endian - Extended Update Support5.4ppc
Red Hat Enterprise Linux for IBM z Systems5s390x
Red Hat Enterprise Linux for IBM z Systems - Extended Update Support5.4s390x
Red Hat Enterprise Linux Workstation5x86_64
Red Hat Enterprise Linux Workstation5i386
Red Hat Enterprise Linux Server5x86_64
Red Hat Enterprise Linux Server5ia64
Red Hat Enterprise Linux Server5i386
Red Hat Enterprise Linux Server from RHUI5x86_64
Red Hat Enterprise Linux Server from RHUI5i386
Red Hat Enterprise Linux Desktop5x86_64
Red Hat Enterprise Linux Desktop5i386

Updated Packages

  • mysql-5.0.77-4.el5_4.1.i386.rpm
  • mysql-bench-5.0.77-4.el5_4.1.i386.rpm
  • mysql-test-5.0.77-4.el5_4.1.s390x.rpm
  • mysql-5.0.77-4.el5_4.1.ppc.rpm
  • mysql-server-5.0.77-4.el5_4.1.ppc64.rpm
  • mysql-test-5.0.77-4.el5_4.1.ppc.rpm
  • mysql-test-5.0.77-4.el5_4.1.i386.rpm
  • mysql-devel-5.0.77-4.el5_4.1.ppc.rpm
  • mysql-bench-5.0.77-4.el5_4.1.ppc.rpm
  • mysql-bench-5.0.77-4.el5_4.1.s390x.rpm
  • mysql-5.0.77-4.el5_4.1.s390.rpm
  • mysql-server-5.0.77-4.el5_4.1.i386.rpm
  • mysql-bench-5.0.77-4.el5_4.1.x86_64.rpm
  • mysql-bench-5.0.77-4.el5_4.1.ia64.rpm
  • mysql-test-5.0.77-4.el5_4.1.ia64.rpm
  • mysql-5.0.77-4.el5_4.1.s390x.rpm
  • mysql-server-5.0.77-4.el5_4.1.ia64.rpm
  • mysql-5.0.77-4.el5_4.1.src.rpm
  • mysql-devel-5.0.77-4.el5_4.1.x86_64.rpm
  • mysql-devel-5.0.77-4.el5_4.1.ia64.rpm
  • mysql-devel-5.0.77-4.el5_4.1.ppc64.rpm
  • mysql-server-5.0.77-4.el5_4.1.ppc.rpm
  • mysql-devel-5.0.77-4.el5_4.1.s390x.rpm
  • mysql-5.0.77-4.el5_4.1.ia64.rpm
  • mysql-5.0.77-4.el5_4.1.x86_64.rpm
  • mysql-test-5.0.77-4.el5_4.1.x86_64.rpm
  • mysql-5.0.77-4.el5_4.1.ppc64.rpm
  • mysql-server-5.0.77-4.el5_4.1.x86_64.rpm
  • mysql-devel-5.0.77-4.el5_4.1.s390.rpm
  • mysql-devel-5.0.77-4.el5_4.1.i386.rpm
  • mysql-server-5.0.77-4.el5_4.1.s390x.rpm

Fixes

CVEs

(none)

References

(none)

Additional information