I am seeing in production koji a bunch of tracebacks like:
[Sun Jun 18 19:59:11.581915 2017] [:error] [pid 10452] 2017-06-18 19:59:11,581 [ERROR] m=listHosts u=koschei p=10452 r=1 0.5.126.51:59930 koji.db: Query failed. Query was: [Sun Jun 18 19:59:11.581952 2017] [:error] [pid 10452] SELECT id, user_id, name, arches, task_load, capacity, descriptio n, comment, ready, enabled [Sun Jun 18 19:59:11.581967 2017] [:error] [pid 10452] FROM host [Sun Jun 18 19:59:11.581969 2017] [:error] [pid 10452] JOIN host_channels on host.id = host_channels.host_id [Sun Jun 18 19:59:11.581972 2017] [:error] [pid 10452] WHERE (()) [Sun Jun 18 19:59:11.581974 2017] [:error] [pid 10452] AND (host_channels.channel_id = 1) [Sun Jun 18 19:59:11.581976 2017] [:error] [pid 10452] AND (enabled is true) [Sun Jun 18 19:59:11.581978 2017] [:error] [pid 10452] [Sun Jun 18 19:59:11.581980 2017] [:error] [pid 10452] [Sun Jun 18 19:59:11.581982 2017] [:error] [pid 10452] [Sun Jun 18 19:59:11.581984 2017] [:error] [pid 10452] [Sun Jun 18 19:59:11.587151 2017] [:error] [pid 10452] 2017-06-18 19:59:11,587 [WARNING] m=listHosts u=koschei p=10452 r=10.5.126.51:59930 koji.xmlrpc: Traceback (most recent call last): [Sun Jun 18 19:59:11.587197 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojixmlrpc.py", line 241, in _wrap_handler [Sun Jun 18 19:59:11.587209 2017] [:error] [pid 10452] response = handler(environ) [Sun Jun 18 19:59:11.587211 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojixmlrpc.py", line 284, in handle_rpc [Sun Jun 18 19:59:11.587214 2017] [:error] [pid 10452] return self._dispatch(method, params) [Sun Jun 18 19:59:11.587216 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojixmlrpc.py", line 321, in _dispatch [Sun Jun 18 19:59:11.587218 2017] [:error] [pid 10452] ret = koji.util.call_with_argcheck(func, params, opts) [Sun Jun 18 19:59:11.587228 2017] [:error] [pid 10452] File "/usr/lib/python2.7/site-packages/koji/util.py", line 156, in call_with_argcheck [Sun Jun 18 19:59:11.587231 2017] [:error] [pid 10452] return func(*args, **kwargs) [Sun Jun 18 19:59:11.587233 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojihub.py", line 10526, in listHosts [Sun Jun 18 19:59:11.587236 2017] [:error] [pid 10452] return query.execute() [Sun Jun 18 19:59:11.587238 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojihub.py", line 7734, in execute [Sun Jun 18 19:59:11.587240 2017] [:error] [pid 10452] data = _multiRow(query, self.values, (self.aliases or self.columns)) [Sun Jun 18 19:59:11.587242 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojihub.py", line 4394, in _multiRow [Sun Jun 18 19:59:11.587244 2017] [:error] [pid 10452] return [dict(zip(fields, row)) for row in _fetchMulti(query, values)] [Sun Jun 18 19:59:11.587246 2017] [:error] [pid 10452] File "/usr/share/koji-hub/kojihub.py", line 4366, in _fetchMulti [Sun Jun 18 19:59:11.587248 2017] [:error] [pid 10452] c.execute(query, values) [Sun Jun 18 19:59:11.587250 2017] [:error] [pid 10452] File "/usr/lib/python2.7/site-packages/koji/db.py", line 135, in execute [Sun Jun 18 19:59:11.587253 2017] [:error] [pid 10452] ret = self.cursor.execute(operation, parameters) [Sun Jun 18 19:59:11.587255 2017] [:error] [pid 10452] ProgrammingError: syntax error at or near ")" [Sun Jun 18 19:59:11.587257 2017] [:error] [pid 10452] LINE 5: WHERE (()) [Sun Jun 18 19:59:11.587259 2017] [:error] [pid 10452] ^ [Sun Jun 18 19:59:11.587261 2017] [:error] [pid 10452] [Sun Jun 18 19:59:11.587263 2017] [:error] [pid 10452]
Not sure if the query is wrong or koji is doing something wrong, but thought I would start here. :)
Looks like it's a koji issue:
https://pagure.io/koji/issue/463
this is filed at koji at https://pagure.io/koji/issue/463
Login to comment on this ticket.