Concurrency problem on startup in PostgreSQL cluster mode
---------------------------------------------------------
Key: NXP-7863
URL: https://jira.nuxeo.com/browse/NXP-7863
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.4.2
Environment: PostgreSQL, cluster mode
Reporter: Benoit Delbosc
On startup there is a cleaning procedure to remove orphan invalidation. This
cleaning is done on each node even on instance with a noDDL repository option.
This cleaning should not be done concurrently because it hangs:
{code}
DELETE FROM CLUSTER_INVALS
USING CLUSTER_INVALS i LEFT JOIN CLUSTER_NODES n ON i.NODEID=n.NODEID
WHERE n.NODEID IS NULL
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
