koji

#1894 listUsers doen't support countOnly in queryOpts, kojiweb users tab broken
Closed: Duplicate by julian8628. Opened by enteropia.

Closed: Duplicate
Reopen Issue

Introduced by #aaeb41e5

On Users tab generation in kojiweb, count(*) is taken from query with LEFT JOIN user_krb_principals and GROUP BY users.id: result is multi-row table of numbers (1 or greater) instead of one-row users count.

Error traceback is:

Traceback (most recent call last):
  File "/usr/share/koji-web/scripts/wsgi_publisher.py", line 372, in handle_request
    result = func(environ, **data)
  File "/usr/share/koji-web/scripts/index.py", line 1322, in users
    start=start, dataName='users', prefix='user', order=order)
  File "/usr/share/koji-web/lib/kojiweb/util.py", line 316, in paginateMethod
    totalRows = getattr(server, methodName)(*args, **kw)
  File "/usr/lib/python3.6/site-packages/koji/__init__.py", line 2135, in __call__
    return self.__func(self.__name, args, opts)
  File "/usr/lib/python3.6/site-packages/koji/__init__.py", line 2650, in _callMethod
    raise err
koji.GenericError: Traceback (most recent call last):
  File "/usr/share/koji-hub/kojixmlrpc.py", line 235, in _wrap_handler
    response = handler(environ)
  File "/usr/share/koji-hub/kojixmlrpc.py", line 278, in handle_rpc
    return self._dispatch(method, params)
  File "/usr/share/koji-hub/kojixmlrpc.py", line 315, in _dispatch
    ret = koji.util.call_with_argcheck(func, params, opts)
  File "/usr/lib/python3.6/site-packages/koji/util.py", line 261, in call_with_argcheck
    return func(*args, **kwargs)
  File "/usr/share/koji-hub/kojihub.py", line 11249, in listUsers
    return query.execute()
  File "/usr/share/koji-hub/kojihub.py", line 8656, in execute
    return _singleValue(query, self.values, strict=True)
  File "/usr/share/koji-hub/kojihub.py", line 4931, in _singleValue
    row = _fetchSingle(query, values, strict)
  File "/usr/share/koji-hub/kojihub.py", line 4897, in _fetchSingle
    raise koji.GenericError('multiple rows returned for a single row query')
koji.GenericError: multiple rows returned for a single row query

this is duplicate of #1844 and will be fixed in koji 1.20

Metadata Update from @julian8628:
- Custom field Size adjusted to None

Metadata Update from @julian8628:
- Issue close_status updated to: Duplicate
- Issue status updated to: Closed (was: Open)

Metadata Update from @julian8628:
- Issue set to the milestone: 1.20

Metadata Update from @jcupova:
- Issue tagged with: testing-done

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/1894

Please continue any further discussion there.
Metadata
None

testing-done

None
None
Low
None
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.