MyFinances icon indicating copy to clipboard operation
MyFinances copied to clipboard

bug: running migration causes freeze + db lock

Open TreyWW opened this issue 1 year ago • 1 comments

What version of MyFinances are you currently using?

v0.6.6-2-g260c89e

What device type are you currently facing the issue on?

No response

Describe the bug

Locally running new migrations to just hang, normally takes around 3 commands to get one to work. Not sure if this happens to anyone else, it doesn't happen in production.

Would appreciate a comment from someone else :)

TreyWW avatar Sep 16 '24 19:09 TreyWW

error: django.db.utils.OperationalError: database is locked.

As soon as the error comes (normally a few minutes) the next migration works fine, but it hangs on any command up to that point. It's most likely an issue with SQLite though

TreyWW avatar Sep 16 '24 19:09 TreyWW

Found out that this was caused by Silk profiling. When you have too many requests it gets really slow. And I had a lot of requests.

TreyWW avatar Nov 07 '24 20:11 TreyWW