Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-6624

Increase nuxeo.vcs.optimizations.acl.maxsize to 8192

    XMLWordPrintable

    Details

      Description

      we've reached the limits of the READ ACLS on Studio for the IRM organisation. There have ~ 100 different users and if I read correctly the logs, it provokes this error

      ERROR [catalina-exec-9] [com.nuxeo.connect.listeners.StudioProjectSyncListener] Error while synchronizing Studio projects
      org.nuxeo.ecm.core.api.NuxeoException: Failed to update read acls
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.updateReadAcls(JDBCMapper.java:1207) ~[nuxeo-core-storage-sql-10.10-HF51.jar:?]
      ...
      Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4096)
        Where: PL/pgSQL function nx_get_read_acl(character varying) line 26 at assignment
      SQL statement "UPDATE hierarchy_read_acl SET acl_id = md5(nx_get_read_acl(id)) WHERE acl_id IS NULL"
      PL/pgSQL function nx_update_read_acls() line 44 at SQL statement
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5]
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5]
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5]
      

      Increasing nuxeo.vcs.optimizations.acl.maxsize should work around this problem and gives us some weeks before the problem happens again when IRM will reach 200 users.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty