Internal server error when performing a search in SUSE Manager: "SearchServerIndexException: Search server index out of sync with database"

This document (7019986) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 3

Situation

When making a search for packages in the web UI, an error is displayed: "Internal server error".
Further investigation in the /var/log/tomcat/catalina*.log logs shows the following (extract):

2017-05-29 15:57:50,111 [ajp-apr-127.0.0.1-8009-exec-2] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.frontend.xmlrpc.SearchServerIndexException
2017-05-29 15:57:50,134 [ajp-apr-127.0.0.1-8009-exec-2] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: com.redhat.rhn.frontend.xmlrpc.SearchServerIndexException: Search server index out of sync with database.

Resolution

As root, the following command should be run:
rhn-search cleanindex

In addition, a restart of services is recommended:
spacewalk-service restart

Cause

There is a seach index corruption in the database, that can be easily fixed by simply clearing those indexes.

Additional Information

The full trace in catalina*.log can include the following messages (or similar):

2017-05-29 15:57:50,111 [xxx-yyy-127.0.0.1-8009-exec-2] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.frontend.xmlrpc.SearchServerIndexException
2017-05-29 15:57:50,134 [xxx-yyy-127.0.0.1-8009-exec-2] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: com.redhat.rhn.frontend.xmlrpc.SearchServerIndexException: Search server index out of sync with database.
       at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
       at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
       at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
       at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)
       at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
       at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
Caused by: com.redhat.rhn.frontend.xmlrpc.SearchServerIndexException: Search server index out of sync with database.
       at com.redhat.rhn.frontend.action.channel.PackageSearchHelper.performSearch(PackageSearchHelper.java:144)
       at com.redhat.rhn.frontend.action.channel.PackageSearchAction.performSearch(PackageSearchAction.java:140)
       at com.redhat.rhn.frontend.action.channel.PackageSearchAction.doExecute(PackageSearchAction.java:109)
       at com.redhat.rhn.frontend.action.BaseSearchAction.executeBody(BaseSearchAction.java:195)
       at com.redhat.rhn.frontend.action.BaseSearchAction.execute(BaseSearchAction.java:133)
       at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
       ... 48 more

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.