github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-09 04:25:18 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Performance with admin account while loading Issues and PRs pages #7224

New Issue
Closed
opened 2025-11-02 07:20:09 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2025-11-02 07:20:09 -06:00
Owner
Copy Link

Originally created by @ndaidong on GitHub (Apr 21, 2021).

  • Gitea version (or commit ref): 1.14.1

  • Git version: 2.29.2

  • Operating system: Debian 10.9

  • Database (use [x]):

    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite

  • Can you reproduce the bug at https://try.gitea.io:

    • Yes (provide example URL)
    • No

  • Log gist:

Description

Gitea takes too long time to load Issues and Pull Requests dashboard (in comparison with itself at this context).
The time to load is about 3 - 4 seconds. BUT, this problem only occurs with admin account.

Both users don't watch any repo. However the admin account is used to migrate more than 600 repos.

Admin account

gitea - admin - PRs

gitea - admin - issues

Regular account

gitea - regular user - PRs

gitea - regular user - issues

Originally created by @ndaidong on GitHub (Apr 21, 2021). - Gitea version (or commit ref): 1.14.1 - Git version: 2.29.2 - Operating system: Debian 10.9 - Database (use `[x]`): - [x] PostgreSQL - [ ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - Log gist: ## Description Gitea takes too long time to load Issues and Pull Requests dashboard (in comparison with itself at this context). The time to load is about 3 - 4 seconds. BUT, this problem only occurs with admin account. Both users don't watch any repo. However the admin account is used to migrate more than 600 repos. ### Admin account ![gitea - admin - PRs](https://user-images.githubusercontent.com/1809619/115545515-18ebc780-a2ce-11eb-8008-aedfbb5f5c5e.png) ![gitea - admin - issues](https://user-images.githubusercontent.com/1809619/115545509-17220400-a2ce-11eb-9368-331cd1019dc5.png) ### Regular account ![gitea - regular user - PRs](https://user-images.githubusercontent.com/1809619/115545519-1a1cf480-a2ce-11eb-8015-0fe577916469.png) ![gitea - regular user - issues](https://user-images.githubusercontent.com/1809619/115545517-19845e00-a2ce-11eb-9347-44cec8da1e04.png)
GiteaMirror added the performance/speed label 2025-11-02 07:20:09 -06:00
GiteaMirror commented 2025-11-02 07:20:10 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Apr 22, 2021):

Could you give some logs when admin user visit this page?

@lunny commented on GitHub (Apr 22, 2021): Could you give some logs when admin user visit this page?
GiteaMirror commented 2025-11-02 07:20:10 -06:00
Author
Owner
Copy Link

@ndaidong commented on GitHub (Apr 22, 2021):

@lunny of course, this is the access log from admin account administor only. Here I navigated to 4 internal links at top left corner (Dashboard, Issues, Pull Requests, Explore):

10.1.0.25:49428 - administor [22/Apr/2021:13:20:04 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49454 - administor [22/Apr/2021:13:20:09 +0700] "GET /explore/repos HTTP/1.1" 200 64095 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49468 - administor [22/Apr/2021:13:20:10 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49470 - administor [22/Apr/2021:13:20:11 +0700] "GET / HTTP/1.1" 200 149904 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49750 - administor [22/Apr/2021:13:20:13 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&limit=15&mode=&archived=false HTTP/1.1" 200 23135 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49748 - administor [22/Apr/2021:13:20:13 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&mode= HTTP/1.1" 200 45588 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:49746 - administor [22/Apr/2021:13:20:13 +0700] "GET /user/events HTTP/1.1" 200 259 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50102 - administor [22/Apr/2021:13:21:39 +0700] "GET / HTTP/1.1" 200 149917 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50396 - administor [22/Apr/2021:13:21:41 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&limit=15&mode=&archived=false HTTP/1.1" 200 23135 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50394 - administor [22/Apr/2021:13:21:41 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&mode= HTTP/1.1" 200 45588 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50392 - administor [22/Apr/2021:13:21:41 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50410 - administor [22/Apr/2021:13:21:44 +0700] "GET /issues HTTP/1.1" 200 86946 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50698 - administor [22/Apr/2021:13:21:48 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50708 - administor [22/Apr/2021:13:21:51 +0700] "GET /pulls HTTP/1.1" 200 93525 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50732 - administor [22/Apr/2021:13:21:55 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"
10.1.0.25:50734 - administor [22/Apr/2021:13:21:56 +0700] "GET /explore/repos HTTP/1.1" 200 64099 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0"

Activity logs during above events: https://gist.github.com/ndaidong/5894e3ae054e7d7ef1ca06b5496b4199

@ndaidong commented on GitHub (Apr 22, 2021): @lunny of course, this is the access log from admin account `administor` only. Here I navigated to 4 internal links at top left corner (Dashboard, Issues, Pull Requests, Explore): ``` 10.1.0.25:49428 - administor [22/Apr/2021:13:20:04 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49454 - administor [22/Apr/2021:13:20:09 +0700] "GET /explore/repos HTTP/1.1" 200 64095 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49468 - administor [22/Apr/2021:13:20:10 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49470 - administor [22/Apr/2021:13:20:11 +0700] "GET / HTTP/1.1" 200 149904 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49750 - administor [22/Apr/2021:13:20:13 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&limit=15&mode=&archived=false HTTP/1.1" 200 23135 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49748 - administor [22/Apr/2021:13:20:13 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&mode= HTTP/1.1" 200 45588 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:49746 - administor [22/Apr/2021:13:20:13 +0700] "GET /user/events HTTP/1.1" 200 259 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50102 - administor [22/Apr/2021:13:21:39 +0700] "GET / HTTP/1.1" 200 149917 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50396 - administor [22/Apr/2021:13:21:41 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&limit=15&mode=&archived=false HTTP/1.1" 200 23135 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50394 - administor [22/Apr/2021:13:21:41 +0700] "GET /api/v1/repos/search?sort=updated&order=desc&uid=1&team_id=0&q=&page=1&mode= HTTP/1.1" 200 45588 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50392 - administor [22/Apr/2021:13:21:41 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50410 - administor [22/Apr/2021:13:21:44 +0700] "GET /issues HTTP/1.1" 200 86946 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50698 - administor [22/Apr/2021:13:21:48 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50708 - administor [22/Apr/2021:13:21:51 +0700] "GET /pulls HTTP/1.1" 200 93525 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50732 - administor [22/Apr/2021:13:21:55 +0700] "GET /user/events HTTP/1.1" 200 1 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" 10.1.0.25:50734 - administor [22/Apr/2021:13:21:56 +0700] "GET /explore/repos HTTP/1.1" 200 64099 "\" \"Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0" ``` Activity logs during above events: https://gist.github.com/ndaidong/5894e3ae054e7d7ef1ca06b5496b4199
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label performance/speed
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#7224
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?