Page MenuHomePhabricator

Weekly Bugzilla Report: "Created reports per product" lists random products, not those with highest numbers
Closed, ResolvedPublic

Description

Whenever you think that you've fixed that damn script, you suddenly realize there's something else that's still wrong.

Testing the fix for bug 49758, looking at its results:

Created reports per component:
VisualEditor General 33
MediaWiki extensions UniversalLanguageSelector 27
VisualEditor Editing Tools 25
VisualEditor MediaWiki integration 12
Wikimedia Bugzilla 11

Created reports per product:
MediaWiki 43
Wikimedia 45
MediaWiki extensions 104
Security 3
Tools 5

it is clear that the "product" list does not list those products with the highest number of new tickets in the last week.

This can be also seen on
https://bugzilla.wikimedia.org/report.cgi?x_axis_field=&y_axis_field=product&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&longdesc_type=allwordssubstr&longdesc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_id=&bug_id_type=anyexact&votes=&votes_type=greaterthaneq&emailtype1=substring&email1=&emailtype2=substring&email2=&emailtype3=substring&email3=&chfield=[Bug+creation]&chfieldvalue=&chfieldfrom=-7d&chfieldto=Now&j_top=AND&f1=noop&o1=noop&v1=&format=table&action=wrap

which right now lists these top 5 products:

MediaWiki extensions 104
VisualEditor 95
MediaWiki 48
Wikimedia 47
Parsoid 23


Version: wmf-deployment
Severity: normal

Details

Reference
bz49845

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:09 AM
bzimport set Reference to bz49845.

Looking back at the very first revision of operations/puppet/templates/misc/bugzilla_report.php it already says:

getBugsPerProduct() uses
SELECT name, count(*) FROM bugs
but
getBugsPerComponent() uses
SELECT name, count(*) as total FROM bugs

That's the only difference I can spot in the query designs.

Related URL: https://gerrit.wikimedia.org/r/69629 (Gerrit Change Iecdc7439463f58be272cf0b73f662ac91d0b061b)

Shizzle, /me blind. "ORDER BY foo DESC" is teh win!