741817 - databases missing from webdev1.db.scl3.mozilla.com

Status: RESOLVED FIXED

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

Description

[Wil Clouser [:clouserw]]

The database dumps appear to be missing from webdev1.db.scl3.mozilla.com

[root@webdev1 backup-drop]# du -sh /data/backup-drop/
308K	/data/backup-drop/
[root@webdev1 backup-drop]# ls -l /data/backup-drop/addons/mysql/addons_mozilla_org/
total 0

Comment 1

[Wil Clouser [:clouserw]]

Can you confirm that we're at least getting backups, even if they aren't available on that box?

Comment 2

[Sheeri Cabral [:sheeri]]

Sorry, things have been a bit nuts with the data center moves to prepare for last week and this week, and this week I'm mostly AFK at the MySQL Conference & Expo. I will get to this tomorrow if I can, maybe mpressman can beat me to it?

Comment 3

[Wil Clouser [:clouserw]]

it's not the end of the world if they aren't available to me tomorrow.  I'm about to drop 19 old tables from the AMO db and I just wanted to make sure we had a backup in case everything went pear shaped.

Comment 4

[Sheeri Cabral [:sheeri]]

wil

Comment 5

[Sheeri Cabral [:sheeri]]

Wil - this was a netflow that needed to be opened, it works now:
[root@webdev1 builder_addons_mozilla_org]# ls -l /data/backup-drop/addons/mysql/addons_mozilla_org/
total 9930268
-rwx------ 1 root root 5074288536 Apr 26 13:33 addons_mozilla_org.2012.04.26.sql.gz
-rwx------ 1 root root 5080406414 Apr 27 09:22 addons_mozilla_org.2012.04.27.sql.gz
-rw-r--r-- 1 root root    3947643 Apr 27 02:00 update_counts.2012.04.27.sql.gz
[root@webdev1 builder_addons_mozilla_org]# ls -l /data/backup-drop/addons/mysql/builder_addons_mozilla_org/
total 262812
-rwx------ 1 root root 134093096 Apr 26 13:33 builder_addons_mozilla_org.2012.04.26.sql.gz
-rwx------ 1 root root 134750204 Apr 27 09:22 builder_addons_mozilla_org.2012.04.27.sql.gz