SAP Knowledge Base Article - Preview

3260350 - Improper query property setting could cause Solr resource issue

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

SAP Commerce Cloud all versions ; SAP Commerce all versions

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.