We have two servers running alfresco community 5.0.a. Both point to the same MYSQL database and file repository and a load balancer is being used to distribute network traffic between these two servers. This configuration has been working out well for us until today when we stumbled onto this issue.
<ol>
<li>If I change the role of a user from Consumer to Contributor (as an example) for a site in one instance, the second instance is NOT reflecting this change. Below is an error from the logs. </li>
<li>If I remove a site member from the site in one instance, the second instance is NOT reflecting this either.</li>
<li>If I invite a site member to a site in one instance, the second instance DOES show the pending invite as well. </li>
</ol>
If anyone has any ideas on why this may be occurring, your input will be much appreciated. Thanks!
~ Prachi
<blockquote>
ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-21] Exception from executeScript - redirecting to status template error: 09020063 Wrapped Exception (with status template): 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
org.springframework.extensions.webscripts.WebScriptException: 09020063 Wrapped Exception (with status template): 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1126)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)
…
Caused by: org.alfresco.scripts.ScriptException: 09026336 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/site/membership/membership.put.json.js': Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:204)
at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
…
Caused by: org.alfresco.service.cmr.repository.DuplicateChildNodeNameException: Duplicate child name not allowed: f2cf018b-9145-422b-9055-882cdc05318f
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3098)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$5.execute(AbstractNodeDAOImpl.java:3068)
…
Caused by: org.springframework.dao.DuplicateKeyException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
; SQL []; Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '13895-95-3387375714-f2cf018b-9145-422b-9055-882cdc05318f' for key 'parent_node_id'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
</blockquote>
