lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Caio Quiozini <quioz...@catho.com.br>
Subject Re: Error java.net.SocketException: Connection reset with longer Solr Query
Date Thu, 30 Apr 2009 19:28:27 GMT
Hi ANKITBHATNAGAR

have you already tried to set up the column36 as sfloat and a query like

column36:[xxx.yy OR zzz.aa OR ... ]

I think it should help to make the decrease the number of characters.


A time ago I have expected problems cause the size of the url passed to 
tomcat.




ANKITBHATNAGAR wrote:
> Hi Guys,
> I am using solr 1.3 for performing search.
>
> I am using facet search and I am getting : connection reset error when the
> Query
>
> http://localhost:9000/solr/select/?q=*%3A*&fq=indexid_s%3A628&fq=column36_s%3A%220.25%22+OR+column36_s%3A%220.35%22+OR+column36_s%3A%220.44%22+OR+column36_s%3A%220.64%22+OR+column36_s%3A%220.37%22+OR+column36_s%3A%220.45%22+OR+column36_s%3A%220.76%22+OR+column36_s%3A%220.65%22+OR+column36_s%3A%220.71%22+OR+column36_s%3A%221.05%22+OR+column36_s%3A%220.88%22+OR+column36_s%3A%220.82%22+OR+column36_s%3A%220.78%22+OR+column36_s%3A%220.77%22+OR+column36_s%3A%220.85%22+OR+column36_s%3A%221.04%22+OR+column36_s%3A%221%22+OR+column36_s%3A%220.95%22+OR+column36_s%3A%221.48%22+OR+column36_s%3A%221.47%22+OR+column36_s%3A%221.45%22+OR+column36_s%3A%221.43%22+OR+column36_s%3A%221.37%22+OR+column36_s%3A%221.28%22+OR+column36_s%3A%221.23%22+OR+column36_s%3A%221.14%22+OR+column36_s%3A%221.1%22+OR+column36_s%3A%221.13%22+OR+column36_s%3A%221.08%22+OR+column36_s%3A%221.15%22+OR+column36_s%3A%221.19%22+OR+column36_s%3A%221.4%22+OR+column36_s%3A%221.35%22+OR+column36_s%3A%221.3%22+OR+column36_s%3A%221.44%22+OR+column36_s%3A%221.46%22+OR+column36_s%3A%221.5%22+OR+column36_s%3A%221.75%22+OR+column36_s%3A%221.74%22+OR+column36_s%3A%221.72%22+OR+column36_s%3A%221.7%22+OR+column36_s%3A%221.69%22+OR+column36_s%3A%221.67%22+OR+column36_s%3A%221.64%22+OR+column36_s%3A%221.57%22+OR+column36_s%3A%221.63%22+OR+column36_s%3A%221.6%22+OR+column36_s%3A%221.52%22+OR+column36_s%3A%221.65%22+OR+column36_s%3A%221.91%22+OR+column36_s%3A%221.9%22+OR+column36_s%3A%221.84%22+OR+column36_s%3A%221.83%22+OR+column36_s%3A%221.82%22+OR+column36_s%3A%221.8%22+OR+column36_s%3A%221.77%22+OR+column36_s%3A%221.76%22+OR+column36_s%3A%221.85%22+OR+column36_s%3A%221.89%22+OR+column36_s%3A%2210.14%22+OR+column36_s%3A%2210.12%22+OR+column36_s%3A%2210.11%22+OR+column36_s%3A%2210.09%22+OR+column36_s%3A%2210.06%22+OR+column36_s%3A%2210.05%22+OR+column36_s%3A%2210.04%22+OR+column36_s%3A%2210.01%22+OR+column36_s%3A%2210%22+OR+column36_s%3A%221.95%22+OR+column36_s%3A%221.92%22+OR+column36_s%3A%221.93%22+OR+column36_s%3A%221.97%22+OR+column36_s%3A%221.96%22+OR+column36_s%3A%221.99%22+OR+column36_s%3A%221.98%22+OR+column36_s%3A%2210.16%22+OR+column36_s%3A%2210.15%22+OR+column36_s%3A%2210.1%22+OR+column36_s%3A%2210.4%22+OR+column36_s%3A%2210.39%22+OR+column36_s%3A%2210.35%22+OR+column36_s%3A%2210.28%22+OR+column36_s%3A%2210.27%22+OR+column36_s%3A%2210.26%22+OR+column36_s%3A%2210.25%22+OR+column36_s%3A%2210.24%22+OR+column36_s%3A%2210.2%22+OR+column36_s%3A%2210.21%22+OR+column36_s%3A%2210.29%22+OR+column36_s%3A%2210.33%22+OR+column36_s%3A%2210.37%22+OR+column36_s%3A%2210.3%22+OR+column36_s%3A%2210.48%22+OR+column36_s%3A%2210.45%22+OR+column36_s%3A%2210.43%22+OR+column36_s%3A%2210.44%22+OR+column36_s%3A%2210.47%22+OR+column36_s%3A%2210.7%22+OR+column36_s%3A%2210.67%22+OR+column36_s%3A%2210.64%22+OR+column36_s%3A%2210.62%22+OR+column36_s%3A%2210.6%22+OR+column36_s%3A%2210.59%22+OR+column36_s%3A%2210.58%22+OR+column36_s%3A%2210.56%22+OR+column36_s%3A%2210.55%22+OR+column36_s%3A%2210.5%22+OR+column36_s%3A%2210.49%22+OR+column36_s%3A%2210.57%22+OR+column36_s%3A%2210.66%22+OR+column36_s%3A%2210.69%22+OR+column36_s%3A%22100.13%22+OR+column36_s%3A%22100.1%22+OR+column36_s%3A%2210.95%22+OR+column36_s%3A%2210.92%22+OR+column36_s%3A%2210.88%22+OR+column36_s%3A%2210.87%22+OR+column36_s%3A%2210.8%22+OR+column36_s%3A%2210.75%22+OR+column36_s%3A%2210.74%22+OR+column36_s%3A%2210.73%22+OR+column36_s%3A%2210.82%22+OR+column36_s%3A%2210.84%22+OR+column36_s%3A%2210.83%22+OR+column36_s%3A%2210.9%22+OR+column36_s%3A%2210.94%22+OR+column36_s%3A%2210.93%22+OR+column36_s%3A%2210.99%22+OR+column36_s%3A%2210.98%22+OR+column36_s%3A%22103.59%22+OR+column36_s%3A%22103.31%22+OR+column36_s%3A%22102.97%22+OR+column36_s%3A%22102.58%22+OR+column36_s%3A%22101.88%22+OR+column36_s%3A%22101.49%22+OR+column36_s%3A%22102.18%22+OR+column36_s%3A%22100.15%22+OR+column36_s%3A%22103.27%22+OR+column36_s%3A%22108.45%22+OR+column36_s%3A%22108%22+OR+column36_s%3A%22107.83%22+OR+column36_s%3A%22107.58%22+OR+column36_s%3A%22107.33%22+OR+column36_s%3A%22106.23%22+OR+column36_s%3A%22105.75%22+OR+column36_s%3A%22105.27%22+OR+column36_s%3A%22104.88%22+OR+column36_s%3A%22104.67%22+OR+column36_s%3A%22104.12%22+OR+column36_s%3A%22103.9%22+OR+column36_s%3A%22108.92%22+OR+column36_s%3A%22108.57%22+OR+column36_s%3A%2211.12%22+OR+column36_s%3A%2211.11%22+OR+column36_s%3A%2211.1%22+OR+column36_s%3A%2211.09%22+OR+column36_s%3A%2211.07%22+OR+column36_s%3A%2211.05%22+OR+column36_s%3A%2211.04%22+OR+column36_s%3A%2211.01%22+OR+column36_s%3A%2211.08%22+OR+column36_s%3A%2211%22+OR+column36_s%3A%2211.24%22+OR+column36_s%3A%2211.22%22+OR+column36_s%3A%2211.219%22+OR+column36_s%3A%2211.21%22+OR+column36_s%3A%2211.2%22+OR+column36_s%3A%2211.18%22+OR+column36_s%3A%2211.17%22+OR+column36_s%3A%2211.14%22+OR+column36_s%3A%2211.15%22+OR+column36_s%3A%2211.41%22+OR+column36_s%3A%2211.4%22+OR+column36_s%3A%2211.37%22+OR+column36_s%3A%2211.34%22+OR+column36_s%3A%2211.33%22+OR+column36_s%3A%2211.31%22+OR+column36_s%3A%2211.3%22+OR+column36_s%3A%2211.29%22+OR+column36_s%3A%2211.28%22+OR+column36_s%3A%2211.25%22+OR+column36_s%3A%2211.35%22+OR+column36_s%3A%2211.51%22+OR+column36_s%3A%2211.5%22+OR+column36_s%3A%2211.49%22+OR+column36_s%3A%2211.48%22+OR+column36_s%3A%2211.47%22+OR+column36_s%3A%2211.46%22+OR+column36_s%3A%2211.44%22+OR+column36_s%3A%2211.43%22+OR+column36_s%3A%2211.42%22+OR+column36_s%3A%2211.7%22+OR+column36_s%3A%2211.69%22+OR+column36_s%3A%2211.67%22+OR+column36_s%3A%2211.65%22+OR+column36_s%3A%2211.64%22+OR+column36_s%3A%2211.6%22+OR+column36_s%3A%2211.55%22+OR+column36_s%3A%2211.52%22+OR+column36_s%3A%2211.56%22+OR+column36_s%3A%2211.93%22+OR+column36_s%3A%2211.9%22+OR+column36_s%3A%2211.89%22+OR+column36_s%3A%2211.88%22+OR+column36_s%3A%2211.84%22+OR+column36_s%3A%2211.83%22+OR+column36_s%3A%2211.81%22+OR+column36_s%3A%2211.76%22+OR+column36_s%3A%2211.75%22+OR+column36_s%3A%2211.74%22+OR+column36_s%3A%2211.85%22+OR+column36_s%3A%2211.73%22+OR+column36_s%3A%22112%22+OR+column36_s%3A%22110.5%22+OR+column36_s%3A%22110.17%22+OR+column36_s%3A%22110%22+OR+column36_s%3A%2211.97%22+OR+column36_s%3A%2211.95%22+OR+column36_s%3A%2211.94%22+OR+column36_s%3A%2211.99%22+OR+column36_s%3A%22114.22%22+OR+column36_s%3A%22114.17%22+OR+column36_s%3A%22113.95%22+OR+column36_s%3A%22113.85%22+OR+column36_s%3A%22113.5%22+OR+column36_s%3A%22110.94%22+OR+column36_s%3A%22118%22+OR+column36_s%3A%22117.16%22+OR+column36_s%3A%22116.47%22+OR+column36_s%3A%22116%22+OR+column36_s%3A%22115.87%22+OR+column36_s%3A%22115.86%22+OR+column36_s%3A%22115.75%22+OR+column36_s%3A%22115.44%22+OR+column36_s%3A%22114.72%22+OR+column36_s%3A%22115.95%22+OR+column36_s%3A%22116.23%22+OR+column36_s%3A%22119.7%22+OR+column36_s%3A%22118.82%22+OR+column36_s%3A%2212.2%22+OR+column36_s%3A%2212.19%22+OR+column36_s%3A%2212.17%22+OR+column36_s%3A%2212.12%22+OR+column36_s%3A%2212.11%22+OR+column36_s%3A%2212.1%22+OR+column36_s%3A%2212.08%22+OR+column36_s%3A%2212%22+OR+column36_s%3A%2212.02%22+OR+column36_s%3A%2212.14%22+OR+column36_s%3A%2212.18%22+OR+column36_s%3A%2212.21%22+OR+column36_s%3A%2212.22%22+OR+column36_s%3A%2212.25%22+OR+column36_s%3A%2212.28%22+OR+column36_s%3A%2212.36%22+OR+column36_s%3A%2212.35%22+OR+column36_s%3A%2212.33%22+OR+column36_s%3A%2212.32%22+OR+column36_s%3A%2212.3%22+OR+column36_s%3A%2212.29%22&start=0&rows=25&sort=column35_s+asc&facet=true&facet.mincount=1&facet.limit=25&facet.field=column35_s&facet.field=column36_s&facet.field=column37_s&facet.field=column49_s&facet.field=column39_s&facet.field=column38_s&facet.field=column34_s&facet.field=column31_s&facet.field=column58_s&facet.field=column2_s&facet.field=column3_s&facet.field=column4_s&facet.field=column1_s&facet.field=column30_s&facet.field=column24_s&facet.field=column22_s&facet.field=column5_s&facet.field=column12_s&facet.field=column11_s&facet.field=column13_s&facet.field=column41_s&facet.field=column47_s&facet.field=column7_s&facet.field=column21_s&facet.field=column42_s&facet.field=column43_s&facet.field=column54_s&facet.field=column56_s&facet.field=column51_s&facet.field=column33_s&facet.field=column23_s&facet.field=column57_s&facet.field=column32_s&facet.field=column15_s&facet.field=column50_s&facet.field=column8_s&facet.field=column10_s&facet.field=column9_s&facet.field=column14_s&facet.field=column25_s&facet.field=column20_s&facet.field=column16_s&facet.field=column17_s&facet.field=column19_s&facet.field=column18_s&facet.field=column55_s&facet.field=column40_s&facet.field=column44_s&facet.field=column46_s&facet.field=column45_s&facet.field=column52_s&facet.field=column26_s&facet.field=column27_s&facet.field=column29_s&facet.field=column28_s&facet.field=column48_s&facet.field=column6_s&facet.field=column53_s
>
>
> ie 8765 characters.
>
> However if I shorten the Query it works fine.......
>
> The logs below are from Tomcat.
> There were no Solr logs .
> Please help 
>
> org.apache.solr.client.solrj.SolrServerException: Error executing query
> 	at
> org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:90)
> 	at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:122)
> 	at
> com.vantage.reportingmodule.service.search.SolrSearchClient.querySolrForJson(SolrSearchClient.java:132)
> 	at
> com.vantage.reportingmodule.web.search.SearchController.handleRequestInternal(SearchController.java:77)
> 	at
> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
> 	at
> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
> 	at
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
> 	at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
> 	at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
> 	at
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at
> org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
> 	at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at
> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:39)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:359)
> 	at
> com.vantage.bedrock.web.auth.BedrockSharedKeyFilter.doFilterHttp(BedrockSharedKeyFilter.java:61)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
> 	at
> org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:271)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.ui.preauth.AbstractPreAuthenticatedProcessingFilter.doFilterHttp(AbstractPreAuthenticatedProcessingFilter.java:60)
> 	at
> com.vantage.bedrock.web.auth.BedrockPreAuthenticatedProcessingFilter.doFilterHttp(BedrockPreAuthenticatedProcessingFilter.java:63)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> 	at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> 	at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371)
> 	at
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:174)
> 	at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> 	at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at
> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
> 	at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 	at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> 	at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> 	at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> 	at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> 	at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> 	at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> 	at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
> 	at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> 	at java.lang.Thread.run(Unknown Source)
> Caused by: org.apache.solr.client.solrj.SolrServerException:
> java.net.SocketException: Connection reset
> 	at
> org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:359)
> 	at
> org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:155)
> 	at
> org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:84)
> 	... 68 more
> Caused by: java.net.SocketException: Connection reset
> 	at java.net.SocketInputStream.read(Unknown Source)
> 	at java.io.BufferedInputStream.fill(Unknown Source)
> 	at java.io.BufferedInputStream.read(Unknown Source)
> 	at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
> 	at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
> 	at
> org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
> 	at
> org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
> 	at
> org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
> 	at
> org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
> 	at
> org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
> 	at
> org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
> 	at
> org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
> 	at
> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
> 	at
> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
> 	at
> org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:303)
> 	... 70 more
>   
best regards

Caio Quiozini
Catho Online - www.catho.com.br

-- 




Mime
View raw message