AnsweredAssumed Answered

Alfresco recovery mode fails

Question asked by barth4096 on Aug 4, 2009
Hello,

The indexation has crashed in my alfresco system and I started a recovery.
The catalina.out shows the progress until between 30 and 40% and then the system crashes.

Alfresco version : 3.0a
Machine : Solaris



03:58:58,107 User:System INFO  [node.index.FullIndexRecoveryComponent]  10 % complete.
05:19:35,886 User:System INFO  [node.index.FullIndexRecoveryComponent]  20 % complete.
07:46:04,693 User:System INFO  [node.index.FullIndexRecoveryComponent]  30 % complete.

and just after these progression messages I have a stack trace

here it is :


14:13:37,179 User:System ERROR [orm.hibernate3.HibernateTransactionManager] Commit exception overridden by rollback exception
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not load an entity: [org.alfresco.repo.domain.hibernate.NodeStatusImpl#component[protocol,identifier,guid]{protocol=workspace, guid=ebadf5d0-d2ea-4ca4-aeab-3eae0e514e87, identifier=SpacesStore}]
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.alfresco.repo.domain.hibernate.NodeStatusImpl#component[protocol,identifier,guid]{protocol=workspace, guid=ebadf5d0-d2ea-4ca4-aeab-3eae0e514e87, identifier=SpacesStore}]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
Caused by: java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: Io exception: Connection timed out
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Cannot release connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot release connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
11:10:58,476 User:System ERROR [util.transaction.SpringAwareUserTransaction] Application exception overridden by rollback exception
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Cannot release connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot release connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)


it's the second time I run this recovery and both times it returns a time out, normally it should not be the database pool because it's already set very high.

Does someone has an idea ?

Thanks a lot in advance

Barth

Outcomes