Symptom
Solr server suffering from CPU saturation issue, as a consequence of JVM threads unresponsiveness, the issue could also followed by heap memory suspension.
By checking the Solr log, you could notice the search query is long and expensive, long list of facet fields (e.g. over 100) in the query parameters:
...&facet.field=AAA&facet.field=BBB&facet.field=CCC&facet.field=DDD...
Similarly you may also see high amount of free text/fuzzy/wildcard/phrase search fields (e.g. over 20) defined:
(field_A:"Search\%2BTerm")^1+OR+(field_A:"Search\%2BTerm"~5)^0.4+OR+(+(field_A:Search)+AND+(field_A:Term))^0.2+OR+(+(field_A:Search*)+AND+(field_A:Term*)+)^0.1OR+(+(field_A:*Search)+AND+(field_A:*Term)+)^0.1+OR+(+(field_A:Search~0.7)+AND+(field_A:Term~0.7)+)^0.1+OR+((field_A_st:"Search\%2BTerm")^1+OR+(field_A_st:"Search\%2BTerm"~5)^0.4+OR+(+(field_A_st:Search)+AND+(field_A_st:Term)+)^0.2+)^0.5)^10+OR+(+(field_B:"Search\%2BTerm")^1+OR+(field_B:"Search\%2BTerm"~5)^0.4+OR+(+(field_B:Search)+AND+(field_B:Term))^0.2+OR+(+(field_B:Search*)+AND+(field_B:Term*)+)^0.1OR+(+(field_B:*Search)+AND+(field_B:*Term)+)^0.1+OR+(+(field_B:Search~0.7)+AND+(field_B:Term~0.7)+)^0.1+OR+((field_B_st:"Search\%2BTerm")^1+OR+(field_B_st:"Search\%2BTerm"~5)^0.4+OR+(+(field_B_st:Search)+AND+(field_B_st:Term)+)^0.2+)^0.5)^10+OR+(+(categoryfield_B_mv:"Search\%2BTerm")^1+OR+(categoryfield_B_mv:"Search\%2BTerm"~5)^0.4+OR+(+(categoryfield_B_mv:Search)+AND+(categoryfield_B_mv:Term))^0.2+OR+(+(categoryfield_B_mv:Search*)+AND+(categoryfield_B_mv:Term*)+)^0.1OR+(+(categoryfield_B_mv:*Search)+AND+(categoryfield_B_mv:*Term)+)^0.1+OR+(+(categoryfield_B_mv:Search~0.7)+AND+(categoryfield_B_mv:Term~0.7)+)^0.1+OR+((categoryfield_B_mv_st:"Search\%2BTerm")^1+OR+(categoryfield_B_mv_st:"Search\%2BTerm"~5)^0.4+OR+(+(categoryfield_B_mv_st:Search)+AND+(categoryfield_B_mv_st:Term)+)^0.2+)^0.5)^10+OR+(+(field_C:"Search\%2BTerm")^1+OR+(field_C:"Search\%2BTerm"~5)^0.4+OR+(+(field_C:Search)+AND+(field_C:Term))^0.2)^100+OR+((code_string:"Search\%2BTerm")^1+OR(+(code_string:Search)+AND+(code_string:Term))^0.2)^100+OR+(+(field_D:"Search\%2BTerm")^1+OR+(field_D:"Search\%2BTerm"~5)^0.4+OR+(+(field_D:Search)+AND+(field_D:Term))^0.2+OR+(+(field_D:Search*)+AND+(field_D:Term*)+)^0.1OR+(+(field_D:*Search)+AND+(field_D:*Term)+)^0.1+OR+(+(field_D:Search~0.7)+AND+(field_D:Term~0.7)+)^0.1+OR+((field_D_st:"Search\%2BTerm")^1+OR+....
Read more...
Environment
- SAP Commerce
- SAP Commerce Cloud V2
Product
Keywords
Solr resource issue, complex query , KBA , CEC-SCC-COM-SRC-SER , Search and Navigation , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.