topic People Finder - java high CPU in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260690#M213820 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco 4.0.d is running fine bar the fact it appear to have an issue with the people finder.</SPAN><BR /><BR /><SPAN>Whenever a person search is performed, nothing is returned. Searching appears for a while, the site is unresponsive. Java is using 100% cpu.</SPAN><BR /><BR /><SPAN>Recently, 300000 users were added during an LDAP synch although this did not complete properly and alfresco process was killed (stop does not work, believe this is an known issue on 4.0.d)</SPAN><BR /><BR /><SPAN>Any pointers on where I may begin to look?</SPAN><BR /><BR /><SPAN>TIA</SPAN></BODY></HTML> Thu, 28 Jun 2012 14:56:39 GMT idm 2012-06-28T14:56:39Z People Finder - java high CPU https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260690#M213820 Alfresco 4.0.d is running fine bar the fact it appear to have an issue with the people finder.Whenever a person search is performed, nothing is returned. Searching appears for a while, the site is unresponsive. Java is using 100% cpu.Recently, 300000 users were added during an LDAP synch although th Thu, 28 Jun 2012 14:56:39 GMT https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260690#M213820 idm 2012-06-28T14:56:39Z Re: People Finder - java high CPU https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260691#M213821 <HTML><HEAD></HEAD><BODY><SPAN>To add,</SPAN><BR /><BR /><SPAN>Searching for a first name e.g. Mark, produces the above result.</SPAN><BR /><BR /><SPAN>Searching for Mark Smith, works - finds the user(s)</SPAN></BODY></HTML> Thu, 28 Jun 2012 20:52:51 GMT https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260691#M213821 idm 2012-06-28T20:52:51Z Re: People Finder - java high CPU https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260692#M213822 <HTML><HEAD></HEAD><BODY><SPAN>One further piece of information.</SPAN><BR /><BR /><SPAN>Searching for (e.g.) "Joe " (no quotes) produces this error </SPAN><BR /><BR /><SPAN>Searching for "Joe" (no quotes) sees the high CPU</SPAN><BR /><BR /><SPAN>05280007 Wrapped Exception (with status template): 05280079 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/person/people.get.js': 05280078 Failed to execute query: Namespace: alfresco.node queryName: select_GetChildrenCannedQueryWithProps Parameter: org.alfresco.repo.node.getchildren.FilterSortNodeEntity@7a199711 Offset: 0 Limit: 2147483647</SPAN></BODY></HTML> Thu, 28 Jun 2012 20:58:10 GMT https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260692#M213822 idm 2012-06-28T20:58:10Z Re: People Finder - java high CPU https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260693#M213823 <HTML><HEAD></HEAD><BODY><SPAN>try gathering the stats on your database.</SPAN></BODY></HTML> Thu, 28 Jun 2012 23:37:30 GMT https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260693#M213823 mrogers 2012-06-28T23:37:30Z Re: People Finder - java high CPU https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260694#M213824 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">try gathering the stats on your database.</BLOCKQUOTE><BR /><PRE class="language-none line-numbers"><CODE> datid |&nbsp; datname&nbsp; | numbackends | xact_commit | xact_rollback | blks_read | blks_hit&nbsp; | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted <BR />——-+———–+————-+————-+—————+———–+———–+————–+————-+————–+————-+————-<BR />&nbsp;&nbsp;&nbsp;&nbsp; 1 | template1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR /> 11563 | template0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR /> 11564 | postgres&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 551 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 180 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9462 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 152774 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1439 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR /> 38399 | alfresco&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11 |&nbsp;&nbsp;&nbsp;&nbsp; 3004472 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6033 |&nbsp;&nbsp; 8639979 | 120273002 |&nbsp;&nbsp; 1465852557 |&nbsp;&nbsp; 158708294 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12270 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 474472 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9506<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I've compared a cold backup of the production db with a clean alfresco install and they are identical.</SPAN></BODY></HTML> Fri, 29 Jun 2012 14:50:22 GMT https://connect.hyland.com/t5/alfresco-archive/people-finder-java-high-cpu/m-p/260694#M213824 idm 2012-06-29T14:50:22Z