confluence will not start

Error message below:

 

Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs) - org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [72000]; error code [1555]; ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old ; nested exception is java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old 

1 answer

0 votes
Ann Worley Atlassian Team Aug 22, 2017

I understand Confluence will not start and there is an error: 

ORA-01555: snapshot too old

Please see the resolution on this knowledgebase article:

Confluence Fails with ORA-01555 Error

I look forward to hearing how it goes.

Hi Ann Worley,

Even we are not able to access the confluence & facing the same issue.

History:

we experienced a loss of our VM server that host our Confluence instance. We have restarted the server and confluence service.

We restarted the DB server with no issue but the confluence application it self is not starting properly below is the error we are getting.

You cannot access Confluence at present. Look at the table below to identify the reasons.

Type         Description                                         Exception     Level     Time
startup     Unable to start up Confluence. Fatal error during startup sequence:             fatal            2018-05-31 13:42:44
        confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)
        - org.springframework.transaction.UnexpectedRollbackException:
          Transaction rolled back because it has been marked as rollback-only

Your server id is: XXXX-XXXX-XXXX-XXXX

As per the  atlassian_confluence.log file able to find the solution link

https://confluence.atlassian.com/confkb/confluence-fails-with-ora-01555-error-300812340.html?_ga=2.172935466.802235838.1528102568-665638832.1518597719

But can we have the clear steps to resolve this issue please.

atlassian_confluence.log

2018-06-04 12:54:37,614 ERROR [Caesium-1-2] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old

2018-06-04 12:54:37,637 ERROR [Caesium-1-2] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob jobToBeExecuted failed to run
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only

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

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
    at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:792)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    at oracle.jdbc.driver.T4C8TTIClob.read(T4C8TTIClob.java:247)
    at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:3276)
    at oracle.sql.CLOB.getChars(CLOB.java:459)
    at oracle.sql.CLOB.getSubString(CLOB.java:321)
    at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:255)
    at com.atlassian.hibernate.BucketClobStringType.nullSafeGet(BucketClobStringType.java:126)
    at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:119)
    at org.hibernate.type.AbstractType.hydrate(AbstractType.java:82)
    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2775)
    at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1741)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1667)
    at org.hibernate.loader.Loader.getRow(Loader.java:1556)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:740)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:985)
    at org.hibernate.loader.Loader.doQuery(Loader.java:943)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
    at org.hibernate.loader.Loader.doList(Loader.java:2615)
    ... 53 more
2018-06-04 12:54:38,267 INFO [CrowdUsnChangedCacheRefresher:thread-2] [directory.ldap.cache.UsnChangedCacheRefresher] call found [ 53 ] remote groups in [ 745ms ]
2018-06-04 12:54:38,385 ERROR [localhost-startStop-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old

Thanksa

Sanjeev Kumar N

Ann Worley Atlassian Team Jun 06, 2018

Hi Sanjeev,

It looks like there are resolution steps on the article you linked: Confluence Fails with ORA-01555 Error. Please let me know where in the steps the process breaks down for you and what errors you are seeing when you follow the resolution. 

Thanks,

Ann

Ann,

Thanks for solution, we were able to resolve the issue.Confluence is now accessible. :)

Issues was related to DB, as per the doc DB admin were able to resolve.

Thanks

Sanjeev Kumar N

Ann Worley Atlassian Team Jun 07, 2018

I am relieved to hear you can use Confluence now! Thanks for following up on the thread. :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

158 views 3 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you