Closed Bug 859931 Opened 7 years ago Closed 6 years ago

[tracker] Mo' stage, mo' problems: issues with backfilling and crontabber

Categories

(Socorro :: Infra, task)

x86_64
Linux
task
Not set

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

References

Details

(Whiteboard: [qa-])

We've got a series of problems intersecting causing our staging environment to not be very happy.

1. stage database refresh is broken (i don't know why)
2. the UDFs for matviews are throwing errors on a temp table that *should* go away (and i don't know why)
3. crontabber gets wedged without intervention (i documented how to fix that, and it can be added to DB refresh)
4. we can't run backfills without paying attention to crontabber anymore. (this needs to be documented, or a feature added to UDFs so that they don't run over the top of one another)

Creating or adding in existing bugs affected by these issues.
Depends on: 857307
Depends on: 859959
Depends on: 855423
Depends on: 859961
Depends on: 859964
Depends on: 860090
No longer depends on: 859964
So, to recap: 

1. stage database refresh is broken (i don't know why) - :mpressman is running a database refresh -- is there a ticket associated with this? 

2. the UDFs for matviews are throwing errors on a temp table that *should* go away (and i don't know why) -- fixed in bug 860500!

3. crontabber gets wedged without intervention (i documented how to fix that, and it can be added to DB refresh) - bug 859961 is somewhat related. After a DB refresh, we need to be able to reset crontabber so it doesn't get stuck waiting for old data for a timeblock that will never appear.

bug 859964 is probably a longer-term thing so I'm going to remove it as a blocker.
Assignee: nobody → sdeckelmann
Depends on: 860552
Removing refactor from this tracker, as it is a longer-term issue.
No longer depends on: 855423
No longer depends on: 867965
All dependent bugs are fixed. Closing tracker!
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.