diff options
| -rwxr-xr-x | bin/reproducible_scheduler.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py index 3ac03d23..5393272b 100755 --- a/bin/reproducible_scheduler.py +++ b/bin/reproducible_scheduler.py @@ -215,10 +215,10 @@ def query_old_ftbfs_versions(suite, limit): 'no new version available, sorted by last build date' query = """SELECT DISTINCT s.id, s.name FROM sources AS s JOIN results AS r ON s.id = r.package_id - JOIN notes AS n ON n.package_id=s.id + OUTER JOIN notes AS n ON n.package_id=s.id WHERE s.suite='{suite}' AND r.status = 'FTBFS' - AND n.bugs = '[]' + AND ( n.bugs = '[]' OR n.bugs IS NULL ) AND r.build_date < datetime('now', '-10 day') AND s.id NOT IN (SELECT schedule.package_id FROM schedule) ORDER BY r.build_date |