Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Very slow to load pages @1.21.7 #29585

Closed
steven-hz opened this issue Mar 4, 2024 · 8 comments · Fixed by #29900
Closed

Very slow to load pages @1.21.7 #29585

steven-hz opened this issue Mar 4, 2024 · 8 comments · Fixed by #29900
Labels
performance/speed performance issues with slow downs type/bug
Milestone
1.21.9

Comments

@steven-hz
Copy link

Description

It's very fast when i visit admin/config page.
But when visit the pull page, load time may be longer than 7000ms

Gitea Version

1.21.7

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

2024/03/04 19:50:27 ...s/process/manager.go:231:remove() [T] Done 65e5b583-4: git(dir:/var/lib/gitea/data/gitea-repositories/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/04 19:50:29 ...eb/routing/logger.go:68:func1() [W] router: slow      GET /libs-self-dev/pulls/1 for 36.24.136.57:58283, elapsed 3197.5ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/04 19:50:29 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse

Git Version

No response

Operating System

No response

How are you running Gitea?

running gitea downloaded as a binary from https://dl.gitea.com/gitea/1.21.7/gitea-1.21.7-darwin-10.12-amd64 as a systemd service under ubuntu

Database

MySQL/MariaDB
@lunny
Copy link
Member

lunny commented Mar 5, 2024

How many comments and attachments on this issue?

@steven-hz
Copy link
Author

How many comments and attachments on this issue?
How to solve this issue, or it will be solvedd by next version?
Thanks!

@lunny
Copy link
Member

lunny commented Mar 5, 2024

We need more details because currently only 1 report for this.

@yp05327
Copy link
Contributor

yp05327 commented Mar 5, 2024 •
edited

I have met a similar issue last week in gitea.com, but after several times of refreshing the page, it became a bit faster, so I didn't create an issue about this. 😕

If the changes are very big, this one maybe related: #29164

@steven-hz
Copy link
Author

May this help more?

issues

image

user/settings

image

/pulls/1 pulls request will be very slow.

image

2024/03/05 16:40:17 ...s/process/manager.go:188:Add() [T] Start 65e6da71: GET: /test/libs-self-dev/pulls/1 (request)
2024/03/05 16:40:17 ...eb/routing/logger.go:47:func1() [T] router: started   GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0
2024/03/05 16:40:17 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:17 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:17 models/repo/repo.go:352:LoadUnits() [T] repo.Units, ID=7, Types: [TypeCode, TypeIssues, TypePullRequests, TypeReleases, TypeWiki, TypeProjects, TypePackages]
2024/03/05 16:40:17 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:18 ...eb/routing/logger.go:102:func1() [I] router: completed GET /user/events for 36.27.85.214:0, 200 OK in 9619.4ms @ events/events.go:18(events.Events)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da68-2: GET: /user/events
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da72: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da71) (normal)
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489 (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da72-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-2: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569) (from 65e6da71) (normal)
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-3: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569) (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:20 ...eb/routing/logger.go:68:func1() [W] router: slow      GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, elapsed 3101.1ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:20 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489 (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-5: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-5: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-6: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-6: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-7: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-7: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-8: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head -- (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-8: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head --
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-9: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head -- (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-9: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-3: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-2: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569)
2024/03/05 16:40:23 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801ce0 0xc007801d40 0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:23 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40 0xc007801a70 0xc007801ad0] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:24 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40 0xc007801a70] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:24 ...ource/manager_run.go:46:Run() [T] Event source has no listeners
2024/03/05 16:40:24 ...ource/manager_run.go:56:Run() [T] Pausing the eventsource
2024/03/05 16:40:24 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign
2024/03/05 16:40:24 ...s/process/manager.go:188:Add() [T] Start 65e6da78: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign (from 65e6da71) (normal)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da78: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign
2024/03/05 16:40:24 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev
2024/03/05 16:40:24 ...s/process/manager.go:188:Add() [T] Start 65e6da78-2: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev (from 65e6da71) (normal)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da78-2: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev
2024/03/05 16:40:24 .../context_response.go:68:HTML() [D] Template: repo/issue/view
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (6.402329802s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (6.402561066s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, 200 OK in 7420.0ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da71: GET: /test/libs-self-dev/pulls/1
2024/03/05 16:40:25 ...s/process/manager.go:188:Add() [T] Start 65e6da79: GET: /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA (request)
2024/03/05 16:40:25 ...eb/routing/logger.go:47:func1() [T] router: started   GET /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA for 36.27.85.214:0
2024/03/05 16:40:25 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:25 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:25 ...s/process/manager.go:188:Add() [T] Start 65e6da79-2: GET: /user/events (request)
2024/03/05 16:40:25 ...eb/routing/logger.go:47:func1() [T] router: started   GET /user/events for 36.27.85.214:0
2024/03/05 16:40:25 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:25 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:25 models/repo/repo.go:352:LoadUnits() [T] repo.Units, ID=7, Types: [TypeCode, TypeIssues, TypePullRequests, TypeReleases, TypeWiki, TypeProjects, TypePackages]
2024/03/05 16:40:25 ...ource/manager_run.go:61:Run() [T] Connection detected - restarting the eventsource
2024/03/05 16:40:25 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc0044eb380 0xc0044ec720 0xc0044ecc30 0xc0044ecf60 0xc0044ed140 0xc0044ed9e0 0xc0044edd70] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da79) (normal)
2024/03/05 16:40:26 ...s/process/manager.go:231:remove() [T] Done 65e6da7a: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da79) (normal)
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da79) (normal)
2024/03/05 16:40:27 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (1.233275091s)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da7a-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:27 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (1.233502703s)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da7a-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:27 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA for 36.27.85.214:0, 200 OK in 2239.0ms @ repo/issue_content_history.go:24(repo.GetContentHistoryOverview)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da79: GET: /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA
2024/03/05 16:40:28 ...eb/routing/logger.go:68:func1() [I] router: polling   GET /user/events for 36.27.85.214:0, elapsed 3208.3ms @ events/events.go:18(events.Events)

