topic Re: People Finder - java high CPU in Alfresco Archive 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 mrogers 2012-06-28T23:37:30Z 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