Bug 1040540

Summary: WebUI package search doesn't show all packages which match the query
Product: [Community] Spacewalk Reporter: Milan Zázrivec <mzazrivec>
Component: ServerAssignee: Milan Zázrivec <mzazrivec>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: high    
Version: 2.1CC: cperry, kabbott, mmello, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: spacewalk-java-2.1.95.1 spacewalk-search-2.1.8.1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 738055 Environment:
Last Closed: 2014-03-04 13:07:10 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1069560    

Description Milan Zázrivec 2013-12-11 15:29:31 UTC
+++ This bug was initially created as a clone of Bug #738055 +++

Description of problem:

Package search, when done from webui works according to the following worlflow:

1. Query string is passed from webui to the search server, which then
returns its own list of search results, trimmed down to the value
of configuration option "max_hits_returned" (500 by default). These results
contain list of full NEVRA strings.

2. Spacewalk (the tomcat part of the application) does some further database
queries for the results returned. Then it removes EVRA parts from the search
results and displays only unique package names in webui.

It may happen, that Spacewalk will not display all matching packages
in the search webui in cases when the mathing packages would not make the cut
performed in step 1.

It is possible to increase the "max_hits_returned" config value to something
larger, but currently, when the value is larger than 1000, you will get
the following Oracle error:

    ORA-01795: maximum number of expressions in a list is 1000


Version-Release number of selected component (if applicable):
Spacewalk 2.0

How reproducible:
Always

Steps to reproduce:
1. Spacewalk, lots of channels / packages imported
2. Perform package search in webui

Actual results:
Webui package search may not always return all matches.

Expected results:
Webui package search should return all package matches.

Comment 1 Milan Zázrivec 2013-12-11 15:52:18 UTC
spacewalk.git master: 8ba08460cebddaf5dfe889e2cbccdf0e5d1e0da7

Comment 2 Matej Kollar 2014-01-17 12:16:00 UTC
Switching MODIFIED Spacewalk bugs to ON_QA before 2.1 release.

Comment 3 Matej Kollar 2014-03-04 13:07:10 UTC
Spacewalk 2.1 has been released.
https://fedorahosted.org/spacewalk/wiki/ReleaseNotes21

Comment 4 Matej Kollar 2014-03-04 13:08:44 UTC
Spacewalk 2.1 has been released.
https://fedorahosted.org/spacewalk/wiki/ReleaseNotes21