Excessive "orange" BzAPI searches

RESOLVED FIXED

Status

Tree Management Graveyard
TBPL
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: gerv, Unassigned)

Tracking

Dependency tree / graph

Details

(Reporter)

Description

6 years ago
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
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.
it isn't OrangeFactor; we never do a query that looks like this
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.
Is "blocks:randomorange
Component: Orange Factor → Tinderboxpushlog
Product: Testing → Webtools
QA Contact: orangefactor → tinderboxpushlog
Version: unspecified → Trunk

Comment 5

5 years ago
Believe the bugscache of bug 718632 fixed this.

I've also filed bug 790571 for switching from whiteboard to a keyword, for improved performance.
Blocks: 718632
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED

Updated

5 years ago
Depends on: 799534
(Assignee)

Updated

3 years ago
Product: Webtools → Tree Management
(Assignee)

Updated

3 years ago
Product: Tree Management → Tree Management Graveyard
You need to log in before you can comment on or make changes to this bug.