topic Desktop sync (0.9.5 and 0.9.6) fails due to very large result from lucene query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/desktop-sync-0-9-5-and-0-9-6-fails-due-to-very-large-result-from/m-p/308548#M261678 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>Context:</SPAN><BR /><SPAN>&nbsp; Server Alfresco Community 4.2.c on Ubuntu Precise using lucene indexing</SPAN><BR /><SPAN>&nbsp; Desktop sync client 0.9.5 and 0.9.6 on Windows 7</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; The alfresco content is approx 21GB on disk.&nbsp; There are more than 7000 users and more than 7000 </SPAN><BR /><SPAN>&nbsp; groups, both imported from LDAP.</SPAN><BR /><BR /><SPAN>&nbsp; This alfresco instance has been upgraded from Alfresco community 3.4 to 4.2.c</SPAN><BR /><BR /><SPAN>I run desktop sync (with wireshark on the server sniffing the wire) and my wireshark filter </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; "tcp.port == 8080 and http" </SPAN><BR /><BR /><SPAN>so I only see the HTTP requests and replies (no TCP syn/ack/fin, etc).</SPAN><BR /><BR /><SPAN>Most requests to /alfresco/api succeed.&nbsp; The ones that fail are sending this query:</SPAN><BR /><BR /><SPAN>&nbsp; +ALL:"*" +@sys\:archivedDate:[2013\-08\-14T17:53:52.0649 TO 2013\-08\-14T17:53:37] </SPAN><BR /><BR /><SPAN>and they're failing with this error:</SPAN><BR /><BR /><SPAN>&nbsp; org.apache.lucene.search.BooleanQuery$TooManyClauses: maxClauseCount is set to 10000</SPAN><BR /><BR /><SPAN>(and tomcat is returning a 500 status)</SPAN><BR /><BR /><SPAN>I can see the matching exceptions in alfresco.log.</SPAN><BR /><BR /><SPAN>I've enabled debug logging of lucene FTS queries with:</SPAN><BR /><BR /><SPAN>&nbsp; log4j.logger.org.alfresco.repo.search.impl.lucene.LuceneQueryParser=debug</SPAN><BR /><BR /><SPAN>and I can see the reply going by (in the log!, not in wireshark).&nbsp; When I cut the reply out of the alfresco.log I get a file that is 127645 bytes wide.</SPAN><BR /><BR /><SPAN>Is this an issue with soap requests only?&nbsp; When I run exactly the same query in the browser (/alfresco/faces/jsp/admin/node-browser.jsp with search language lucene) I don't get an error (although I get Results (0 rows)) and the query runs in Time ms:83.</SPAN><BR /><BR /><SPAN>The corresponding exception in alfresco is:</SPAN><BR /><BR /><BR /><SPAN> org.apache.lucene.search.BooleanQuery$TooManyClauses: maxClauseCount is set to 10000</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.BooleanQuery.add(BooleanQuery.java:163)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.BooleanQuery.add(BooleanQuery.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.MultiTermQuery.rewrite(MultiTermQuery.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.WildcardQuery.rewrite(WildcardQuery.java:54)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.BooleanQuery.rewrite(BooleanQuery.java:383)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.BooleanQuery.rewrite(BooleanQuery.java:383)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.IndexSearcher.rewrite(IndexSearcher.java:162)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.Query.weight(Query.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.Hits.&lt;init&gt;(Hits.java:76)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.Searcher.search(Searcher.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.lucene.search.Searcher.search(Searcher.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.lucene.LuceneAlfrescoLuceneQueryLanguage.executeQuery(LuceneAlfrescoLuceneQueryLanguage.java:218)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:242)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:67)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:53)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:601)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.sun.proxy.$Proxy12.query(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:601)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.sun.proxy.$Proxy12.query(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.SearchQuery.execute(SearchQuery.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.SearchQuery.execute(SearchQuery.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.AbstractQuery.execute(AbstractQuery.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.AbstractQuerySession.getQueryResults(AbstractQuerySession.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryQuerySession.getNextResults(RepositoryQuerySession.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryWebService$2.execute(RepositoryWebService.java:143)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryWebService$2.execute(RepositoryWebService.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryWebService.executeQuery(RepositoryWebService.java:161)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryWebService.query(RepositoryWebService.java:189)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor470.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:601)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:722)</SPAN><BR /></BODY></HTML> Thu, 15 Aug 2013 01:28:46 GMT bopolissimus 2013-08-15T01:28:46Z Desktop sync (0.9.5 and 0.9.6) fails due to very large result from lucene query https://connect.hyland.com/t5/alfresco-archive/desktop-sync-0-9-5-and-0-9-6-fails-due-to-very-large-result-from/m-p/308548#M261678 Hi all,Context:&nbsp; Server Alfresco Community 4.2.c on Ubuntu Precise using lucene indexing&nbsp; Desktop sync client 0.9.5 and 0.9.6 on Windows 7&nbsp; &nbsp; The alfresco content is approx 21GB on disk.&nbsp; There are more than 7000 users and more than 7000 &nbsp; groups, both imported from LDAP.&nbsp; This alfresco instance has Thu, 15 Aug 2013 01:28:46 GMT https://connect.hyland.com/t5/alfresco-archive/desktop-sync-0-9-5-and-0-9-6-fails-due-to-very-large-result-from/m-p/308548#M261678 bopolissimus 2013-08-15T01:28:46Z Re: Desktop sync (0.9.5 and 0.9.6) fails due to very large result from lucene query https://connect.hyland.com/t5/alfresco-archive/desktop-sync-0-9-5-and-0-9-6-fails-due-to-very-large-result-from/m-p/308549#M261679 <HTML><HEAD></HEAD><BODY><SPAN>The issue above no longer occurs with AlfrescoSync-1.0.0.1-x86-onpremiseonly.exe (downloadable from </SPAN><A href="http://wiki.alfresco.com/wiki/Community_file_list_4.2.c" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Community_file_list_4.2.c</A><SPAN>, the desktop sync sourceforge page doesn't have this version).</SPAN><BR /><BR /><SPAN>I've stumbled across one other bug where 1.0.0.1 won't sync a favorited directory.&nbsp; I'll test more thoroughly there first though before posting another question about it.</SPAN><BR /><BR /><SPAN>Thanks to Loftux for pointing me at 1.0.0.1</SPAN></BODY></HTML> Thu, 15 Aug 2013 09:47:48 GMT https://connect.hyland.com/t5/alfresco-archive/desktop-sync-0-9-5-and-0-9-6-fails-due-to-very-large-result-from/m-p/308549#M261679 bopolissimus 2013-08-15T09:47:48Z