topic Solr4 and ACLs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solr4-and-acls/m-p/285560#M238690 <HTML><HEAD></HEAD><BODY><SPAN>We have an alfresco community 5.0.c environment. Previously used 3.4.d and upgraded through several versions. We created a new solr4 index from scratch after the final upgrade. </SPAN><BR /><BR /><SPAN>We currently have about 1500 sites and 200 users assigned to 15 groups. We assign groups to sites as their involvement with each site requires. </SPAN><BR /><BR /><SPAN>When adding a group to a site membership (or any ACL change for that matter) I notice that solr consistently takes a lot of resources (CPU and memory) while indexing the change for about 15mins! I can’t figure out why this is the case even when there are no documents in the site. It’s almost as though it has to re-index all the nodes that group has access to. Can anybody explain this behavior? What exactly is solr doing when notified of an ACL change like this? </SPAN><BR /><BR /><SPAN>Whilst not hindering system performance yet I am worried that as our repo grows this will become unsustainable.</SPAN><BR /><BR /><SPAN>In the alfresco core we currently have:</SPAN><BR /><SPAN>300k nodes</SPAN><BR /><SPAN>307k transactions</SPAN><BR /><SPAN>56k ACLs</SPAN><BR /><SPAN>30k ACL transactions</SPAN><BR /><BR /><SPAN>server: Centos 5.4 VM, 16G RAM, 4 cores, 4GB JVM, MySQL 5.6, Tomcat 7</SPAN><BR /><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /></BODY></HTML> Tue, 16 Jun 2015 15:09:30 GMT butterman 2015-06-16T15:09:30Z Solr4 and ACLs https://connect.hyland.com/t5/alfresco-archive/solr4-and-acls/m-p/285560#M238690 We have an alfresco community 5.0.c environment. Previously used 3.4.d and upgraded through several versions. We created a new solr4 index from scratch after the final upgrade. We currently have about 1500 sites and 200 users assigned to 15 groups. We assign groups to sites as their involvement with Tue, 16 Jun 2015 15:09:30 GMT https://connect.hyland.com/t5/alfresco-archive/solr4-and-acls/m-p/285560#M238690 butterman 2015-06-16T15:09:30Z Re: Solr4 and ACLs https://connect.hyland.com/t5/alfresco-archive/solr4-and-acls/m-p/285561#M238691 <HTML><HEAD></HEAD><BODY><SPAN>When re-indexing an acl solr4 pulls a json document from alfresco that includes a list of the nodes parent paths. In our case each of our groups could be members of over 1000 sites and therefore the group node had that many parents which were re-indexed every time a group was added or deleted from a site.</SPAN><BR /><BR /><SPAN>The fix was to stop solr indexing parent paths by adding the following two lines of code:</SPAN><BR /><SPAN>nmdp.setIncludePaths(false);</SPAN><BR /><SPAN>nmdp.setIncludeParentAssociations(false);</SPAN><BR /><SPAN>to:</SPAN><BR /><SPAN>src5.0.c\projects\solr4\source\java\org\alfresco\solr\SolrInformationServer.java at line1691.</SPAN><BR /><BR /><SPAN>Link to updated source: </SPAN><A href="https://drive.google.com/file/d/0B4zqRLvm-_xIT2Zna1lYZFZraUk/view?usp=sharing" rel="nofollow noopener noreferrer">https://drive.google.com/file/d/0B4zqRLvm-_xIT2Zna1lYZFZraUk/view?usp=sharing</A><BR /><SPAN>Link to patched jar: </SPAN><A href="https://drive.google.com/file/d/0B4zqRLvm-_xIdTd0VHpOek11NUk/view?usp=sharing" rel="nofollow noopener noreferrer">https://drive.google.com/file/d/0B4zqRLvm-_xIdTd0VHpOek11NUk/view?usp=sharing</A><BR /></BODY></HTML> Mon, 07 Sep 2015 10:01:15 GMT https://connect.hyland.com/t5/alfresco-archive/solr4-and-acls/m-p/285561#M238691 butterman 2015-09-07T10:01:15Z