REDHAT-BUG-640861
First published: Wed Oct 06 2010(Updated: )
A flaw in MySQL versions prior to 5.1.51 [1] was reported [2] that could allow an authenticated user to cause the MySQL server to enter an infinite loop by creating a query with nested JOINs when used from stored procedures and prepared statements. [1] <a href="http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html">http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html</a> [2] <a href="http://bugs.mysql.com/bug.php?id=53544">http://bugs.mysql.com/bug.php?id=53544</a> This affects MySQL 5.x, but MySQL 4.x and early do not have support for stored procedures. This causes CPU consumption around 95-100%, however connections and queries to the database can continue. Killing the query itself is ineffective, and even a 'service mysqld restart' will fail unless the mysqld process that is handling the query is forcibly killed.
| Affected Software | Affected Version | How to fix |
|---|---|---|
| MySQL (MySQL-common) | <5.1.51 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html
- http://bugs.mysql.com/bug.php?id=53544
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=53544
- http://article.gmane.org/gmane.comp.security.oss.general/3627
- https://bugzilla.redhat.com/show_bug.cgi/attachment.cgi?id=453628&action=diff
- https://bugzilla.redhat.com/show_bug.cgi/attachment.cgi?id=453628&action=edit
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=645647
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=645651
- https://rhn.redhat.com/errata/RHSA-2010-0825.html
- https://rhn.redhat.com/errata/RHSA-2011-0164.html
- https://bugzilla.redhat.com/show_bug.cgi?id=640861
Frequently Asked Questions
What versions of MySQL are affected by REDHAT-BUG-640861?
MySQL versions prior to 5.1.51 are affected by REDHAT-BUG-640861.
What type of issue is identified in REDHAT-BUG-640861?
REDHAT-BUG-640861 identifies a flaw that can cause the MySQL server to enter an infinite loop.
What actions can an authenticated user take related to REDHAT-BUG-640861?
An authenticated user can create a query with nested JOINs in stored procedures and prepared statements to trigger the issue.
How can I address the vulnerability outlined in REDHAT-BUG-640861?
To address REDHAT-BUG-640861, you should upgrade to MySQL version 5.1.51 or later.
What are the potential consequences of exploiting the vulnerability in REDHAT-BUG-640861?
Exploiting REDHAT-BUG-640861 can lead to service disruptions due to the server entering an infinite loop.
- agent/last-modified-date
- agent/type
- agent/first-publish-date
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2010-3839
- agent/references
- agent/severity
- agent/description
- agent/event
- agent/trending
- agent/source
- agent/softwarecombine
- agent/tags
- agent/guess-ai
- agent/software-canonical-lookup
- agent/software-canonical-lookup-request
- vendor/mysql
- canonical/mysql (mysql-common)