774113 - auto-refresh not running

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[[:jberkus] Josh Berkus]

I came in today (Sunday) to run the mobeta upgrade on crash-stats-dev so that the developers could work with it during the week. As of 2pm PDT, it had not run, and AFAIK the schedule for auto-refresh is to run early in the morning.

I suspect that auto-refresh is broken or disabled.

Comment 1

[Matt Pressman [:mpressman]]

it actually runs later for the csd part - there were no logs reporting errors for the 15th or the 22nd, with the exception of an hbase error on the 22nd when running the hbase truncate 'crash_reports'

Comment 2

[Matt Pressman [:mpressman]]

as for the latest data from last weeks run:
-on CSD
breakpad:5432# select max(report_date) from tcbs;
    max     
------------
 2012-07-21
(1 row)

breakpad:5432# select max(date) from raw_adu;
    max     
------------
 2012-07-21
(1 row)

-on devdb
breakpad:4321# select max(report_date) from tcbs;
    max     
------------
 2012-07-21
(1 row)

breakpad:4321# select max(date) from raw_adu;
    max     
------------
 2012-07-21
(1 row)

-on stage
breakpad=# select max(report_date) from tcbs;
    max     
------------
 2012-07-21

breakpad=# select max(date) from raw_adu;
    max     
------------
 2012-07-23

Comment 3

[Matt Pressman [:mpressman]]

so auto-refresh is and has been running

Comment 4

[[:jberkus] Josh Berkus]

What time is "later"? 

There's no docs I've been able to find on the schedule for this (see other bug).  In the doc on mana, the original schedule was early in the morning on Sunday.   If you changed that schedule, you didn't share that information with anyone.

Once you doc that, we can close this bug.

BTW, *per the doc in mana*, you shouldn't be refreshing the devDB on 4321 as part of auto-refresh.  That's a "scratch" database and it gets refreshed manually.

Comment 5

[[:jberkus] Josh Berkus]

Closing per updates to mana.

Comment 6

[Sheeri Cabral [:sheeri]]

FWIW, the mana page is:

https://mana.mozilla.org/wiki/display/websites/Updating+Staging+and+Dev+Snapshots+of+Postgres+Database

which is mostly how to do the refresh manually, but also states "This process is similar to the automated refresh that runs every Sunday at noon pacific."

Just noting for completion's sake.