github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-12 02:24:21 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Start page is 10x slower after update to 1.18.0 #10034

New Issue
Closed
opened 2025-11-02 08:56:26 -06:00 by GiteaMirror · 4 comments
GiteaMirror commented 2025-11-02 08:56:26 -06:00
Owner
Copy Link

Originally created by @somera on GitHub (Dec 31, 2022).

Description

After upgrade to 1.18.0 a see a slowdown loading the start page.

image

Some optimizations were made in #21031.

This is what I foud at the moment:

I see 2659x this

2022/12/31 13:34:28 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 1.144962ms
2022/12/31 13:34:28 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 571.941µs
..
..
..
..
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 508.168µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 423.219µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 411.846µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 392.807µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 440.163µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 394.718µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 437.802µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 466.235µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 411.094µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 459.483µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 462.974µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 445.628µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 415.936µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 419.829µs
2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 515.498µs

statement in the log.

Gitea Version

1.18.0

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

2.39.0

Operating System

Ubuntu 20.04.5

How are you running Gitea?

Self hosted gitea-1.18.0-linux-amd64

Database

PostgreSQL

Originally created by @somera on GitHub (Dec 31, 2022). ### Description After upgrade to 1.18.0 a see a slowdown loading the start page. ![image](https://user-images.githubusercontent.com/8334250/210137060-f8a94bbd-7740-49c4-813d-e43dfa6f6947.png) Some optimizations were made in #21031. This is what I foud at the moment: I see 2659x this ``` 2022/12/31 13:34:28 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 1.144962ms 2022/12/31 13:34:28 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 571.941µs .. .. .. .. 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 508.168µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 423.219µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 411.846µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 392.807µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 440.163µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 394.718µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 437.802µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 466.235µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 411.094µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 459.483µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 462.974µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.enable_federated_avatar] - 445.628µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 415.936µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 419.829µs 2022/12/31 13:34:31 ...ls/system/setting.go:121:GetSettings() [I] [63b02c54] [SQL] SELECT "id", "setting_key", "setting_value", "version", "created", "updated" FROM "system_setting" WHERE setting_key IN ($1) [picture.disable_gravatar] - 515.498µs ``` statement in the log. ### Gitea Version 1.18.0 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version 2.39.0 ### Operating System Ubuntu 20.04.5 ### How are you running Gitea? Self hosted gitea-1.18.0-linux-amd64 ### Database PostgreSQL
GiteaMirror added the type/bug label 2025-11-02 08:56:26 -06:00
GiteaMirror commented 2025-11-02 08:56:27 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Dec 31, 2022):

I think this is duplicated with #22281 because you are using redis as cache?

@lunny commented on GitHub (Dec 31, 2022): I think this is duplicated with #22281 because you are using redis as cache?
GiteaMirror commented 2025-11-02 08:56:27 -06:00
Author
Owner
Copy Link

@delvh commented on GitHub (Dec 31, 2022):

Duplicate of #22281?

@delvh commented on GitHub (Dec 31, 2022): Duplicate of #22281?
GiteaMirror commented 2025-11-02 08:56:28 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Dec 31, 2022):

I think this is duplicated with #22281 because you are using redis as cache?

No, I'm using memcached

[cache]
ENABLED = true
ADAPTER = memcache
INTERVAL = 240
HOST = 192.168.178.30:11211
ITEM_TTL = 16h
@somera commented on GitHub (Dec 31, 2022): > I think this is duplicated with #22281 because you are using redis as cache? No, I'm using memcached ``` [cache] ENABLED = true ADAPTER = memcache INTERVAL = 240 HOST = 192.168.178.30:11211 ITEM_TTL = 16h ```
GiteaMirror commented 2025-11-02 08:56:28 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Jan 18, 2023):

The fix in 1.18.1 works. thx.

@somera commented on GitHub (Jan 18, 2023): The fix in 1.18.1 works. thx.
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 type/bug
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#10034
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?