Status

Socorro
Database
RESOLVED FIXED
6 years ago
6 years ago

People

(Reporter: jberkus, Assigned: mpressman)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
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.
(Assignee)

Comment 1

6 years ago
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'
(Assignee)

Comment 2

6 years ago
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
(Assignee)

Comment 3

6 years ago
so auto-refresh is and has been running
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → INVALID
(Reporter)

Comment 4

6 years ago
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.
(Reporter)

Updated

6 years ago
Status: RESOLVED → REOPENED
Resolution: INVALID → ---
(Reporter)

Comment 5

6 years ago
Closing per updates to mana.
Status: REOPENED → RESOLVED
Last Resolved: 6 years ago6 years ago
Resolution: --- → FIXED
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.
You need to log in before you can comment on or make changes to this bug.