Bug #19461
closed[regression] host search by organization never finishes but causes mem.leak in foreman process
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1447958
Description of problem:
Searching for hosts by organization (and optionally specifying more filters for the search) does not terminate. Rather "Passenger RackApp: /usr/share/foreman" process consumes more and more memory until OOM-killed.
This is a regression between 6.2.8 (search works fine) and 6.2.9 (search doesnt work).
Version-Release number of selected component (if applicable):
Sat 6.2.9
How reproducible:
100%
Steps to Reproduce:
1.
curl -u admin:redhat "https://$(hostname -f)/api/v2/hosts?organization_id=1&page=1&search=&sort_by=name&sort_order=ASC"
(or in WebUI, goto Hosts -> All hosts and use filter "organization = Organization_Name")
(you can try more complex query as well that shall fail the same way, like:
curl -u admin:redhat "https://$(hostname -f)/api/v2/hosts?organization_id=1&page=1&search=subscription_status+%3D+invalid&sort_by=name&sort_order=ASC"
)
2. Wait a minute
3. Monitor RSS usage of "Passenger RackApp: /usr/share/foreman" process.
Actual results:
The query never finishes.
RSS usage of the foreman process grows forever.
Expected results:
The query to finish in reasonable time.
No huge RSS increase.
Additional info:
per tbrisker, the regression is suspected due to https://bugzilla.redhat.com/show_bug.cgi?id=1419667