[
https://jira.nuxeo.com/browse/NXP-7863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=105814#comment-105814
]
Benoit Delbosc commented on NXP-7863:
-------------------------------------
A sample workaround if possible is to truncate cluster_* table when the last
node is shutdown.
The cluster_* tables should be truncated at some point to prevent them from
bloat.
> 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
