Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-7210

Oracle acl optimization constraint violation on concurrency

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4.2
    • Fix Version/s: 5.5
    • Component/s: Core VCS
    • Environment:
      oracle database

      Description

      On high concurrency the read acl update can raise a primary key violation on the hierarchy_read_acl table:

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bdelbosc Benoit Delbosc
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: