Koschei does not rebuild some packages

[voxik]

For example these packages have not been rebuilt for some time already:

https://apps.fedoraproject.org/koschei/package/ruby-shadow?collection=f27 https://apps.fedoraproject.org/koschei/package/rubygem-ttfunk?collection=f27

[mizdebsk]

Analysis, based on ruby-shadow in f27:

In [102]: c = db.query(Collection).filter_by(name='f27').one()

In [103]: p = db.query(Package).filter_by(name='ruby-shadow', collection_id=c.id).one()

In [104]: koji_session.repoInfo(p.last_complete_build.repo_id)
Out[104]: 
{'create_event': 21191408,
 'create_ts': 1486855800.01993,
 'creation_time': '2017-02-11 23:30:00.019927',
 'dist': False,
 'id': 694577,
 'state': 3,
 'tag_id': 364,
 'tag_name': 'f26-build'}

In [105]: koji.REPO_STATES
Out[105]: {'DELETED': 3, 'EXPIRED': 2, 'INIT': 0, 'PROBLEM': 4, 'READY': 1}

So, the last complete build for ruby-shadow was done in Koji repo, which was already deleted. As a consequence, Koschei is unable to resolve build dependencies (which is manifested in Web UI as "Dependencies for this build couldn't be processed"). Since build dependencies are not known, Koschei can't compute dependency changes and therefore its priority is quite low, and package is not scheduled.

[mizdebsk]

As a workaround I've bumped manual priority for 183 packages affected by this issue:

[root@koschei-backend01 ~][PROD]# sudo -u koschei koschei-admin psql <<<"UPDATE package SET manual_priority = 1337500 FROM build WHERE build.last_complete AND package.id = build.package_id AND package.resolved AND NOT build.deps_resolved AND package.manual_priority = 0;"
UPDATE 183