topic acl_id is null in alf_node in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/acl-id-is-null-in-alf-node/m-p/295455#M248585 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I am working on alfresco 4.0.e data.&nbsp; When doing a full lucene reindex I get some NPEs in Lucene, it gets to 10% and then nothing happens.&nbsp; CPU use drops to very low levels, alfresco doesn't start.&nbsp; </SPAN><BR /><BR /><SPAN>After some trawling, I found this (</SPAN><A href="http://forums.alfresco.com/comment/67704#comment-67704" rel="nofollow noopener noreferrer">http://forums.alfresco.com/comment/67704#comment-67704</A><SPAN>) and thought I'd give it a try.&nbsp; So I removed all entries in alf_node with acl_id null.&nbsp; That required removing entries from alf_child_assoc where parent_node_id and child_node_id were in the set of alf_node entries with null acl_id.</SPAN><BR /><BR /><SPAN>An alfresco restart now still shows the Lucene NPEs but it continues to 100%.&nbsp; I don't see the "Orphan child node has been re-homed under lost_found" log entries (as I'd expect to see in post 4.0 due to: </SPAN><A href="https://issues.alfresco.com/jira/browse/MNT-6023" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/MNT-6023</A><SPAN>).</SPAN><BR /><BR /><SPAN>Was this a sane thing to do? </SPAN><BR /><BR /><SPAN>Thanks for any insight into how sane/insane this "solution" is. </SPAN><BR /><BR /><SPAN>Gerald</SPAN></BODY></HTML> Tue, 08 Oct 2013 10:53:38 GMT bopolissimus 2013-10-08T10:53:38Z acl_id is null in alf_node https://connect.hyland.com/t5/alfresco-archive/acl-id-is-null-in-alf-node/m-p/295455#M248585 Hi all,I am working on alfresco 4.0.e data.&nbsp; When doing a full lucene reindex I get some NPEs in Lucene, it gets to 10% and then nothing happens.&nbsp; CPU use drops to very low levels, alfresco doesn't start.&nbsp; After some trawling, I found this (http://forums.alfresco.com/comment/67704#comment-67704) and Tue, 08 Oct 2013 10:53:38 GMT https://connect.hyland.com/t5/alfresco-archive/acl-id-is-null-in-alf-node/m-p/295455#M248585 bopolissimus 2013-10-08T10:53:38Z Re: acl_id is null in alf_node https://connect.hyland.com/t5/alfresco-archive/acl-id-is-null-in-alf-node/m-p/295456#M248586 <HTML><HEAD></HEAD><BODY><SPAN>It turns out this solves my reindexing issue. Only 2 entries needed to be removed from alf_child_assoc.&nbsp; A further upgrade to 4.2.d showed 2 orphan nodes moved to lost_found (likely the same nodes I removed from alf_child_assoc).&nbsp; And alfresco started in 4.0.e and also in 4.2.d.</SPAN><BR /><BR /><SPAN>I do have backups (working on a copy), so I can easily roll back if something I try fails.</SPAN></BODY></HTML> Tue, 08 Oct 2013 13:00:10 GMT https://connect.hyland.com/t5/alfresco-archive/acl-id-is-null-in-alf-node/m-p/295456#M248586 bopolissimus 2013-10-08T13:00:10Z