-
Type:
Suggestion
-
Resolution: Fixed
-
Component/s: Environment - Database
Problem Definition
Jira 8.18.x has PostgresSQL driver version 42.2.16. This version has a bug that breaks support for PostgreSQL instances in Microsoft Azure due to broken gssEncMode.
Example of errors from logs:
< 2021-06-21 14:17:41.854 MSK > FATAL: unsupported frontend protocol 1234.5680: server supports 2.0 to 3.0 < 2021-06-21 14:17:41.863 MSK > FATAL: unsupported frontend protocol 1234.5680: server supports 2.0 to 3.0 < 2021-06-21 14:17:41.870 MSK > FATAL: unsupported frontend protocol 1234.5680: server supports 2.0 to 3.0
Suggested Solution
Upgrade bundled PostgresSQL JDBC driver to 42.2.23+ version
Notes
- This was reported to PostgreSQL at Fallback for gssEncMode connection mode is not working as expected · Issue #1868 · pgjdbc/pgjdbc · GitHub
- Driver 42.2.18 includes a fix for this bug
- fix: properly set cancel socket timeout
- related problem in Confluence
CONFSERVER-60515
Workaround
Upgrade driver manually
- is cloned from
-
- Closed
- is related to
-
CONFSERVER-60515 Connections to Azure PostgreSQL fail due to org.postgresql.util.PSQLException: The connection attempt failed
-
- Closed
-
- was cloned as
-
- Closed
- is cloned by
-
HL-2118 Loading...