‘rollback segment too old / too small’ during migration to 8.9.7

SonarQube Server / Community Build
,
1

We are using the community version.
I successfully updated SonarQube from version 7.8.0 to version 7.9.6 using Oracle DB 12.1.0.2.
But when I went to upgrade from version 7.9.6 to version 8.9.7 I had problems with error:

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

Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 13 with name "_SYSSMU13_3782190206$" 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:1052)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:253)
        at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1041)
        at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3381)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:740)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:696)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:410)
        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:77)
        ... 13 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01555: snapshot too old: rollback segment number 13 with name "_SYSSMU13_3782190206$" too small

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

So for testing together with the team, we performed a DB backup and inserted it into an Oracle DB 19.12.0.0. Where after the same previous upgrade scenario, it successfully upgraded to 8.9.7.

During the process from version 7.9 to 8.9 we are updating the JDBC driver from version 12.2.0.1.0
for version 18.3.0.0.0.

Are there any limitations when upgrading using Oracle DB 12.1.0.2?

2

That is a pure Oracle error, coming from the Oracle DB. I am not an Oracle administrator but it looks like this error is related to the size of the Rollback Segments.

I advise you to consult with your DBA regarding this problem.

They should be able to help you update the Oracle configuration to avoid this problem during migration.

1 Like
3

Hi Colin, thank you very much for the suggestion.

We performed a database backup and placed it in a DB Oracle 19 version and the update was successful!

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.