Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-72629

Upgrade PostgresSQL JDBC driver to 42.2.23+ version

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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

      Workaround

      Upgrade driver manually

          Form Name

            [JRASERVER-72629] Upgrade PostgresSQL JDBC driver to 42.2.23+ version

            Allan Gandelman made changes -
            Remote Link Original: This issue links to "HL-2118 (Bulldog)" [ 568303 ] New: This issue links to "HL-2118 (JIRA Server (Bulldog))" [ 568303 ]
            Eduard M made changes -
            Link New: This issue was cloned as JRASERVER-73578 [ JRASERVER-73578 ]
            Artur Gniadzik made changes -
            Fix Version/s New: 8.13.12 [ 96896 ]
            Ignat (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Artur Gniadzik made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Artur Gniadzik made changes -
            Fix Version/s New: 8.19.0 [ 95691 ]
            Andriy Yakovlev [Atlassian] made changes -
            Assignee New: Artur Gniadzik [ agniadzik ]
            Andriy Yakovlev [Atlassian] made changes -
            PM Reviewed New: 21/Jul/2021
            Status Original: Gathering Interest [ 11772 ] New: In Progress [ 3 ]
            Andriy Yakovlev [Atlassian] made changes -
            Remote Link New: This issue links to "HL-2118 (Bulldog)" [ 568303 ]
            Andriy Yakovlev [Atlassian] made changes -
            Description Original: h3. 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:
            {noformat}
            < 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
            {noformat}

            h3. Suggested Solution
            Upgrade bundled PostgresSQL JDBC driver to *42.2.23+* version

            h3. Notes
            * This was reported to PostgreSQL at [Fallback for gssEncMode connection mode is not working as expected · Issue #1868 · pgjdbc/pgjdbc · GitHub|https://github.com/pgjdbc/pgjdbc/issues/1868]
            * Driver 42.2.18 includes a fix for this bug
            * related problem in Confluence CONFSERVER-60515
             
            h3. Workaround
            Upgrade driver manually             		New: h3. 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:
            {noformat}
            < 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
            {noformat}

            h3. Suggested Solution
            Upgrade bundled PostgresSQL JDBC driver to *42.2.23+* version

            h3. Notes
            * This was reported to PostgreSQL at [Fallback for gssEncMode connection mode is not working as expected · Issue #1868 · pgjdbc/pgjdbc · GitHub|https://github.com/pgjdbc/pgjdbc/issues/1868]
            ** Driver 42.2.18 includes a fix for this bug
            * [fix: properly set cancel socket timeout|https://github.com/pgjdbc/pgjdbc/pull/2044]
            * related problem in Confluence CONFSERVER-60515
             
            h3. Workaround
            Upgrade driver manually

              agniadzik Artur Gniadzik
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: