CVE-2021-32839

Publication date 20 September 2021

Last updated 24 July 2024

Ubuntu priority

Cvss 3 Severity Score

sqlparse is a non-validating SQL parser module for Python. In sqlparse versions 0.4.0 and 0.4.1 there is a regular Expression Denial of Service in sqlparse vulnerability. The regular expression may cause exponential backtracking on strings containing many repetitions of '\r\n' in SQL comments. Only the formatting feature that removes comments from SQL statements is affected by this regular expression. As a workaround don't use the sqlformat.format function with keyword strip_comments=True or the --strip-comments command line flag when using the sqlformat command line tool. The issues has been fixed in sqlparse 0.4.2.

Read the notes from the security team

Status

Show unmaintained releases

Package	Ubuntu Release	Status
sqlparse	22.04 LTS jammy	Fixed 0.4.1-1ubuntu1
	21.10 impish	Fixed 0.4.1-1ubuntu1
	21.04 hirsute	Fixed 0.4.1-1ubuntu0.1
	20.04 LTS focal	Not affected
	18.04 LTS bionic	Not affected
	16.04 LTS xenial	Not affected
	14.04 LTS trusty	Not in release

Notes

mdeslaur

introduced in 0.4.0 by: https://github.com/andialbrecht/sqlparse/commit/1499cffcd7c4d635b4297b44d48fb4fe94cf988e

Patch details

For informational purposes only. We recommend not to cherry-pick updates. How can I get the fixes?

Package	Patch details
sqlparse	Upstream: 8238a9e

Severity score breakdown

Parameter	Value
Base score	7.5 · High
Attack vector	Network
Attack complexity	Low
Privileges required	None
User interaction	None
Scope	Unchanged
Confidentiality	None
Integrity impact	None
Availability impact	High
Vector	CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

References

Related Ubuntu Security Notices (USN)

USN-5085-1
SQL parse vulnerability
22 September 2021