DB upgrade from 6.7.6 to 7.6 fails: step 2006

upgrade
mssql

(Beel) #1

SQL Server 2016. SonarQube was working fine on version 6.7.6. After upgrading to version 7.6, the setup URL reports the upgrade failed. The web.log file contains the following entries and stack trace. Any suggestions?

2019.03.15 09:51:13 INFO  web[][o.s.s.p.d.m.DatabaseMigrationImpl] Starting DB Migration and container restart
2019.03.15 09:51:13 INFO  web[][DbMigrations] Executing DB migrations...
2019.03.15 09:51:13 INFO  web[][DbMigrations] #2006 'Clean orphans in Compute Engine child tables'...
2019.03.15 09:51:13 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 orphans rows in ce_task_input processed (0 items/sec)
2019.03.15 09:51:13 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 orphans rows in ce_scanner_context processed (0 items/sec)
2019.03.15 09:51:13 ERROR web[][DbMigrations] #2006 'Clean orphans in Compute Engine child tables': failure | time=137ms
2019.03.15 09:51:13 ERROR web[][DbMigrations] Executed DB migrations: failure | time=137ms
2019.03.15 09:51:13 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=215ms
2019.03.15 09:51:13 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 #2006 'Clean orphans in Compute Engine child tables' 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 java.lang.Iterable.forEach(Iterable.java:75)
                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:68)
                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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                at java.lang.Thread.run(Thread.java:748)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ce_task_characteristics'.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:331)
                at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
                at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
                at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:74)
                at org.sonar.server.platform.db.migration.step.MassUpdate.execute(MassUpdate.java:92)
                at org.sonar.server.platform.db.migration.version.v71.CleanCeChildTablesOrphans.deleteOrphansInCeChildTable(CleanCeChildTablesOrphans.java:48)
                at org.sonar.server.platform.db.migration.version.v71.CleanCeChildTablesOrphans.execute(CleanCeChildTablesOrphans.java:38)
                at org.sonar.server.platform.db.migration.step.DataChange.execute(DataChange.java:45)
                at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75)
                ... 9 common frames omitted

(Simon Brandhof) #2

Hi,

Could you check that the table ce_task_characteristics correctly exists in the schema? If yes, does it have a different case, for example in upper-case?

++


(Beel) #3

Thank you for your prompt response. The table exists, the name is all lower case. The table has no rows.


(Beel) #4

Well, I gave up and deleted the old tables and started anew.