Bug 1040540 - WebUI package search doesn't show all packages which match the query
Summary: WebUI package search doesn't show all packages which match the query
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 2.1
Hardware: All
OS: Linux
high
medium
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space21
TreeView+ depends on / blocked
 
Reported: 2013-12-11 15:29 UTC by Milan Zázrivec
Modified: 2014-03-04 13:08 UTC (History)
4 users (show)

Fixed In Version: spacewalk-java-2.1.95.1 spacewalk-search-2.1.8.1
Doc Type: Bug Fix
Doc Text:
Clone Of: 738055
Environment:
Last Closed: 2014-03-04 13:07:10 UTC
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.