[
https://jira.nuxeo.com/browse/NXP-7863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=105865#comment-105865
]
Mathieu GREGORI commented on NXP-7863:
--------------------------------------
Que penses tu de cette requête ? => Pas de lecture sur la table qu'on delete ...
DELETE FROM CLUSTER_INVALS
WHERE NODEID NOT IN (SELECT NODEID FROM CLUSTER_NODES)
NB: la requête initiale bloque même s'il n'y a qu'un des membres du cluster de
demarré.
> 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
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
