Oracle acl optimization constraint violation on concurrency
-----------------------------------------------------------
Key: NXP-7210
URL: https://jira.nuxeo.com/browse/NXP-7210
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.4.2
Environment: oracle database
Reporter: Benoit Delbosc
Fix For: 5.4.3
On high concurrency the read acl update can raise a primary key violation on
the hierarchy_read_acl table:
{noformat}
ERROR [nuxeo-error-log] javax.servlet.ServletException: #{action.getLink()}:
javax.el.ELException: org.nuxeo.cm.exception.CaseManagementRuntimeException:
org.nuxeo.ecm.core.api.ClientException:
org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.api.ClientException. message: Failed to save session
...
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Failed to update read acls
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.updateReadAcls(JDBCMapper.java:797)
...
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
java.sql.SQLIntegrityConstraintViolationException. message: ORA-000
01: unique constraint (CMF.SYS_C007639) violated
ORA-06512: at "CMF.NX_UPDATE_READ_ACLS", line 8
ORA-06512: at line 1
{noformat}
--
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
