Red Hat Product Errata RHBA-2009:1693 - Bug Fix Advisory
Issued:
2009-12-23
Updated:
2009-12-23

RHBA-2009:1693 - Bug Fix Advisory

Synopsis

mysql bug fix update

Type/Severity

Bug Fix Advisory

Red Hat Insights patch analysis

Identify and remediate systems affected by this advisory.

View affected systems

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
http://kbase.redhat.com/faq/docs/DOC-11259

Affected Products

  • Red Hat Enterprise Linux Server 5 x86_64
  • Red Hat Enterprise Linux Server 5 ia64
  • Red Hat Enterprise Linux Server 5 i386
  • Red Hat Enterprise Linux for x86_64 - Extended Update Support 5.4 x86_64
  • Red Hat Enterprise Linux for x86_64 - Extended Update Support 5.4 ia64
  • Red Hat Enterprise Linux for x86_64 - Extended Update Support 5.4 i386
  • Red Hat Enterprise Linux Workstation 5 x86_64
  • Red Hat Enterprise Linux Workstation 5 i386
  • Red Hat Enterprise Linux Desktop 5 x86_64
  • Red Hat Enterprise Linux Desktop 5 i386
  • Red Hat Enterprise Linux for IBM z Systems 5 s390x
  • Red Hat Enterprise Linux for IBM z Systems - Extended Update Support 5.4 s390x
  • Red Hat Enterprise Linux for Power, big endian 5 ppc
  • Red Hat Enterprise Linux for Power, big endian - Extended Update Support 5.4 ppc
  • Red Hat Enterprise Linux Server from RHUI 5 x86_64
  • Red Hat Enterprise Linux Server from RHUI 5 i386

Fixes

  • BZ - 538731 - MySQL 5.0.77 crashes on comparison of date & datetime types to NAME_CONST()

CVEs

(none)

References

(none)

Red Hat Enterprise Linux Server 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
x86_64
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: b08ccc1d458d4a86375c2e007d566307b0389465e323d13a241e9ba63f731aeb
mysql-bench-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 8ffeda2bf4c538e12590e6fcc35c2d5e5bb535dda82139bd174f59184f14b99d
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-devel-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 030c7ba4081b94d81519826d09cab624cace5f5cf57386d4d57253c81e8b37cb
mysql-server-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 84ff9e693a53788ae6d42b689a1abd6174eb15d1340bbc58632120b82f5b2b27
mysql-test-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 5ba85c57343390a1d7d554326f6bb9868d14fc36afadcaa4d97fc1e9b63f1868
ia64
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-5.0.77-4.el5_4.1.ia64.rpm SHA-256: 11832c1967142b30c7bb8b7bdd1f081de18c4ace2d9c31b36fcc4a14da9383fb
mysql-bench-5.0.77-4.el5_4.1.ia64.rpm SHA-256: fa8c22304ba2ed461ed7f62cb86be2fee1c106cb67535574172809d37cea4a56
mysql-devel-5.0.77-4.el5_4.1.ia64.rpm SHA-256: 0b4ac1d5f8c978eaf76b72451269342ba21513b290d8b507c50b03a3c07cf554
mysql-server-5.0.77-4.el5_4.1.ia64.rpm SHA-256: 7129c62a62ffdc87f017fe278758e9d0a24417bc59671640f90632d796d33d04
mysql-test-5.0.77-4.el5_4.1.ia64.rpm SHA-256: 61d122a5b45c5df059178ab14ef93b1360ee6bd9997727de73fe3d1eccbed325
i386
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-bench-5.0.77-4.el5_4.1.i386.rpm SHA-256: cf5135c9fb0215ffb7d47a2e0c0d3dac38a59b8f45ad407bd1da7adc74e5b3e8
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-server-5.0.77-4.el5_4.1.i386.rpm SHA-256: d2399cacff5052a47559bc6fc339abd14d8585bb41d0fa6a8126fde3bc082ee7
mysql-test-5.0.77-4.el5_4.1.i386.rpm SHA-256: 04fff552fd2b1c530329e246e3370d7e4bcd831afa35426d6278e6153306a10e

Red Hat Enterprise Linux for x86_64 - Extended Update Support 5.4

SRPM
x86_64
ia64
i386

Red Hat Enterprise Linux Workstation 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
x86_64
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: b08ccc1d458d4a86375c2e007d566307b0389465e323d13a241e9ba63f731aeb
mysql-bench-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 8ffeda2bf4c538e12590e6fcc35c2d5e5bb535dda82139bd174f59184f14b99d
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-devel-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 030c7ba4081b94d81519826d09cab624cace5f5cf57386d4d57253c81e8b37cb
mysql-server-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 84ff9e693a53788ae6d42b689a1abd6174eb15d1340bbc58632120b82f5b2b27
mysql-test-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 5ba85c57343390a1d7d554326f6bb9868d14fc36afadcaa4d97fc1e9b63f1868
i386
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-bench-5.0.77-4.el5_4.1.i386.rpm SHA-256: cf5135c9fb0215ffb7d47a2e0c0d3dac38a59b8f45ad407bd1da7adc74e5b3e8
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-server-5.0.77-4.el5_4.1.i386.rpm SHA-256: d2399cacff5052a47559bc6fc339abd14d8585bb41d0fa6a8126fde3bc082ee7
mysql-test-5.0.77-4.el5_4.1.i386.rpm SHA-256: 04fff552fd2b1c530329e246e3370d7e4bcd831afa35426d6278e6153306a10e

