From 6ddefa00046a5938536cefa7f1d75aa129dc6c3e Mon Sep 17 00:00:00 2001 From: Joe Presbrey Date: Fri, 26 Sep 2008 07:50:30 +0000 Subject: [PATCH] tweak for rerunning the daily backup script in the same night git-svn-id: svn://presbrey.mit.edu/sql@169 a142d4bd-2cfb-0310-9673-cb33a7e74f58 --- libexec/daily_afs_backups | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/libexec/daily_afs_backups b/libexec/daily_afs_backups index 08f72be..4346483 100755 --- a/libexec/daily_afs_backups +++ b/libexec/daily_afs_backups @@ -1,6 +1,6 @@ #!/usr/bin/python -import os, sys +import os, sys, time import sql.db from sql.util import new_cursor, get_dbs, db_backup_pre, db_backup_mkdir from Queue import Queue, Empty @@ -57,6 +57,10 @@ def producer(): log = sql.db.Backup.get_by(db=db) if not log: log = sql.db.Backup(db=db) + elif log.skip_date: + if time.mktime(log.skip_date.timetuple()) + 3600 > time.time(): + # never recheck a db skipped in the past hour + continue d = db_backup_pre(c, db) if d[0]: queue.put((db, d[1])) @@ -66,7 +70,7 @@ def producer(): log.skip_reason = d[1] log.skip_date = sql.db.func.now() log.save_or_update() - sql.db.session.flush() + #sql.db.session.flush() try: producer() -- 2.45.1