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

Schema initialization error with MySQL 5.6 due to max index key length violation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.4.1
    • Fix Version/s: 3.5
    • Component/s: Database, Documentation
    • Labels:
      None
    • Environment:
      Tested on
      * Windows Server 2008 R2
      ** with MySQL 5.6.10: problem does occur
      ** with MySQL 5.5.30: problem does not occur

      Description

      Steps to reproduce:

      1. Install MySQL 5.6.10 using the Windows Installer from http://dev.mysql.com/downloads/installer/
      2. Install Sonar 3.4.1 by unpacking the zip from http://www.sonarsource.org/downloads/
      3. Create a user "sonar" on the local machine
      4. Set the user directory to the sonar directory
      5. Ensure that the user "sonar" has full access to the sonar directory
      6. Install the sonar service using InstallNTService.bat
      7. Change the sonar service to run as user "sonar"
      8. Start sonar

      Expected:
      A fresh sonar installation is accessible at localhost:9000.

      Actual:
      The browser displays an error page ("We're sorry, but something went wrong.").
      The logfile contains an error message:
      org.jruby.rack.RackInitializationException: An error has occurred, all later migrations canceled: ActiveRecord::JDBCError: Specified key was too long; max key length is 767 bytes: CREATE INDEX `properties_key` ON `properties` (`prop_key`)

      Additional information:
      When running the steps using MySQL 5.5.30 it works as expected.

      According to the documentation at http://docs.codehaus.org/display/SONAR/Requirements sonar will work with MySQL 5.x. So this is either a documentation problem or a problem with sonar.

        Attachments

          Activity

            People

            Assignee:
            simon.brandhof Simon Brandhof (Inactive)
            Reporter:
            markuskreusch Markus Kreusch
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: