Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-13849

handle multi-schema during database upgrade & data migration

    XMLWordPrintable

    Details

    • Edition:
      Community
    • Production Notes:
      None

      Description

      During some database migration&upgrade, SonarQube tries to query the underlying database to find primary keys to delete.

      On Postgresql, this primary keys search query does not differentiate schema, and fails (stopping the migration and the server) if several primary keys are present on the database with the same name, even if the primary keys are on a different schema.

      Basically, our query to search for a primary key should include the schema name as criteria.

      The only workaround for users in this situation right now is to drop the other SonarQube schema.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              zipeng.wu Zipeng Wu
              Reporter:
              pierre.guillot Pierre Guillot
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: