2023.02.10 20:13:10 INFO web[][o.s.p.ProcessEntryPoint] Starting Web Server 2023.02.10 20:13:13 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.9.0.65466 / ce743843018827cb30c05735e7971523de34bb48 2023.02.10 20:13:13 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://sedn002.drc.local;instanceName=SQLEXPRESSTEST;databaseName=SonarQube;integratedSecurity=true;trustServerCertificate=true; 2023.02.10 20:13:13 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Starting... 2023.02.10 20:13:14 INFO web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection ConnectionID:1 ClientConnectionId: dea89707-2005-4a8c-afb0-cc42b05f323e 2023.02.10 20:13:14 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Start completed. 2023.02.10 20:13:18 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\SonarQube-9.9.0.65466 2023.02.10 20:13:18 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled 2023.02.10 20:13:18 INFO web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions: developer-edition, developer-scanner, developer-server, license, monitoring 2023.02.10 20:13:19 WARN web[][o.s.s.p.DatabaseServerCompatibility] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy ABAP Code Quality and Security / 3.11.0.4030 / efe73c1da897a69d2545e79710bec0909326dcdb 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy C# Code Quality and Security / 8.51.0.59060 / e14c642f118958f22fd08841dc42f9aae480366a 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy CFamily Code Quality and Security / 6.41.0.60884 / 6efcc8197e558ca2a78cada46494e8afe8c821ff 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Configuration detection fot Code Quality and Security / 1.2.0.267 / 4f37ba9ffb37a96d5883e52ad392ed32c5c6eaab 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection / 1.10.0.3046 / 0 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection Rules for Java / 1.10.0.3046 / 0 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Dataflow Bug Detection Rules for Python / 1.10.0.3046 / 0 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Flex Code Quality and Security / 2.8.0.3166 / 01f66bdddc678966c81a9064ed139156a6a89c97 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Go Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy HTML Code Quality and Security / 3.7.1.3306 / d720acc6860c6d8b69ec4d17570a398a1e216da1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy IaC Code Quality and Security / 1.11.0.2847 / 6892bd3a7320b3c110717acfdb18c4c7451069fd 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy JaCoCo / 1.3.0.1538 / 74a7798c7cea687c72ed9df40c93eb7ea2a58c49 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Java Code Quality and Security / 7.16.0.30901 / 4b1436558dfd5fc00c8d9aae8bb0364ba122c73e 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy JavaScript/TypeScript/CSS Code Quality and Security / 9.13.0.20537 / 68ff7657415044b86033814795ed95fc1f1558f1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Kotlin Code Quality and Security / 2.12.0.1956 / a6df1ae252bd62d63f8673c28f87ad14258a7904 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy PHP Code Quality and Security / 3.27.1.9352 / 3ddc5a03e1a7e3729d41e7c1a30a37d5715958c7 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy PL/SQL Code Quality and Security / 3.8.0.4948 / ab46f4c11644e5c9b17f0a5a1612d4b7362e04f3 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Python Code Quality and Security / 3.24.0.10784 / 30aa413d983f6c37b4298eba00555c3050009b52 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Ruby Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Scala Code Quality and Security / 1.11.0.3905 / e1f28bc000e04ca01881e84218d01d464a17a36f 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Swift Code Quality and Security / 4.8.0.5759 / 3d5b95aaf19a398736a7f5eec314c3c05f7193d2 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy T-SQL Code Quality and Security / 1.7.0.5449 / 110c82f888b1f40e1c2a0d3165fcffd413af36a5 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Text Code Quality and Security / 2.0.1.611 / 53bfe3a68ae3886520d6a5c1c21dfdb564821ea1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy VB.NET Code Quality and Security / 8.51.0.59060 / e14c642f118958f22fd08841dc42f9aae480366a 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Analysis / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for C# / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for JS / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for Java / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for PHP / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy Vulnerability Rules for Python / 9.9.0.19083 / 6139a53ee01a475a60f6e2944fff40f3fc00dbe1 2023.02.10 20:13:19 INFO web[][o.s.s.p.ServerPluginManager] Deploy XML Code Quality and Security / 2.7.0.3820 / 656bccc1910d50c8984536bd2dfd917066b858e6 2023.02.10 20:13:21 INFO web[][o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive 2023.02.10 20:13:22 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://127.0.0.1:9001] 2023.02.10 20:13:23 WARN web[][o.s.a.s.w.WebService$Action] Description is not set on action api/monitoring/metrics 2023.02.10 20:13:23 WARN web[][o.s.a.s.w.WebService$Action] Since is not set on action api/monitoring/metrics 2023.02.10 20:13:23 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/monitoring/metrics 2023.02.10 20:13:23 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness 2023.02.10 20:13:23 INFO web[][o.s.s.p.Platform] Database needs to be migrated. Please refer to https://docs.sonarqube.org/latest/setup/upgrading 2023.02.10 20:13:23 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@4e50ae56 [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}] 2023.02.10 20:13:23 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000 2023.02.10 20:14:30 INFO web[][o.s.s.p.d.m.DatabaseMigrationImpl] Starting DB Migration and container restart 2023.02.10 20:14:31 INFO web[][DbMigrations] Executing DB migrations... 2023.02.10 20:14:31 INFO web[][DbMigrations] #6509 'Drop column sonarlint_ad_seen in 'users''... 2023.02.10 20:14:31 ERROR web[][DbMigrations] #6509 'Drop column sonarlint_ad_seen in 'users'': failure | time=99ms 2023.02.10 20:14:31 ERROR web[][DbMigrations] Executed DB migrations: failure | time=99ms 2023.02.10 20:14:31 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=853ms 2023.02.10 20:14:31 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration ended with an exception org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #6509 'Drop column sonarlint_ad_seen in 'users'' failed at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:79) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:67) at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:422) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:52) at org.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(MigrationEngineImpl.java:66) at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doUpgradeDb(DatabaseMigrationImpl.java:105) at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doDatabaseMigration(DatabaseMigrationImpl.java:80) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.lang.IllegalStateException: Fail to execute ALTER TABLE users DROP CONSTRAINT DF__users__sonarlint__1D7B6025 at org.sonar.server.platform.db.migration.step.DdlChange$ContextImpl.execute(DdlChange.java:106) at org.sonar.server.platform.db.migration.step.DdlChange$ContextImpl.execute(DdlChange.java:86) at org.sonar.server.platform.db.migration.step.DdlChange$ContextImpl.execute(DdlChange.java:128) at org.sonar.server.platform.db.migration.step.DropColumnChange.execute(DropColumnChange.java:47) at org.sonar.server.platform.db.migration.step.DdlChange.execute(DdlChange.java:45) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75) ... 9 common frames omitted Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'DF__users__sonarlint__1D7B6025' is not a constraint. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3916) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:775) at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) at org.sonar.server.platform.db.migration.step.DdlChange$ContextImpl.execute(DdlChange.java:91) ... 14 common frames omitted