Red Hat Enterprise Linux Desktop 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
x86_64
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: b08ccc1d458d4a86375c2e007d566307b0389465e323d13a241e9ba63f731aeb
i386
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4

Red Hat Enterprise Linux for IBM z Systems 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
s390x
mysql-5.0.77-4.el5_4.1.s390.rpm SHA-256: 7e2acf5076306ecb59f84231ba76acc89d28b4be5342886912d956c092f3134c
mysql-5.0.77-4.el5_4.1.s390x.rpm SHA-256: 8dfbaef2e940a44947f5794b4a065311335abaa989b3dc44ba54e02276c111e2
mysql-bench-5.0.77-4.el5_4.1.s390x.rpm SHA-256: dfe00c4227899098dc3da8e783a1050d9c8b3d39b401fb049cb597e631139c4e
mysql-devel-5.0.77-4.el5_4.1.s390.rpm SHA-256: 5dfb338fad0d4dabfc72b64b1660df71ac8190549775e6171ce8ff9ee1bd744d
mysql-devel-5.0.77-4.el5_4.1.s390x.rpm SHA-256: e22e56fe2a0b476d8262a3df85b99d6929d76d7465640fdab8364b470ed09153
mysql-server-5.0.77-4.el5_4.1.s390x.rpm SHA-256: 85f7bda40847bad82d2a27b61f8378896e787639c81031775da7ad9c5b5b6dcc
mysql-test-5.0.77-4.el5_4.1.s390x.rpm SHA-256: 2dd23790dd01f1ab440c0f5631dbdcf1d6748dee065822b4f635c8b17d7facd3

Red Hat Enterprise Linux for IBM z Systems - Extended Update Support 5.4

SRPM
s390x

Red Hat Enterprise Linux for Power, big endian 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
ppc
mysql-5.0.77-4.el5_4.1.ppc.rpm SHA-256: 7ed303f76d92ea9bdc3ad147faa995ecc2d16951e2b94933b0104b0e09307390
mysql-5.0.77-4.el5_4.1.ppc64.rpm SHA-256: a53e26bbfa82faefd6faca6eb5f97fbb2e7264cbea267ef50447b16046d98d47
mysql-bench-5.0.77-4.el5_4.1.ppc.rpm SHA-256: 42fd095fe3614bc09bf2e38d9fbf6c0154c704679b835c98e0531f7116bd61df
mysql-devel-5.0.77-4.el5_4.1.ppc.rpm SHA-256: 0c30b68a9e9441b00bbd8c8c6ad02a5ec9da1b5de7521e4981afe5e6d498a97f
mysql-devel-5.0.77-4.el5_4.1.ppc64.rpm SHA-256: 750f9233ac7461c3418f290e4b7f0aa10ff944b2e0be1462e1fa839eca756729
mysql-server-5.0.77-4.el5_4.1.ppc.rpm SHA-256: 8810ac7ec71f21e78976dd3855f5278c05e5aa9ae526cf3abfdac17a63e69380
mysql-server-5.0.77-4.el5_4.1.ppc64.rpm SHA-256: fab46310eb10f8c23861a3169dfdfd6517b1df7714ea46a5b651aa79b786c08b
mysql-test-5.0.77-4.el5_4.1.ppc.rpm SHA-256: 2917124773ebb1ce19cc9d1c1bdd9644f8d833b814218cd2f182fc35b1ab1887

Red Hat Enterprise Linux for Power, big endian - Extended Update Support 5.4

SRPM
ppc

Red Hat Enterprise Linux Server from RHUI 5

SRPM
mysql-5.0.77-4.el5_4.1.src.rpm SHA-256: e33aea5cabb0f1054b676ce73df0897800dc954eaabb96443e891570c9b0c093
x86_64
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: b08ccc1d458d4a86375c2e007d566307b0389465e323d13a241e9ba63f731aeb
mysql-bench-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 8ffeda2bf4c538e12590e6fcc35c2d5e5bb535dda82139bd174f59184f14b99d
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-devel-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 030c7ba4081b94d81519826d09cab624cace5f5cf57386d4d57253c81e8b37cb
mysql-server-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 84ff9e693a53788ae6d42b689a1abd6174eb15d1340bbc58632120b82f5b2b27
mysql-test-5.0.77-4.el5_4.1.x86_64.rpm SHA-256: 5ba85c57343390a1d7d554326f6bb9868d14fc36afadcaa4d97fc1e9b63f1868
i386
mysql-5.0.77-4.el5_4.1.i386.rpm SHA-256: d5a9f434495bc0c1fb2948f9e423ead15fd13bb72ae7d90e85749ee0a0c73dd4
mysql-bench-5.0.77-4.el5_4.1.i386.rpm SHA-256: cf5135c9fb0215ffb7d47a2e0c0d3dac38a59b8f45ad407bd1da7adc74e5b3e8
mysql-devel-5.0.77-4.el5_4.1.i386.rpm SHA-256: 0d24a04ee77219030ce59c784df400c5022f1864d0d89bb79cab28278910ce1b
mysql-server-5.0.77-4.el5_4.1.i386.rpm SHA-256: d2399cacff5052a47559bc6fc339abd14d8585bb41d0fa6a8126fde3bc082ee7
mysql-test-5.0.77-4.el5_4.1.i386.rpm SHA-256: 04fff552fd2b1c530329e246e3370d7e4bcd831afa35426d6278e6153306a10e

The Red Hat security contact is secalert@redhat.com. More contact details at https://access.redhat.com/security/team/contact/.