AnsweredAssumed Answered

Reindexer failed with error

Question asked by vinhqchu on Aug 11, 2009
Hello All,

I recently moved Alfresco into a cluster environment. After I got the cluster up and running, I ran a FULL index on the second server. Everything looked fine until I saw the below errors popping up on the second server:

08:09:30,553 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer    13 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/91c93f20-ef3c-4383-ac72-de4def65c6d5.

With these errors on the second server, it seemed to cause database tables to lockup errors on server one, resulting in inaccessibility for users on both servers:

11:16:19,614 ERROR [org.alfresco.smb.protocol] Closing session due to exception
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

After shutting down server two, server one was able to function normally.

Any clues to fix my issues are greatly appreciated.

Thanks.

Outcomes