[ https://jira.nuxeo.com/browse/NXP-7863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thierry Martins updated NXP-7863: --------------------------------- Tags: 542-hf15 541-hf14 > 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 > Priority: Critical > Fix For: 5.5 > > > 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