CVE-2021-32839

Published: 20 September 2021

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.

Priority

Medium

CVSS 3 base score: 7.5

Status

Package Release Status
sqlparse
Launchpad, Ubuntu, Debian
Upstream
Released (0.4.2)
Ubuntu 21.10 (Impish Indri)
Released (0.4.1-1ubuntu1)
Ubuntu 21.04 (Hirsute Hippo)
Released (0.4.1-1ubuntu0.1)
Ubuntu 20.04 LTS (Focal Fossa) Not vulnerable
(0.2.4-3)
Ubuntu 18.04 LTS (Bionic Beaver) Not vulnerable
(0.2.4-0.1)
Ubuntu 16.04 ESM (Xenial Xerus) Not vulnerable

Ubuntu 14.04 ESM (Trusty Tahr) Does not exist

Patches:
Upstream: https://github.com/andialbrecht/sqlparse/commit/8238a9e450ed1524e40cb3a8b0b3c00606903aeb

Notes

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

References