kernelci / kernelci/dashboard

Bug: treeView doesn't return trees with null url

Open
#1,180 0 comments 0 reactions 0 assignees View on GitHub
bug Queries
Dominant language
Python
Stars
9
Forks
31
Avg merge
3d 19h
Merged PRs (30d)
16

Description

**Description**: When querying a tree listing, the treeViewFast will return trees with the `git_repository_branch`, `git_repository_url`, `commit_hash` and `commit_name` nulls, while the treeView doesn't return such rows.

**Reproduction**: Execute the queries for the [treeListingFast](https://github.com/kernelci/dashboard/blob/b7b8a028e3adcb389df9ecbb752ad0d21875bec8/backend/kernelCI_app/queries/tree.py#L209) and [treeListing](https://github.com/kernelci/dashboard/blob/b7b8a028e3adcb389df9ecbb752ad0d21875bec8/backend/kernelCI_app/queries/tree.py#L96) and substituite the date conditions by `DATE(start_time) = '2025-04-16'`, origin by `redhat` and no need for the counts. You should see one row with null fields in the fast query, but none in the other query.

Contributor guide

Open the contributing guide

Research direction

Start with backend/kernelCI_app/queries/tree.py, comparing treeListingFast at line 209 with treeListing at line 96. Run both queries using DATE(start_time) = '2025-04-16' and origin redhat, without counts, then trace why the row with null repository and commit fields is omitted. Done means treeListing returns the same applicable row as treeListingFast.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
backend, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.