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

Automatic repair of MySQL and MSSQL collation must be included to db upgrade

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.6
    • Component/s: Database
    • Labels:

      Description

      The automatic repair of collation has been introduced in 5.5 (see SONAR-7549). It is executed during server startup, even if there are no database upgrades.
      This is risky as it alters database structure without notifying administrators. Db is potentially not backup-ed at that time. For this reason repair should be executed during db upgrades, when administrators submit the upgrade form.

      Sum-up:

      • fresh install fails fast if
        • charsets of Oracle, Postgres or MySQL are not UTF8
        • collation of at least one MySQL column is case-insensitive
        • collation of at least one MSSQL column is CI (case-insensitive) or AI (accent-insensitive)
      • db upgrade
        • fails if a Postgres column has been created with non-UTF8 charset
        • repairs incorrect collations of MySQL and MSSQL columns
      • a standard startup (no fresh install, no db upgrade) fails if
        • collation of at least one MySQL column is case-insensitive
        • collation of at least one MSSQL column is CI (case-insensitive) or AI (accent-insensitive)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: