power outage messed up our confluence database and server

Question

Here is what I can narrow down to be the RCA of the issue I do not know how to fix this error. Please any help would be immensely grateful.

org.apache.velocity.exception.MethodInvocationException: Invocation of method 'isShowSignUp' in class com.atlassian.confluence.user.actions.LoginAction threw exception java.lang.RuntimeException: java.util.concurrent.ExecutionException: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl; nested exception is net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl at /login.vm[line 6, column 28]
    at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337)

caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl; nested exception is net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl
    at com.atlassian.confluence.util.ReadOnlyLicenseCalculator.handleExecutionFailure(ReadOnlyLicenseCalculator.java:93)

caused by: java.util.concurrent.ExecutionException: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl; nested exception is net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl
    at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

caused by: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl; nested exception is net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl
    at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:584)

caused by: net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 11141121, of class: com.atlassian.crowd.model.directory.DirectoryImpl
    at net.sf.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:24)

Shawn Doyle - ReleaseTEAM · Answer

Before you started 'cleaning' things up in the DB, did you back it up?

I would suggest going to back to a DB before deleting and rebuilding, if possible.

Then restarting MySQL and Confluence in that order and if it doesn't come up, start with that error message here and we might be able to help.

dmoore_urm6n3 · Answer

Thank you for the link, Nicolas. We are running Confluence 5.5.2 - Standalone distribution. This distribution comes with a built-in Tomcat 7.0.47 web server and hsql
database, which we have running through MS SQL.

Without giving further information into our environment it is pretty straight forward. I have tried to delete the index files and have it rebuild. The Journaling, INDEXQUEUEENTRIES, and cwd_directory the object 11141121 does not exist and it cannot be bypassed apparently I was going to do a backup restore but there was a problem with our backup and restoration is not an option at this time. I have to figure out how to get this website back up.

Nicolas Grossi · Answer

@dmoore Welcome! You might take a look at this documentation: https://confluence.atlassian.com/confkb/unable-to-edit-or-delete-pages-due-to-objectnotfoundexception-no-row-with-the-given-identifier-exists-973491732.html

HTH

Nicolas