CVE-2024-27289: Github.com/jackc/pgx SQL Injection Vulnerability
HIGHCVE-2024-27289 is a HIGH (CVSS 8.1) sql injection vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Github.com/jackc/pgx libraries in the Go ecosystem. The issue involves pgx sql injection via line comment creation. Remediation is available by upgrading affected packages to version 4.18.2.
CVE-2024-27289 at a Glance
Security Impact
CVSS: 8.1
The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H).
How to Fix CVE-2024-27289
To remediate this vulnerability, upgrade all affected Github.com/jackc/pgx dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
Upgrade github.com/jackc/pgx to 4.18.2Upgrade github.com/jackc/pgx/v4 to 4.18.2Run the following command in your project directory to verify that all resolved dependencies use the patched release:
inspect dependencies for github.com/jackc/pgxHow to Check if You Are Affected
To determine whether your application is affected by CVE-2024-27289, inspect your project dependencies for Github.com/jackc/pgx:
inspect dependencies for github.com/jackc/pgxAnalyze the terminal output to locate any version of Github.com/jackc/pgx in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 4.18.2), your application is affected.
Note: Verify declared build manifests and deployed runtime container environments.
Technical Details
Vulnerability Mechanism & Technical Analysis
This vulnerability is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'), where the product constructs all or part of an sql command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended sql command when it is sent to a downstream component. without sufficient removal or quoting of sql syntax in user-controllable inputs, the generated sql query can cause those inputs to be interpreted as sql instead of ordinary user data. In Github.com/jackc/pgx, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.
Source Advisory Statement
CVE-2024-27289 Affected Github.com/jackc/pgx Versions
2 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
github.com/jackc/pgx
|
Go |
< 4.18.2
|
4.18.2
|
|
github.com/jackc/pgx/v4
|
Go |
< 4.18.2
|
4.18.2
|
References
Frequently Asked Questions
What is CVE-2024-27289?
Which Github.com/jackc/pgx versions are affected?
What version fixes CVE-2024-27289?
Is github.com/jackc/pgx affected?
Is github.com/jackc/pgx/v4 affected?
What is the CVSS score of CVE-2024-27289?
What CWE is associated with CVE-2024-27289?
How can I check Go dependencies for CVE-2024-27289?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-m7wr-2xf7-cm9p",
"modified" : "2025-06-13T20:45:26Z",
"published" : "2024-03-04T20:13:11Z",
"aliases" : [ "CVE-2024-27289" ],
"summary" : "pgx SQL Injection via Line Comment Creation",
"details" : "### Impact\n\nSQL injection can occur when all of the following conditions are met:\n\n1. The non-default simple protocol is used.\n2. A placeholder for a numeric value must be immediately preceded by a minus.\n3. There must be a second placeholder for a string value after the first placeholder; both\nmust be on the same line.\n4. Both parameter values must be user-controlled.\n\ne.g. \n\nSimple mode must be enabled:\n\n```go\n// connection string includes \"prefer_simple_protocol=true\"\n// or\n// directly enabled in code\nconfig.ConnConfig.PreferSimpleProtocol = true\n```\n\nParameterized query:\n\n```sql\nSELECT * FROM example WHERE result=-$1 OR name=$2;\n```\n\nParameter values:\n\n`$1` => `-42`\n`$2` => `\"foo\\n 1 AND 1=0 UNION SELECT * FROM secrets; --\"`\n\nResulting query after preparation:\n\n```sql\nSELECT * FROM example WHERE result=--42 OR name= 'foo\n1 AND 1=0 UNION SELECT * FROM secrets; --';\n```\n\n### Patches\n\nThe problem is resolved in v4.18.2.\n\n### Workarounds\n\nDo not use the simple protocol or do not place a minus directly before a placeholder.",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H"
}, {
"type" : "CVSS_V4",
"score" : "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:P/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "4.18.2"
} ]
} ]
}, {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx/v4"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "4.18.2"
} ]
} ]
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/security/advisories/GHSA-m7wr-2xf7-cm9p"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2024-27289"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/commit/f94eb0e2f96782042c96801b5ac448f44f0a81df"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/jackc/pgx"
}, {
"type" : "WEB",
"url" : "https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-89" ],
"severity" : "HIGH",
"github_reviewed" : true,
"github_reviewed_at" : "2024-03-04T20:13:11Z",
"nvd_published_at" : "2024-03-06T19:15:08Z"
}
}