#803 Email notifications makes build tasks fail with "KeyError: 'users_usertype'"
Closed: Fixed 6 years ago Opened 6 years ago by julian8628.

hub log:

[Wed Feb 07 11:45:21 2018] [error] 2018-02-07 11:45:21,408 [ERROR] m=host.completeBuild u=kojibuilder p=12876 r=172.16.192.27:56118     koji.db: Unable to quote query:
[Wed Feb 07 11:45:21 2018] [error]
[Wed Feb 07 11:45:21 2018] [error] SELECT email
[Wed Feb 07 11:45:21 2018] [error]   FROM build_notifications
[Wed Feb 07 11:45:21 2018] [error]   JOIN users ON build_notifications.user_id = users.id
[Wed Feb 07 11:45:21 2018] [error]  WHERE (status = %(users_status)s)
[Wed Feb 07 11:45:21 2018] [error]    AND (usertype IN %(users_usertype)s)
[Wed Feb 07 11:45:21 2018] [error]    AND (package_id = %(package_id)s OR package_id IS NULL)
[Wed Feb 07 11:45:21 2018] [error]    AND (tag_id = %(tag_id)s OR tag_id IS NULL)
[Wed Feb 07 11:45:21 2018] [error]
[Wed Feb 07 11:45:21 2018] [error]
[Wed Feb 07 11:45:21 2018] [error]
[Wed Feb 07 11:45:21 2018] [error]
[Wed Feb 07 11:45:21 2018] [error] Parameters: {'users_usertypes': (0, 2), 'state': 1, 'tag_id': 3, 'users_status': 0, 'package_id': 2, 'build': {'package_name': 'python-dslib', 'extra': {'source': {'original_url': 'git://pkgs.fedoraproject.org/rpms/python-dslib/#origin/ f27'}}, 'creation_time': datetime.datetime(2018, 2, 7, 11, 43, 50, 493756), 'completion_time': datetime.datetime(2018, 2, 7, 11, 45,    21, 374999), 'package_id': 2, 'id': 2, 'build_id': 2, 'epoch': None, 'source': 'git://pkgs.fedoraproject.org/rpms/python-               dslib#51d37167c73c8eb032dc509e99c29a8539c26f41', 'state': 1, 'version': '3.1', 'completion_ts': 1518021921.375, 'owner_id': 3,          'owner_name': 'testadmin', 'nvr': 'python-dslib-3.1-6.fc27', 'start_time': datetime.datetime(2018, 2, 7, 11, 43, 50, 493756),           'creation_event_id': 169, 'start_ts': 1518021830.4937601, 'volume_id': 0, 'creation_ts': 1518021830.4937601, 'name': 'python-dslib',    'task_id': 9, 'volume_name': 'DEFAULT', 'release': '6.fc27'}, 'joins': ('JOIN users ON build_notifications.user_id = users.id',),       'clauses': ('status = %(users_status)i', 'usertype IN %(users_usertype)s', 'package_id = %(package_id)i OR package_id IS NULL', 'tag_id = %(tag_id)i OR tag_id IS NULL')}
[Wed Feb 07 11:45:21 2018] [error] Traceback (most recent call last):
[Wed Feb 07 11:45:21 2018] [error]   File "/usr/lib/python2.6/site-packages/koji/db.py", line 105, in quote
[Wed Feb 07 11:45:21 2018] [error]     return quote(operation, parameters)
[Wed Feb 07 11:45:21 2018] [error] KeyError: 'users_usertype'

Login to comment on this ticket.

Metadata