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

Error when upgrading to SonarQube 5.5 on SQL Azure

    XMLWordPrintable

    Details

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

      Description

      https://groups.google.com/forum/#!topic/sonarqube/u3mvhQsHQJc

      The schema dedicated to SonarQube contains some system tables. They must not be involved in the process of charset validation. Note that standard SQLServer database does not create such system tables.

      016.05.03 13:37:01 INFO  web[o.s.d.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
      2016.05.03 13:37:01 INFO  web[o.s.d.c.MssqlCharsetHandler] Changing collation of column [database_firewall_rules.end_ip_address] from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1_CS_AS | sql=
      2016.05.03 13:37:02 ERROR web[o.a.c.c.C.[.[.[/]] Exception sending context initialized event to listener instance of class org.sonar.server.platform.PlatformServletContextListener
      java.lang.IllegalStateException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "database_firewall_rules" because it does not exist or you do not have permissions.
       at org.sonar.db.charset.DatabaseCharsetChecker.check(DatabaseCharsetChecker.java:65) ~[sonar-db-5.5.jar:na]
       at org.sonar.server.db.CheckDatabaseCharsetAtStartup.check(CheckDatabaseCharsetAtStartup.java:52) ~[sonar-server-5.5.jar:na]
       at org.sonar.server.db.CheckDatabaseCharsetAtStartup.start(CheckDatabaseCharsetAtStartup.java:42) ~[sonar-server-5.5.jar:na]
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_91]
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_91]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_91]
       at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_91]
       at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) ~[picocontainer-2.15.jar:na]
       at org.sonar.core.platform.ComponentContainer$1.start(ComponentContainer.java:320) ~[sonar-core-5.5.jar:na]
       at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.behaviors.Stored.start(Stored.java:110) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009) ~[picocontainer-2.15.jar:na]
       at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767) ~[picocontainer-2.15.jar:na]
       at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:141) ~[sonar-core-5.5.jar:na]
       at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:84) ~[sonar-server-5.5.jar:na]
       at org.sonar.server.platform.Platform.start(Platform.java:216) ~[sonar-server-5.5.jar:na]
       at org.sonar.server.platform.Platform.startLevel2Container(Platform.java:182) ~[sonar-server-5.5.jar:na]
       at org.sonar.server.platform.Platform.init(Platform.java:91) ~[sonar-server-5.5.jar:na]
       at org.sonar.server.platform.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43) ~[sonar-server-5.5.jar:na]
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812) [tomcat-embed-core-8.0.30.jar:8.0.30]
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255) [tomcat-embed-core-8.0.30.jar:8.0.30]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [tomcat-embed-core-8.0.30.jar:8.0.30]
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408) [tomcat-embed-core-8.0.30.jar:8.0.30]
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398) [tomcat-embed-core-8.0.30.jar:8.0.30]
       at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.8.0_91]
       at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_91]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_91]
       at java.lang.Thread.run(Unknown Source) [na:1.8.0_91]
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "database_firewall_rules" because it does not exist or you do not have permissions.
       at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc41.jar:na]
       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc41.jar:na]
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
       at org.sonar.db.charset.SqlExecutor.executeUpdate(SqlExecutor.java:54) ~[sonar-db-5.5.jar:na]
       at org.sonar.db.charset.MssqlCharsetHandler.repairColumnCollation(MssqlCharsetHandler.java:102) ~[sonar-db-5.5.jar:na]
       at org.sonar.db.charset.MssqlCharsetHandler.checkCollation(MssqlCharsetHandler.java:58) ~[sonar-db-5.5.jar:na]
       at org.sonar.db.charset.MssqlCharsetHandler.handle(MssqlCharsetHandler.java:44) ~[sonar-db-5.5.jar:na]
       at org.sonar.db.charset.DatabaseCharsetChecker.check(DatabaseCharsetChecker.java:61) ~[sonar-db-5.5.jar:na]
       ... 31 common frames omitted
      2016.05.03 13:37:02 ERROR web[o.a.c.c.StandardContext] One or more listeners failed to start. Full details will be found in the appropriate container log file
      2016.05.03 13:37:02 ERROR web[o.a.c.c.StandardContext] Context [] startup failed due to previous errors
      

        Attachments

          Activity

            People

            Assignee:
            simon.brandhof Simon Brandhof (Inactive)
            Reporter:
            eric.duquesnoy Eric Duquesnoy (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: