[
https://jira.nuxeo.com/browse/NXP-7863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=107766#comment-107766
]
Mathieu GREGORI commented on NXP-7863:
--------------------------------------
Est il possible de changer cette requete en :
DELETE FROM CLUSTER_INVALS inv
WHERE inv.NODEID NOT IN (SELECT DISTINCT nod.NODEID FROM CLUSTER_NODES nod)
(Celle-ci a me semble-t-il moins de chance de rester bloquée)
> 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
>
> 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
