Skip to content
Heist/ feed
UnratedFix available

sqlparse vulnerabilities

Type: advisorySource: OSV1 source record

It was discovered that SQL parse contained multiple algorithmic complexity flaws when parsing SQL statements with deeply nested parentheses, comments, or dollar-quoted string literals. An attacker could use this issue to cause SQL parse to consume excessive CPU resources, resulting in a denial of service.

Announced Group revision 1
Original source ↗

USN-8808-1

Primary source · Revision 1

Imported from structured advisory data. Source references identify upstream records or fields; verify affected versions and your deployed configuration.

Security context

Source reference: osv:USN-8808-1

sqlparse

Source reference: /affected/0/package/name

Affected versions
0.1.13-2ubuntu2

Source reference: /affected/0/versions

0.1.18-1

Source reference: /affected/0/versions

Fixed versions
0.1.18-1ubuntu0.1~esm1

Source reference: /affected/0/ranges

Prerequisites
Not stated in this record

sqlparse

Source reference: /affected/1/package/name

Affected versions
0.2.2-1

Source reference: /affected/1/versions

0.2.4-0.1

Source reference: /affected/1/versions

0.2.4-0.1ubuntu0.1

Source reference: /affected/1/versions

Fixed versions
0.2.4-0.1ubuntu0.1+esm1

Source reference: /affected/1/ranges

Prerequisites
Not stated in this record

sqlparse

Source reference: /affected/2/package/name

Affected versions
0.2.4-1

Source reference: /affected/2/versions

0.2.4-1build1

Source reference: /affected/2/versions

0.2.4-2

Source reference: /affected/2/versions

0.2.4-3

Source reference: /affected/2/versions

0.2.4-3ubuntu0.1

Source reference: /affected/2/versions

Fixed versions
0.2.4-3ubuntu0.1+esm1

Source reference: /affected/2/ranges

Prerequisites
Not stated in this record

sqlparse

Source reference: /affected/3/package/name

Affected versions
0.4.1-1ubuntu1

Source reference: /affected/3/versions

0.4.2-1

Source reference: /affected/3/versions

0.4.2-1ubuntu0.22.04.1

Source reference: /affected/3/versions

0.4.2-1ubuntu0.22.04.2

Source reference: /affected/3/versions

Fixed versions
0.4.2-1ubuntu0.22.04.3

Source reference: /affected/3/ranges

Prerequisites
Not stated in this record

sqlparse

Source reference: /affected/4/package/name

Affected versions
0.4.2-1ubuntu1

Source reference: /affected/4/versions

0.4.4-1

Source reference: /affected/4/versions

0.4.4-1ubuntu0.1

Source reference: /affected/4/versions

Fixed versions
0.4.4-1ubuntu0.2

Source reference: /affected/4/ranges

Prerequisites
Not stated in this record

sqlparse

Source reference: /affected/5/package/name

Affected versions
0.5.3-1

Source reference: /affected/5/versions

0.5.4-1

Source reference: /affected/5/versions

Fixed versions
0.5.4-1ubuntu0.1

Source reference: /affected/5/ranges

Prerequisites
Not stated in this record

Structured affected-version data

Original package identities and version rules from this source.

