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

web 500 error database is locked #9726

New Issue
Closed
opened 2025-11-02 08:47:45 -06:00 by GiteaMirror · 3 comments
GiteaMirror commented 2025-11-02 08:47:45 -06:00
Owner
Copy Link

Originally created by @wangwj on GitHub (Oct 24, 2022).

Description

2022/10/24 05:03:40 ...ers/web/repo/view.go:705:checkHomeCodeViewable() [E] [63561cab] ReadBy: database is locked
2022/10/24 05:03:40 ...s/context/context.go:219:HTML() [D] [63561cab] Template: status/500

image

Gitea Version

1.17.3

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

i use docker run gitea
docker run -d
--restart=always
--privileged
--name gitea
-v /gitea:/data -p 9000:3000 -m 500m
gitea/gitea:1.17.3

Database

SQLite

Originally created by @wangwj on GitHub (Oct 24, 2022). ### Description 2022/10/24 05:03:40 ...ers/web/repo/view.go:705:checkHomeCodeViewable() [E] [63561cab] ReadBy: database is locked 2022/10/24 05:03:40 ...s/context/context.go:219:HTML() [D] [63561cab] Template: status/500 <img width="1414" alt="image" src="https://user-images.githubusercontent.com/4464162/197452099-c775629d-304d-4dcf-bf76-c67f933f46e8.png"> ### Gitea Version 1.17.3 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? i use docker run gitea docker run -d \ --restart=always \ --privileged \ --name gitea \ -v /gitea:/data -p 9000:3000 -m 500m \ gitea/gitea:1.17.3 ### Database SQLite
GiteaMirror added the issue/needs-feedbackissue/not-a-bug labels 2025-11-02 08:47:45 -06:00
GiteaMirror commented 2025-11-02 08:47:46 -06:00
Author
Owner
Copy Link

@KN4CK3R commented on GitHub (Oct 24, 2022):

There must be another process which interacts with your database file. Check that, should not be a Gitea error.

@KN4CK3R commented on GitHub (Oct 24, 2022): There must be another process which interacts with your database file. Check that, should not be a Gitea error.
GiteaMirror commented 2025-11-02 08:47:46 -06:00
Author
Owner
Copy Link

@wangwj commented on GitHub (Oct 25, 2022):

i not found other process database , show i use lsof result:
image
image
image

i found sql update long time
image

when i run docker on bare ,no error
current state ,i run in vm,mount smb file system ,may be smb visit long time ,UPDATE notification long time
other query ok

i found err reason: i use cifs mount file system ,default file lock ,need modify default mount param
image

@KN4CK3R

@wangwj commented on GitHub (Oct 25, 2022): i not found other process database , show i use lsof result: <img width="969" alt="image" src="https://user-images.githubusercontent.com/4464162/197657075-aaea16a2-97fd-4b51-82ce-99e05399f076.png"> <img width="904" alt="image" src="https://user-images.githubusercontent.com/4464162/197657105-0ce93366-01c4-4d08-881d-aa9de4a1d897.png"> <img width="973" alt="image" src="https://user-images.githubusercontent.com/4464162/197657172-ccdfdc11-f81c-4bc9-82cd-d823bfc1f7e2.png"> i found sql update long time <img width="1432" alt="image" src="https://user-images.githubusercontent.com/4464162/197692676-30f5b671-5f11-4b78-b79f-6ed0c27d9b43.png"> when i run docker on bare ,no error current state ,i run in vm,mount smb file system ,may be smb visit long time ,UPDATE `notification` long time other query ok i found err reason: i use cifs mount file system ,default file lock ,need modify default mount param <img width="1169" alt="image" src="https://user-images.githubusercontent.com/4464162/197705006-4a23382a-b2f3-4876-8ed1-33b71d37ffc3.png"> @KN4CK3R
GiteaMirror commented 2025-11-02 08:47:46 -06:00
Author
Owner
Copy Link

@wxiaoguang commented on GitHub (Oct 26, 2022):

i found err reason: i use cifs mount file system ,default file lock ,need modify default mount param

Yup, it's filesystem related.

@wxiaoguang commented on GitHub (Oct 26, 2022): > i found err reason: i use cifs mount file system ,default file lock ,need modify default mount param Yup, it's filesystem related.
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 issue/needs-feedback issue/not-a-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#9726
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?