[ 
https://jira.nuxeo.com/browse/NXCM-313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=88899#action_88899
 ] 

Benoit Delbosc commented on NXCM-313:
-------------------------------------

According to the pg logs
Process 8761 waits for AccessShareLock on relation 300653; 
  SELECT true WHERE EXISTS (SELECT 1 FROM read_acls_cache WHERE users_md5 =  $1 
)"
  -> want to update read_acls_cache
  blocked by process 8769.  
 
Process 8769 waits for ShareLock on transaction 2837313; 
  SELECT nx_update_read_acls()
  -> commit transaction avec ShareLock sur read_acls_cache
  blocked by process 8783

Process 8783 waits for AccessExclusiveLock on relation 300653; 
  SELECT nx_update_read_acls()
  -> want to truncate read_acls_cache
  blocked by process 8761.

This is a new kind of conflict during nx_udpate_read_acls and it will be fixed 
with NXP-6038.

> DB deadlock when running load test
> ----------------------------------
>
>                 Key: NXCM-313
>                 URL: https://jira.nuxeo.com/browse/NXCM-313
>             Project: Nuxeo Case Management
>          Issue Type: Bug
>          Components: performance-cmf
>    Affects Versions: 1.5
>            Reporter: Alexandre Russel
>         Attachments: server.log
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
https://jira.nuxeo.com/secure/Administrators.jspa
-
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

Reply via email to