Red Hat Bugzilla – Bug 1295499
Attempts to update a specific search query results in infinite "Please stand by"
Last modified: 2017-02-01 06:41:02 EST
Description of problem:
Attempts to edit a specific search query results in a "Please stand by" that never ends. Infinite loop?
Version-Release number of selected component (if applicable):
Always with this one specific query. I have tried multiple edits to the same query without being able to workaround the problem.
Steps to Reproduce:
1. Use this URL, which is a relatively complex search query, which DOES finish: https://url.corp.redhat.com/42c17a4
2. EDIT SEARCH
3. Remove the first line in the query, the "blocks" criteria.
"Please stand by" forever
A list of bugs resulting from the updated search.
I tested this as instructed, and the results are as stated.
I then added:
Classification: Red Hat
Product: Red Hat Enterprise Linux 6
and reran the search, 19 bugs found in ~5 seconds.
The question now is, why doesn't the search timeout like it's supposed to?
FYI This relates to the way Postgres handles the search and isn't a code loop, the DB is taking a long time to check the "bug_id NOT IN(~1 million ID's)". Setting the product reduces the number of IDs by a factor or two and thus computes reasonably fast.
The proxy was tweaked recently and this query now correctly dies with the "Your query was taking longer than 120 seconds and had to be killed. Please back up and narrow your search criteria ..." message.
Given that taking the advice in the message gets a search result I'm going to close this. Jump on Bug 1260009 if you want to pursue improving the search generation.
Agreed, sorry should have closed the bug before. I left it open in case you wanted to improve the messaging, which it looks like you have done according to comment #3. Thanks!