848947 - Backfill missing Socorro aggregation data for 2013-03-06

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Robert Kaiser]

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

Aggregation data on Socorro prod for the 6th is missing, so we need to backfill that data for any crash analysis work to be done on it.

I suspect that ADU data was late the second day in a row. :(

Comment 1

[Sheeri Cabral [:sheeri]]

Um, so the title is wrong here and should be 2013-03-06, then?

Comment 2

[Robert Kaiser]

(In reply to Sheeri Cabral [:sheeri] from comment #1)
> Um, so the title is wrong here and should be 2013-03-06, then?

Er, yes

Comment 3

[Sheeri Cabral [:sheeri]]

Backfill started.

Comment 4

[Laura Thomson :laura]

Sheeri: did this complete?

Comment 5

[Selena Deckelmann :selenamarie :selena]

(In reply to Laura Thomson :laura from comment #4)
> Sheeri: did this complete?

I checked this morning and it looks as though it did.

2013-03-08 01:36:49.580 GMT,"postgres","breakpad",12677,"[local]",51393076.3185,73,"SELECT",2013-03-08 00:27:34 GMT,6/0,0,LOG,00000,"duration: 4147607.627 ms  statement: select backfill_matviews('2013-03-06','2013-03-06');",,,,,,,,,"psql"

Comment 6

[Sheeri Cabral [:sheeri]]

My apologies, I mentioned it in IRC since KaiRo seemed to want to work on it (and I was only online coincidentally because something else paged me). Yes, it did finish.