[
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.1.18-1ubuntu0.1~esm1"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=esm-infra-legacy%2Fxenial",
      "ecosystem": "Ubuntu:Pro:16.04:LTS"
    },
    "versions": [
      "0.1.13-2ubuntu2",
      "0.1.18-1"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:Pro:16.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "pypy-sqlparse",
          "binary_version": "0.1.18-1ubuntu0.1~esm1"
        },
        {
          "binary_name": "python-sqlparse",
          "binary_version": "0.1.18-1ubuntu0.1~esm1"
        },
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.1.18-1ubuntu0.1~esm1"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.1.18-1ubuntu0.1~esm1"
        }
      ],
      "availability": "Available with Ubuntu Pro with Legacy support add-on: https://ubuntu.com/pro"
    }
  },
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.2.4-0.1ubuntu0.1+esm1"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=esm-infra%2Fbionic",
      "ecosystem": "Ubuntu:Pro:18.04:LTS"
    },
    "versions": [
      "0.2.2-1",
      "0.2.4-0.1",
      "0.2.4-0.1ubuntu0.1"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-59893",
            "severity": [
              {
                "type": "CVSS_V3",
                "score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:Pro:18.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "pypy-sqlparse",
          "binary_version": "0.2.4-0.1ubuntu0.1+esm1"
        },
        {
          "binary_name": "python-sqlparse",
          "binary_version": "0.2.4-0.1ubuntu0.1+esm1"
        },
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.2.4-0.1ubuntu0.1+esm1"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.2.4-0.1ubuntu0.1+esm1"
        }
      ],
      "availability": "Available with Ubuntu Pro (Infra-only): https://ubuntu.com/pro"
    }
  },
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.2.4-3ubuntu0.1+esm1"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=esm-infra%2Ffocal",
      "ecosystem": "Ubuntu:Pro:20.04:LTS"
    },
    "versions": [
      "0.2.4-1",
      "0.2.4-1build1",
      "0.2.4-2",
      "0.2.4-3",
      "0.2.4-3ubuntu0.1"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-59893",
            "severity": [
              {
                "type": "CVSS_V3",
                "score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:Pro:20.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "pypy-sqlparse",
          "binary_version": "0.2.4-3ubuntu0.1+esm1"
        },
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.2.4-3ubuntu0.1+esm1"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.2.4-3ubuntu0.1+esm1"
        }
      ],
      "availability": "Available with Ubuntu Pro (Infra-only): https://ubuntu.com/pro"
    }
  },
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.4.2-1ubuntu0.22.04.3"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=jammy",
      "ecosystem": "Ubuntu:22.04:LTS"
    },
    "versions": [
      "0.4.1-1ubuntu1",
      "0.4.2-1",
      "0.4.2-1ubuntu0.22.04.1",
      "0.4.2-1ubuntu0.22.04.2"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-59893",
            "severity": [
              {
                "type": "CVSS_V3",
                "score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:22.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.4.2-1ubuntu0.22.04.3"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.4.2-1ubuntu0.22.04.3"
        }
      ],
      "availability": "No subscription required"
    }
  },
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.4.4-1ubuntu0.2"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=noble",
      "ecosystem": "Ubuntu:24.04:LTS"
    },
    "versions": [
      "0.4.2-1ubuntu1",
      "0.4.4-1",
      "0.4.4-1ubuntu0.1"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-59893",
            "severity": [
              {
                "type": "CVSS_V3",
                "score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:24.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.4.4-1ubuntu0.2"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.4.4-1ubuntu0.2"
        }
      ],
      "availability": "No subscription required"
    }
  },
  {
    "ranges": [
      {
        "type": "ECOSYSTEM",
        "events": [
          {
            "introduced": "0"
          },
          {
            "fixed": "0.5.4-1ubuntu0.1"
          }
        ]
      }
    ],
    "package": {
      "name": "sqlparse",
      "purl": "pkg:deb/ubuntu/sqlparse?arch=source&distro=resolute",
      "ecosystem": "Ubuntu:26.04:LTS"
    },
    "versions": [
      "0.5.3-1",
      "0.5.4-1"
    ],
    "database_specific": {
      "source": "https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8808-1.json",
      "cves_map": {
        "cves": [
          {
            "id": "CVE-2026-54284",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-59893",
            "severity": [
              {
                "type": "CVSS_V3",
                "score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          },
          {
            "id": "CVE-2026-71491",
            "severity": [
              {
                "type": "CVSS_V4",
                "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N"
              },
              {
                "type": "Ubuntu",
                "score": "medium"
              }
            ]
          }
        ],
        "ecosystem": "Ubuntu:26.04:LTS"
      }
    },
    "ecosystem_specific": {
      "binaries": [
        {
          "binary_name": "python3-sqlparse",
          "binary_version": "0.5.4-1ubuntu0.1"
        },
        {
          "binary_name": "sqlformat",
          "binary_version": "0.5.4-1ubuntu0.1"
        }
      ],
      "availability": "No subscription required"
    }
  }
]

Publisher severity

No explicit severity was provided.

Event
#5849 · Revision 1
Added to Heist Feed
Publisher date
Read the original announcement