'rollback segment too old / too small' during migration to 7.9.1

SonarQube Server / Community Build
,
1

I wanted to update from 6.7.7 to version 7.9.1 with an Oracle DB 12.2.0.1.0
After about two hours, migration on task 2504 ‘Delete useless module and folder level measures’ is aborted with the error:

Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15_1656150397 $" too small

After a restart from the service, the migration was continued at task 2504. But he is with the same task after about 20 minutes down with the same error.
Is there any new knowledge?

2019.10.22 19:44:45 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 45459 components processed (19 items/sec)
2019.10.22 19:45:36 ERROR web[][DbMigrations] #2504 'Delete useless module and folder level measures': failure | time=1430727ms
2019.10.22 19:45:36 ERROR web[][DbMigrations] Executed DB migrations: failure | time=1430728ms                                 
2019.10.22 19:45:36 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=1430905ms                        
2019.10.22 19:45:36 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 #2504 'Delete useless module and folder level 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.base/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.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: Error during processing of row: [uuid=AWwHRUFSQAZYZkhdOEQ6]
        at org.sonar.server.platform.db.migration.step.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:90)
        at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:82)
        at org.sonar.server.platform.db.migration.step.MassUpdate.execute(MassUpdate.java:92)
        at org.sonar.server.platform.db.migration.version.v76.DeleteModuleAndFolderMeasures.execute(DeleteModuleAndFolderMeasures.java:52)
        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
Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15_1656150397$" too small

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
        at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1023)
        at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3353)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:736)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:692)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:406)
        at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160)
        at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160)
        at org.sonar.server.platform.db.migration.step.SelectImpl.scroll(SelectImpl.java:78)
        ... 13 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15_1656150397$" too small

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
        ... 27 common frames omitted
2

Hi,

Welcome to the community!

This seems to be on the Oracle side. Searching the error message got me this:

ORA-01555 relates to insufficient rollback segments or undo_retentions parameter values that are not large enough. The modified data by performed commits and rollbacks causes rollback data to be overwritten when the rollback segments are smaller in size and number of the changes being performed at the time.

To resolve this issue, either increase the parameter of UNDO_RETENTION if you are in AUM mode or use larger rollback segments. The latter solution will allow your rollback data for completed transactions to be kept longer.

 
Ann