Closed Bug 615606 Opened 14 years ago Closed 14 years ago

[input-stage] List of crons running on staging

Categories

(mozilla.org Graveyard :: Server Operations, task)

All
Other
task
Not set
blocker

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: davedash, Assigned: justdave)

Details

QA could use a list of what crons and when are running on input-stage.
Assignee: server-ops → shyam
[root@mrapp-stage02 ~]# cat /etc/cron.d/stage_updates | grep input | grep -v ^#
MAILTO="cron-input@mozilla.com"
*/5 * * * * root (cd /data/www/input.stage.mozilla.com/reporter/; ./bin/update_staging.sh) > /dev/null
*/30 * * * * apache /data/virtualenvs/input/bin/python26 /data/www/input.stage.mozilla.com/reporter/manage.py update_product_details &> /dev/null
35 * * * * apache /data/virtualenvs/input/bin/python26 /data/www/input.stage.mozilla.com/reporter/manage.py cron cluster &> /dev/null
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Thanks; as discussed, please also output the list of DB-related crons (that pull from prod and import into/populate staging's test data).
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Over to Dave for the DB crons.
Assignee: shyam → justdave
per fwenzel, moving this to blocker, we're getting flooded with emails.
Severity: critical → blocker
For future reference, if you actually want attention when you move to blocker, please also reassign to server-ops.  Nagios doesn't page about it unless it's assigned to server-ops generically.

What emails are you getting?  The database crons only mail me or server ops, they wouldn't be mailing you guys.

30 * * * * root /root/bin/import-input-db

[root@tm-stage01-master01 ~]# cat /root/bin/import-input-db 
#!/bin/bash

drop_location=/data/backup-drop/a01/mysql/input_mozilla_com
source_db=input_mozilla_com
target_db=input_stage_mozilla_com

if [ -f "$drop_location/drop-complete" ]; then
    rm -f $drop_location/drop-complete
    FILE=`ls -1rt $drop_location/$source_db*.sql.gz | tail -n 1`
    echo "Importing $FILE to $target_db..."
    echo "drop database if exists $target_db; create database $target_db default charset utf8;" | mysql
    time (gunzip -c $FILE | mysql $target_db)
fi

That's it.  have at it.
Status: REOPENED → RESOLVED
Closed: 14 years ago14 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.