800349 - Backfill data for 2012-10-10

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Kaiser]

Maybe due to Selena trying to backfill matviews for the last two weeks to catch up with bug 795349, we apparently didn't have today's daily jobs run correctly. Data for yesterday needs to be backfilled for us to be able to analyze crashes for this week's newly released versions.

Comment 1

[Selena Deckelmann :selenamarie :selena]

I started the backfill this morning at about 6:30am PT

Comment 2

[Robert Kaiser]

Actually, it looks like we are missing raw ADU data, and so I guess the backfill will fail:

breakpad=> SELECT max(date) FROM raw_adu;
    max     
------------
 2012-10-09
(1 row)


Daniel, has the metrics ADI data push to Socorro some problems today?

Comment 3

[Daniel Einspanjer [:dre] [:deinspanjer]]

Yes.  There were some network issues in SCL3 this morning that borked the EOD as well as preventing the error e-mails from going out so I didn't see it until I came in this morning.

The EOD is running now and the export should be finished in half an hour.

Comment 4

[Daniel Einspanjer [:dre] [:deinspanjer]]

Re-run finished.  could someone please check the Socorro DB and make sure it picks them up?

Comment 5

[Robert Kaiser]

(In reply to Daniel Einspanjer :dre [:deinspanjer] from comment #4)
> Re-run finished.  could someone please check the Socorro DB and make sure it
> picks them up?

Looks good to me, thanks!

breakpad=> SELECT max(date) FROM raw_adu;
    max     
------------
 2012-10-10
(1 row)

I pinged Selena to do the backfill for yesterday.

Comment 6

[Selena Deckelmann :selenamarie :selena]

Backfill complete. Asking IT to kick memcached.

Comment 7

[Robert Kaiser]

I've been seeing the new numbers for a while, so this has been fixed in some way, not sure if memcache has been bumped explicitly but data is there.

Comment 8

[Adrian J Fernandez [:Aj]]

:selena as requested memcached kicked.