770220 - No SUMO database dumps transferred to dm-sumotools01.mozilla.org

Status: VERIFIED FIXED

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

Description

[[:Cww]]

This happened again :(

We haven't had database dumps since June 18th.  

I'm trying to start work on prepping for Q3 goals and Firefox 14, please fix.

Dumps of the SUMO database should be put on /data/backup-drop/sumo/mysql/support_mozilla_com/

see dependent bugs for previous times this happened.

Comment 1

[Matt Pressman [:mpressman]]

I apologize for this. It appears that the host where the old backups were running where the cron job was put out to pasture and now the new host backup1.db.phx1 doesn't have that cron job installed. Additionally, it doesn't appear that there is a port open to copy it over. I'll first copy over the data for you so you have access to the latest dump and then I'll open a bug to get the necessary access and finally will get that cron job installed on the new host.

Comment 2

[Matt Pressman [:mpressman]]

So a bug has been opened. Also, I was wrong, the cron job is indeed on the new host, but would have been failing without the opened port. So as soon as that is open, the cron job will work. I'm having to manually copy the latest dump across jump boxes, so I'll post when the latest is copied over.

Comment 3

[Matt Pressman [:mpressman]]

You now have the latest dump of sumo on dm-sumotools01.mozilla.org

Comment 4

[[:Cww]]

(In reply to Matt Pressman [:mpressman] from comment #3)
Where? I don't see it in /data/backup-drop/sumo/mysql/support_mozilla_com/

Comment 5

[Matt Pressman [:mpressman]]

whoops, I put it in /data/backups/sumo/sqldumps/ - I just moved it to
/data/backup-drop/sumo/mysql/support_mozilla_com/

Comment 6

[Matt Pressman [:mpressman]]

The cron job ran successfully now that the network port is open. I see the most recent db dump in /data/backup-drop/sumo/mysql/support_mozilla_com/

Comment 7

[[:Cww]]

Thanks! I'll check again on thursday to make sure it's going on schedule.