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

Fail to fix MSSQL collation if Kana (KS) or Width (WS) sensitive

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.6
    • Fix Version/s: 5.6.1, 6.0
    • Component/s: Database
    • Labels:

      Description

      Case-insensitive collation is automatically converted to case-sensitive when upgrading to version 5.6. The problem is that it crashes if the collation is Kana-sensitive (KS) or Width-sensitive (WS) (see Microsoft documentation).

      2016.06.20 15:34:45 INFO  web[o.s.d.c.MssqlCharsetHandler] Changing collation of column [issue_changes.user_login] from Latin1_General_100_CI_AS_KS_WS to Latin1_General_100_CI_AS_CS_AS | sql=
      2016.06.20 15:34:45 INFO  web[o.s.s.d.m.PlatformDatabaseMigration] DB migration failed | time=1177743ms
      2016.06.20 15:34:45 ERROR web[o.s.s.d.m.PlatformDatabaseMigration] DB Migration or container restart failed. Process ended with an exception
      java.lang.IllegalStateException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid collation 'Latin1_General_100_CI_AS_CS_AS'.
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sebastien.lesaint Sebastien Lesaint
                Reporter:
                simon.brandhof Simon Brandhof
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: