732433 - Excessive "orange" BzAPI searches

Status: RESOLVED FIXED

(Tree Management Graveyard :: TBPL, defect)

Description

[Gervase Markham [:gerv]]

Something to do with "orange" is doing the following BzAPI whiteboard and summary substring search on average once a minute, every minute, 24 hours a day. Is it you guys?

Feb 28 14:04:16 [INFO] https://api-dev.bugzilla.mozilla.org/latest/bug?whiteboard=orange&summary=test_fileapi_slice.html GET => https://bugzilla.mozilla.org/buglist.cgi?short_desc=test_fileapi_slice.html&status_whiteboard=orange&short_desc_type=allwordssubstr&status_whiteboard_type=allwordssubstr&columnlist=all&ctype=csv

The filename searched for in the short_desc varies. But sometimes it does basically the same query multiple times a minute. Perhaps a little caching? Or a keyword instead of a whiteboard substring search?

Gerv

Comment 1

[Phil Ringnalda (:philor)]

It's equally (or a bit more than equally) likely to be tbpl-dev, from bug 718632. That should be caching and not doing the same search over, bug we don't actually have any way of knowing whether or not it's working, bug 730677.

Comment 2

[Jonathan Griffin (:jgriffin)]

it isn't OrangeFactor; we never do a query that looks like this

Comment 3

[Arpad Borsos [:Swatinem]]

Well yes, tbpl could be the culprit. The cache i introduced in bug 718632 should help a lot, it basically means each filename is only queried once a day.
Bug 730677 is about that the importer itself doesnt seem to be prefetching anything at all.

Comment 4

[Phil Ringnalda (:philor)]

Is "blocks:randomorange

Comment 5

[Ed Morley [:emorley]]

Believe the bugscache of bug 718632 fixed this.

I've also filed bug 790571 for switching from whiteboard to a keyword, for improved performance.