#1436 buildReferences fails for non-rpm builds
Closed: Fixed 4 years ago by mikem. Opened 4 years ago by mikem.

There is a typo in the "most recent use" check in build_references() that results in an error like the following:

2019-05-17 12:55:32,153 [ERROR] m=buildReferences u=None p=18442 r=?:? koji.db: Query failed. Query was: 
SELECT max(standard_buildroot.create_event)
  FROM buildroot_archives
  JOIN standard_buildroot ON buildroot_listing.buildroot_id = standard_buildroot.buildroot_id
 WHERE (buildroot_listing.archive_id IN ((36), (37), (38), (39), (40), (41)))




2019-05-17 12:55:32,156 [WARNING] m=buildReferences u=None p=18442 r=?:? koji.xmlrpc: Traceback (most recent call last):
  File "/home/mike/Devel/koji/koji/hub/kojixmlrpc.py", line 236, in _wrap_handler
    response = handler(environ)
  File "/home/mike/Devel/koji/koji/hub/kojixmlrpc.py", line 279, in handle_rpc
    return self._dispatch(method, params)
  File "/home/mike/Devel/koji/koji/hub/kojixmlrpc.py", line 316, in _dispatch
    ret = koji.util.call_with_argcheck(func, params, opts)
  File "/home/mike/Devel/koji/koji/koji/util.py", line 263, in call_with_argcheck
    return func(*args, **kwargs)
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 9342, in buildReferences
    return build_references(get_build(build, strict=True)['id'], limit, lazy)
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 7227, in build_references
    event_id2 = query.singleValue(strict=False) or 0
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 8074, in singleValue
    return _singleValue(str(self), self.values, strict=strict)
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 4629, in _singleValue
    row = _fetchSingle(query, values, strict)
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 4587, in _fetchSingle
    results = _fetchMulti(query, values)
  File "/home/mike/Devel/koji/koji/hub/kojihub.py", line 4577, in _fetchMulti
    c.execute(query, values)
  File "/home/mike/Devel/koji/koji/koji/db.py", line 136, in execute
    ret = self.cursor.execute(operation, parameters)
ProgrammingError: missing FROM-clause entry for table "buildroot_listing"
LINE 4:   JOIN standard_buildroot ON buildroot_listing.buildroot_id ...
                                     ^

Login to comment on this ticket.

Metadata
Related Pull Requests
  • #1437 Merged 4 years ago