Closed Bug 1160907 Opened 11 years ago Closed 11 years ago

reprocess all beta crashes since bug 1000160 landed

Categories

(Socorro :: Backend, task)

task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: rhelmer, Assigned: rhelmer)

Details

After bug 1000160 landed and we changed the way we stored beta versions from processed crashes, there was a gap where we wrote crashes using the old version number ("38.0") and before the new matviews expecting the new version number ran ("38.0b8") This resulted in a gap in Beta crashes for April 30th. We need to reprocess all beta crashes for this period and do a backfill.
I think this will catch everything: INSERT INTO reprocessing_jobs ( SELECT uuid::uuid FROM REPORTS WHERE release_channel = 'beta' AND date_processed > '2015-04-29' AND date_processed < '2015-05-01' AND release_channel = 'beta' AND version NOT LIKE '%b' ) There are 136159 such crashes.
Status: NEW → ASSIGNED
(In reply to Robert Helmer [:rhelmer] from comment #1) > I think this will catch everything: > > INSERT INTO reprocessing_jobs ( > SELECT uuid::uuid FROM REPORTS > WHERE release_channel = 'beta' > AND date_processed > '2015-04-29' > AND date_processed < '2015-05-01' > AND release_channel = 'beta' > AND version NOT LIKE '%b' > ) > > There are 136159 such crashes. Running: INSERT 0 136159
(In reply to Robert Helmer [:rhelmer] from comment #2) > (In reply to Robert Helmer [:rhelmer] from comment #1) > > I think this will catch everything: > > > > INSERT INTO reprocessing_jobs ( > > SELECT uuid::uuid FROM REPORTS > > WHERE release_channel = 'beta' > > AND date_processed > '2015-04-29' > > AND date_processed < '2015-05-01' > > AND release_channel = 'beta' > > AND version NOT LIKE '%b' > > ) > > > > There are 136159 such crashes. > > Running: > > INSERT 0 136159 Ah, I could have done NOT LIKE '%b%' and spared reprocessing a few, there were "only" 127567 of those.
Rob, this bug can be closed, right?
Flags: needinfo?(rhelmer)
Status: ASSIGNED → RESOLVED
Closed: 11 years ago
Flags: needinfo?(rhelmer)
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.