- 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.
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/.