-
Type:
Bug
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Component/s: Connect / Account Management
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.
- Is referenced in
