Sonar Qube upgrade failed

[Rahul Goel]

Hi All,

While upgrading to SonarQube latest version (7.0), the database upgrade failed. Could somebody please help me to next steps. I do not want to restore from backup , is there any workaround to start the upgrade process from the step where it failed?

Below is the error from the log file 

2018.02.03 16:55:54 ERROR web[][DbMigrations] #1908 'Delete person and file measures': failure | time=2560628ms

2018.02.03 16:55:54 ERROR web[][DbMigrations] Executed DB migrations: failure | time=6467505ms

2018.02.03 16:55:54 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=6467610ms

2018.02.03 16:55:54 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 #1908 'Delete person and file measures' 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.util.Iterator.forEachRemaining(Unknown Source)

at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Unknown Source)

at java.util.stream.ReferencePipeline$Head.forEachOrdered(Unknown Source)

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:50)

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(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.IllegalStateException: Error during processing of row: [uuid=AVsbvk42kQcgMWeMUB0k]

at org.sonar.server.platform.db.migration.step.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:89)

at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:81)

at org.sonar.server.platform.db.migration.step.MassUpdate.execute(MassUpdate.java:91)

at org.sonar.server.platform.db.migration.version.v70.DeletePersonAndFileMeasures.execute(DeletePersonAndFileMeasures.java:54)

at org.sonar.server.platform.db.migration.step.DataChange.execute(DataChange.java:44)

at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75)

... 11 common frames omitted

Suppressed: java.sql.SQLException: Already closed.

at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)

at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)

at org.sonar.server.platform.db.migration.step.DataChange.execute(DataChange.java:45)

... 12 common frames omitted

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Application was streaming results when the connection failed. Consider raising value of 'net_write_timeout' on the server.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)

at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1996)

at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:374)

at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:354)

at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6309)

at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)

at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)

at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:77)

... 15 common frames omitted

Caused by: java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(Unknown Source)

at java.net.SocketInputStream.read(Unknown Source)

at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101)

at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144)

at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174)

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3008)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3519)

... 25 common frames omitted

Regards

Rahul

[Sebastien Lesaint]

Hello,

According to log, root error is "Connection reset".

Look for a network issue between SQ and the database or MySQL shutting down the network connection for some reason.

So far, nothing indicate the error is SQ related.

Cheers,

Sébastien LESAINT | SonarSource
Platform Developer

https://sonarsource.com

--
You received this message because you are subscribed to the Google Groups "SonarQube" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sonarqube+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/38ffd13a-f082-4247-89bb-b3ab15f61686%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.