[
https://jira.nuxeo.org/browse/NXP-6004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=84871#action_84871
]
Benoit Delbosc commented on NXP-6004:
-------------------------------------
Note that when reaching the limit the following error is raised:
Exception: org.postgresql.util.PSQLException. message: ERROR: value too long
for type character varying(4096) Where: PL/pgSQL function "nx_get_read_acl"
line 15 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 47 at SQL statement
> Canonicalize read acl to by pass 4k db limits
> ---------------------------------------------
>
> Key: NXP-6004
> URL: https://jira.nuxeo.org/browse/NXP-6004
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Core SQL Storage, Security / Rights
> Affects Versions: 5.4
> Reporter: Benoit Delbosc
>
> The read ACL optimization store all possible read ACL in a table (read_acls)
> if many folders
> above a document have long ACLs we can reach the field limit (4096).
> The read acls can be canonicalize or truncate for instance everything after
> the first -Everyone is useless.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/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
