Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.7
    • Fix Version/s: 6.7.1, 7.0
    • Component/s: Database
    • Labels:
      None

      Description

      SonarQube 6.7 fails with Postgres 10. Error comes from JDBC driver:

      ### Error updating database.  Cause: org.postgresql.util.PSQLException: Returning autogenerated keys is only supported for 8.2 and later servers.
      

      The solution is to upgrade the driver to 42.1.4 or greater.
      As a workaround for SonarQube 6.7 LTS users, the content of directory lib/jdbc/postgresql must be replaced with https://jdbc.postgresql.org/download/postgresql-42.1.4.jar

      Thanks to @mirabilos for the feedback: https://twitter.com/mirabilos/status/928666582531768320

        Attachments

          Activity

            People

            • Assignee:
              simon.brandhof Simon Brandhof
              Reporter:
              simon.brandhof Simon Brandhof
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: