628816 - Highlight duplicates in reports/list

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Laura Thomson :laura]

Where reports have:
- same datetime
- same uptime (or slightly increasing, within an hour)
- same OS
- same build
- same address
Highlight these on the reports/list page as possible duplicates.

Comment 1

[Laura Thomson :laura]

https://wiki.mozilla.org/File:Explosive_signatures.png

Comment 2

[Robert Kaiser]

Er, laura, does that mockup in comment #1 belong here or in bug 629055 instead?

Comment 3

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Pushing to 1.7.8.

Comment 4

[Laura Thomson :laura]

Pushed some other bugs out, keeping this one.

Comment 5

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Per jberkus in IRC:
The new table is reports_duplicates ( uuid, duplicate_of, date_processed )
"Leaders" are included in that table, in which case uuid == duplicate_of.

Comment 6

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

@Josh - Here is the current query.  Let me know how you want it to be updated to flag individual reports as duplicates.
http://ryansnyder.pastebin.mozilla.org/1093646

Comment 7

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Duplicates are in.

DUP field has been added as the second field in the report list page.  Will be available testing on stage at:
http://crash-stats.stage.mozilla.com/report/list?range_value=21&range_unit=days&signature=UserCallWinProcCheckWow

==

Sending        webapp-php/application/models/common.php
Sending        webapp-php/application/views/common/list_reports.php
Sending        webapp-php/js/socorro/report_list.js
Transmitting file data ...
Committed revision 2973.

Comment 8

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

The reports_duplicates is missing on stage.  Once that is available then we can begin testing.

Comment 9

[[:jberkus] Josh Berkus]

QA says they don't see any duplicates flags in the UI.  There's certainly duplicate data in the database ... most of the artificial crashes generated by testing show up as probable duplicates, as they should.

Was this UI work actually completed?

Comment 10

[Matt Brandt [:mbrandt]]

Bumping this back to resolved/fixed after a conversation in irc w/ jberkus and laura. 
QA verifed using the url in comment 7 and
https://crash-stats.stage.mozilla.com/report/list?range_value=2&range_unit=weeks&signature=mozalloc_abort%28char%20const*%20const%29%20|%20NS_DebugBreak_P%20|%20nsCycleCollectorGCHookRunnable%3A%3ARun%28%29&version=Firefox%3A4.0b12

The reports table has the new column and duplicates are properly marked.