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.

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

[Issue] Database is locked #4849

Closed
Johnnybegood90 opened this issue May 17, 2024 · 2 comments
Closed

[Issue] Database is locked #4849

Johnnybegood90 opened this issue May 17, 2024 · 2 comments
Labels
bug report Bug reports that are not yet verified

Comments

@Johnnybegood90
Copy link

Johnnybegood90 commented May 17, 2024

Hello, I'm stuck with the error “beginning transaction: database is locked” on Debian. I don't understand why because I don't have any action in progress on Stash, no stain nothing.
A Stash restart or a server restart doesn't solve the problem

2024-05-17T13:39:22.940358106+02:00 INF Response: 200 OK httpRequest={"proto":"HTTP/1.1","remoteIP":"192.168.0.23:56828","requestID":"Asus-Laptop/YqStMoYMmZ-000024","requestMethod":"POST","requestPath":"/graphql","requestURL":"http://fqdn/graphql"%7D httpResponse={"bytes":55,"elapsed":0.56317,"status":200} service=stash
ERRO[2024-05-17 13:39:23] findDefaultFilter: input: findDefaultFilter beginning transaction: database is locked

Stash Version: (from Settings -> About):
0.25.1

Desktop (please complete the following information):

  • OS: Debian
  • Browser Brave
  • Version latest
@Johnnybegood90 Johnnybegood90 added the bug report Bug reports that are not yet verified label May 17, 2024
@WithoutPants
Copy link
Collaborator

I can't think of a reason why this might be happening and my best guess is that the database is corrupt somehow. Could you maybe try the steps outlined in this stack overflow answer?

@Johnnybegood90
Copy link
Author

@WithoutPants after a backup, I tried to remove stash-go.sqlite-shm and stash-go.sqlite-wal, I don't understand why, but that solved the issue.

@WithoutPants WithoutPants closed this as not planned Won't fix, can't repro, duplicate, stale May 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug report Bug reports that are not yet verified
Projects
Status: Done
Development

No branches or pull requests

2 participants