@yp05327
Copy link
Contributor

yp05327 commented Mar 6, 2024 

2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (6.402329802s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (6.402561066s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, 200 OK in 7420.0ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da71: GET: /test/libs-self-dev/pulls/1

maybe related

@yp05327
Copy link
Contributor

yp05327 commented Mar 11, 2024

image
https://gitea.com/gitea/act/pulls/84

@lunny lunny mentioned this issue Mar 20, 2024
Merged
@lunny lunny added this to the 1.21.9 milestone Mar 20, 2024
@yp05327 yp05327 added the performance/speed performance issues with slow downs label Mar 21, 2024
@yp05327
Copy link
Contributor

yp05327 commented Mar 21, 2024

I think this is not related to #29164 as diff page is very fast, it will also display the diff-stats.
Maybe it is caused by DB query.

lunny added a commit to lunny/gitea that referenced this issue Mar 21, 2024
@lunny @GiteaBot
Performance improvements for pull request list page (go-gitea#29900)
10a9161 
This PR will avoid load pullrequest.Issue twice in pull request list
page. It will reduce x times database queries for those WIP pull
requests.

Partially fix go-gitea#29585

---------

Co-authored-by: Giteabot <teabot@gitea.io>
@lunny lunny mentioned this issue Mar 21, 2024
Merged
wolfogre pushed a commit that referenced this issue Mar 22, 2024
@lunny
Performance improvements for pull request list page (#29900) (#29972)
6ef986d 
This PR will avoid load pullrequest.Issue twice in pull request list
page. It will reduce x times database queries for those WIP pull
requests.

Partially fix #29585
Backport #29900
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
performance/speed performance issues with slow downs type/bug
Projects
None yet
Milestone
1.21.9
Development

Successfully merging a pull request may close this issue.

Performance improvements for pull request list page lunny/gitea
3 participants
@lunny @yp05327 @steven-hz