#3109 listTasks() API call just hangs in Fedora koji
Opened 2 years ago by sharkcz. Modified 2 years ago

I have a script that's using listTasks() API which works fine with Brew and Centos Stream koji and worked also with Fedora koji instance (eg. in May), but doesn't work any more. It just hangs. Has anything changed?

see https://pagure.io/releng/blob/main/f/scripts/koji-task-report.py#_41 for the script/code


Can you report the exact parameters you are using?

In an instance like Fedora's the tasks table is very large and sometimes the query planner in Postgres can make odd choices.

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

2 years ago

I have used for example ./koji-task-report.py s390x 2021-11-01 2021-11-02

for the record, API like listTagged() works like a charm

so the real problem is a long response time, a moment ago it took 18 minutes, clearly I wasn't patient enough :-)

It looks like some index problem in Fedora's instance? (In brew I'm getting similar queries under 10 seconds).

Login to comment on this ticket.

Metadata