801965 - Backfill adu, crashes data for stability report

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[[:jberkus] Josh Berkus]

In order for the new function and views created for bug 768059 to be useful, we'll need to do some backfilling of data in crashes_by_user and product_adu.  The reason we need to backfill is that currently those views are limited to "current" products, and the new spec is "products released in the last 2 years".  

Note that crashes_by_user was always supposed to have old release data, the fact that it doesn't is a bug.

Steps:

1. Decide how far to backfill ( 2 weeks?  4 weeks?  Back to the Mobeta release?)

2. Write a backfill script to call backfill_adu and backfill_crashes_by_user for the range of dates (preferably not all in on txn).

3. Schedule backfill for after 24.0 is pushed.

4. Run backfill.

Selena, if you want me to do the above I can, but I thought since you're back, I should kick this back to you.

Comment 1

[Selena Deckelmann :selenamarie :selena]

Closing as this is ancient.