Solr free text search does not return any results

[Former Member]

Hi guys,

Free text search on storefront does not return any results or products. But autosuggestion works, also the products are available on store front but when you do a free text search "0 items found for keyword "

update: I am able to see products on categories

Using hybris 6.3 , Solr 6.1.0 java 1.8

org.apache.solr.common.SolrException: Error opening new searcher at org.apache.solr.core.SolrCore.(SolrCore.java:773) at org.apache.solr.core.SolrCore.(SolrCore.java:647) at org.apache.solr.core.CoreContainer.create(CoreContainer.java:812) at org.apache.solr.core.CoreContainer.lambda$load$0(CoreContainer.java:466) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.apache.solr.common.util.ExecutorUtil$MDCAwareThreadPoolExecutor.lambda$execute$22(ExecutorUtil.java:229) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

Caused by: org.apache.solr.common.SolrException: Error opening new searcher at org.apache.solr.core.SolrCore.openNewSearcher(SolrCore.java:1642) at org.apache.solr.core.SolrCore.getSearcher(SolrCore.java:1753) at org.apache.solr.core.SolrCore.initSearcher(SolrCore.java:860) at org.apache.solr.core.SolrCore.(SolrCore.java:746) ... 8 more

[Former Member]

Debug that flow or check your configuration.

Probably you have not defined these field ftsQuery,ftsWildQuery for any attribute like name in solr.impex.

[Former Member]

Hi Abhishek,

ftsQuery and ftsWildQuery are both true for the code,name etc that im using for the search Also something to note im using a customProduct that extended the Product

master_customProduct_flop: org.apache.solr.common.SolrException:org.apache.solr.common.SolrException: Error opening new searcher

[Former Member]

Update:

I set localized equal to false on indexed fields and the search is working properly. Basically Solr never had a problem but a configuration problem.

[Former Member]

Hi Ernie

If you are receiving an error saying 'Error opening a new searcher'. I would suggest you run a full indexing again. Also make sure your index is not corrupted. Try clicking a category and check if you see product results pertaining to that category. If you do, that means solr is returning products and your index is not corrupted.

Also see the following link
https://stackoverflow.com/questions/30747284/solr-stopped-with-error-opening-new-searcher-at-org-apa...

If you are getting results in autocomplete I see no reason why you shouldn't get results I would suggest start debugging from the controller level and see where your code differs in autocomplete versus regular search.

[ihar]

Probably solr query debugging could help (de.hybris.platform.solrfacetsearch.search.context.listeners.SolrQueryDebuggingListener)

To enable it, add bean definition

 <bean id="solrQueryDebuggingListenerDefinition" parent="solrListenerDefinition">
     <property name="priority" value="1000" />
     <property name="listener" ref="solrQueryDebuggingListener" />
 </bean>

[Former Member]

Hi Ihar thanks for the reply

I added the bean and when i run solr this is what i get on console.

[Former Member]

INFO [hybrisHTTP33] [SolrQueryDebuggingListener] Parsed Solr Query: (ean_string:locking^20.0 ean_string:locking*^10.0) (code_en_text:locking^100.0 code_en_text:locking*^50.0 code_en_text:locking~2^25.0) (ERP1_SKU_en_text:locking^200.0 ERP1_SKU_en_text:locking*^100.0 ERP1_SKU_en_text:locking~2^50.0) (name_en_text:locking^140.0 name_en_text:locking*^70.0 name_en_text:locking~2^35.0) keywords_en_text:locking*^20.0 keywords_en_text:locking~2^10.0) (categoryName_en_text_mv:locking^160.0 categoryName_en_text_mv:locking*^80.0 categoryName_en_text_mv:locking~2^40.0)

[Former Member]

INFO [hybrisHTTP33] [SolrQueryDebuggingListener] Filter Queries: [(((catalogId:"customProductCatalog") AND (catalogVersion:Online)))] INFO [hybrisHTTP33] [SolrQueryDebuggingListener] Solr Query explanation: {}

[ihar]

Hi Ernie,

My idea is to check the actual query and to try to identify the source of the problem. So you could try to run this query manually using SOLR admin panel (https://localhost:8983/solr/), check results. If there will be no results then query has been built incorrectly. Then try to analyze query, remove some fields, etc.