Closed
Bug 1160907
Opened 11 years ago
Closed 11 years ago
reprocess all beta crashes since bug 1000160 landed
Categories
(Socorro :: Backend, task)
Socorro
Backend
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.
| Assignee | ||
Comment 1•11 years ago
|
||
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
| Assignee | ||
Comment 2•11 years ago
|
||
(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
| Assignee | ||
Comment 3•11 years ago
|
||
(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.
| Assignee | ||
Updated•11 years ago
|
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.
Description
•