478772 - Crash report is shown twice when doing a search on Socorro

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Henrik Skupin [:whimboo][⌚️UTC+1]]

+++ This bug was initially created as a clone of Bug #478706 +++

Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090215 Shiretoko/3.1b3pre Ubiquity/0.1.5 ID:20090215020429

While creating the bug for the following crash I noticed that it appears twice in Socorro. If that happens for all crashes we get completely wrong crash statistics.

Crash report: bp-15d49b7d-8864-4597-930a-08a152090215

Here the search which results two crashes with the same crash id:
http://crash-stats.mozilla.com/report/list?product=Firefox&branch=1.9.1&version=Firefox%3A3.1b3pre&query_search=signature&query_type=exact&query=_destroyJSDObject&date=&range_value=1&range_unit=weeks&do_query=1&signature=_destroyJSDObject

Comment 1

[K Lars Lohn [:lars] [:klohn]]

I see this in duplication happening in my test database, too.  I'm looking into it.

Comment 2

[K Lars Lohn [:lars] [:klohn]]

This problem was resolved for new crashes submitted after the second week of March.  It was the result of a missing NULL constraint in the database after repartitioning.  It affected only a handful of crashes.  I did not go back to correct the existing duplicated records because of the time required to do so and the small number records involved.  

If the duplicated records continue to be a problem, reopen this bug.