3260350 - Improper query property setting could cause Solr resource issue

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+....

• SAP Commerce
• SAP Commerce Cloud V2

Solr resource issue, complex query , KBA , CEC-SCC-COM-SRC-SER , Search and Navigation , Problem