Closed Bug 915198 Opened 12 years ago Closed 12 years ago

Android devices are duplicated in android_devices matview

Categories

(Socorro :: Database, task, P1)

Product:
Socorro
Component:
Database
Platform:
x86
macOS
Type:
task

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: brandon, Assigned: selenamarie)

Details

(Whiteboard: [qa-][DB Changes])

As discussed yesterday, it appears that android devices are being duplicated daily in the devices table. This creates two problems for the front end: * Grouping by android_device id creates duplicates in the table. * The stored procedure for calculating values assumes uniqueness (see https://github.com/mozilla/socorro/pull/1441/files#L7R233 and https://github.com/mozilla/socorro/pull/1441/files#L7R242), overstating the totals in the report. This is a high priority issue to fix since the new report ships today; otherwise, we should pull the new report for next week.
Whiteboard: [qa-][DB Changes]
Target Milestone: --- → 59
Commits pushed to master at https://github.com/mozilla/socorro https://github.com/mozilla/socorro/commit/59d634ed1a8703ce5c21f769795e2afef39f492e Fixes bug 915198 make update_android_devices() work without dupes https://github.com/mozilla/socorro/commit/37a19cc1ef044f777eb4aa8a482c5fdfa0775436 Merge pull request #1489 from selenamarie/bug915198-fix-android-devices Fixes bug 915198 make update_android_devices() work without dupes
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.