Bug 540906 – CVE-2009-4019 mysql: DoS (crash) when comparing GIS items from subquery and when handling subqueires in WHERE and assigning a SELECT result to a @variable

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 540906 - (CVE-2009-4019) CVE-2009-4019 mysql: DoS (crash) when comparing GIS items from subquery and when handling subqueires in WHERE and assigning a SELECT result to a @variable

Summary:	CVE-2009-4019 mysql: DoS (crash) when comparing GIS items from subquery and w...

Status:	CLOSED ERRATA

Aliases:	CVE-2009-4019

Product:	Security Response
Classification:	Other
Component:	vulnerability (Show other bugs)
Sub Component:
Version:	unspecified
Hardware:	All Linux

Priority	low Severity low
Target Milestone:	---
Target Release:	---
Assigned To:	Red Hat Product Security
QA Contact:
Docs Contact:

URL:	http://dev.mysql.com/doc/refman/5.0/e...
Whiteboard:	impact=low,source=internet,reported=2...
Keywords:	Security

Depends On:	541970 549327 556505 556506 833941
Blocks:
	Show dependency tree / graph

Reported:	2009-11-24 08:55 EST by Jan Lieskovsky
Modified:	2012-06-20 10:23 EDT (History)
CC List:	5 users (show)

See Also:
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2010-02-17 04:58:29 EST
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2010:0109	normal	SHIPPED_LIVE	Moderate: mysql security update	2010-02-16 11:05:33 EST

Groups: None (edit)

Description Jan Lieskovsky 2009-11-24 08:55:20 EST

Multiple denial of service flaws were found in MySQL SQL database server.
Quoting from upstream 5.0.88 release notes:

* Error handling was missing for SELECT statements containing subqueries
in the WHERE clause and that assigned a SELECT result to a user variable.
The server could crash as a result. (Bug#48291)

* If the first argument to GeomFromWKB() function was a geometry value,
the function just returned its value. However, it failed to preserve
the argument's null_value flag, which caused an unexpected NULL value
to be returned to the caller, resulting in a server crash. (Bug#47780)

References:
-----------
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-88.html
(there are more DoS issues mentioned in the release notes, 
 but this CVE was assigned to these two)

http://dev.mysql.com/doc/refman/5.1/en/news-5-1-41.html
http://bugs.mysql.com/47780
http://bugs.mysql.com/48291

Upstream patches:
-----------------
* For Bug #48291 crash with row() operator,select into @var,
  and subquery returning multiple rows:
    http://lists.mysql.com/commits/88409
    http://lists.mysql.com/commits/88741

* For Bug #47780: crash when comparing GIS items from subquery:
    http://lists.mysql.com/commits/87591
    http://lists.mysql.com/commits/88069

Comment 4 Jan Lieskovsky 2009-11-24 09:34:00 EST

These issues (both) do NOT affect the versions of the mysql-server package,
as shipped with Red Hat Enterprise Linux 3 and 4.

The "Bug #48291 crash with row() operator,select into @var,
and subquery returning multiple rows:" issue affects the version of the
mysql-server package, as shipped with Red Hat Enterprise Linux 5.

These issues affect the versions of the mysql-server package, as shipped
with Fedora releases of 10, 11, and 12.

Comment 6 Fedora Update System 2009-11-24 15:08:33 EST

mysql-5.0.88-1.fc10 has been submitted as an update for Fedora 10.
http://admin.fedoraproject.org/updates/mysql-5.0.88-1.fc10

Comment 9 Jan Lieskovsky 2009-12-02 13:22:40 EST

Mitre's CVE-2009-4019 record:
-----------------------------

mysqld in MySQL 5.0.x before 5.0.88 and 5.1.x before 5.1.41 does not
(1) properly handle errors during execution of certain SELECT
statements with subqueries, and does not (2) preserve certain
null_value flags during execution of statements that use the
GeomFromWKB function, which allows remote authenticated users to cause
a denial of service (daemon crash) via a crafted statement.

Comment 10 Fedora Update System 2009-12-11 13:23:54 EST

mysql-5.0.88-1.fc10 has been pushed to the Fedora 10 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 11 Fedora Update System 2009-12-18 01:02:46 EST

mysql-5.1.41-2.fc12 has been submitted as an update for Fedora 12.
http://admin.fedoraproject.org/updates/mysql-5.1.41-2.fc12

Comment 12 Fedora Update System 2009-12-18 01:03:02 EST

mysql-5.1.41-2.fc11 has been submitted as an update for Fedora 11.
http://admin.fedoraproject.org/updates/mysql-5.1.41-2.fc11

Comment 14 Fedora Update System 2009-12-21 23:47:59 EST

mysql-5.1.41-2.fc12 has been pushed to the Fedora 12 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 15 Fedora Update System 2009-12-21 23:53:47 EST

mysql-5.1.41-2.fc11 has been pushed to the Fedora 11 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 22 errata-xmlrpc 2010-02-16 11:05:42 EST

This issue has been addressed in following products:

  Red Hat Enterprise Linux 5

Via RHSA-2010:0109 https://rhn.redhat.com/errata/RHSA-2010-0109.html

Note You need to log in before you can comment on or make changes to this bug.