Casvt / Kapowarr

Kapowarr is a software to build and manage a comic book library, fitting in the *arr suite of software.
https://casvt.github.io/Kapowarr/
GNU General Public License v3.0
348 stars 12 forks source link

sqlite3.OperationalError: database is locked #165

Closed JonOve closed 1 week ago

JonOve commented 1 week ago

Description of the bug

I receive the error "sqlite3.OperationalError: database is locked". Not sure if it is a relevant error for downloading files from GetComic?

To Reproduce

Just check the logs

Expected behaviour I would not xpect this error, however I do not know if it is a relevant error.

Screenshots

image

Version info

Kowarr version v1.0.0-beta-4 in docker on a synology nas

Casvt commented 1 week ago

There was something downloading in the background probably. It's fixed already. If anything stops working after the error is raised, just restart Kapowarr.

JonOve commented 1 week ago

Sorry to open this issue again. After restarting Kapowarr the error is returning still and every hour. Kapowarr has not downloaded any files so far, so I am not sure if a downloading job in the background is the issue.

Casvt commented 1 week ago

It for sure is already fixed, but these fixes are not included in the beta-4 release. They are in the alpha releases though. So if the error really breaks the user experience, then you can switch to using the alpha releases. You can switch by changing the repo: fetch using the mrcas/kapowarr-alpha:latest repo instead of the normal mrcas/kapowarr:latest repo.

JonOve commented 1 week ago

Clear! Many thanks for all your work!

DocDrydenn commented 1 week ago

I was getting the same error. Switched over to mrcas/kapowarr-alpha:latest and now running into the following:

kapowarr  | [21:53:35][INFO] Starting up Kapowarr
kapowarr  | [21:53:35][WARNING] The value for this setting is invalid: service_preference: mega,mediafire,getcomics,getcomics (torrent),wetransfer
kapowarr  | Traceback (most recent call last):
kapowarr  |   File "/app/Kapowarr.py", line 130, in <module>
kapowarr  |     _main()
kapowarr  |   File "/app/Kapowarr.py", line 40, in _main
kapowarr  |     setup_db()
kapowarr  |   File "/app/backend/db.py", line 907, in setup_db
kapowarr  |     migrate_db(current_db_version)
kapowarr  |   File "/app/backend/db.py", line 666, in migrate_db
kapowarr  |     s["service_preference"] = service_preference
kapowarr  |   File "/app/backend/settings.py", line 264, in __setitem__
kapowarr  |     value = self.__check_value(name, value)
kapowarr  |   File "/app/backend/settings.py", line 232, in __check_value
kapowarr  |     raise InvalidSettingValue(key, value)
kapowarr  | backend.custom_exceptions.InvalidSettingValue: service_preference
kapowarr  | [21:53:35][INFO] Migrating database to newer version...
kapowarr  | [21:53:35][INFO] Changing setting: service_preference->mega,mediafire,getcomics,getcomics (torrent),wetransfer

Any fix before I restore from backup?

Casvt commented 1 week ago

You're migrating too fast. Upgrade to alpha-26 first. Then upgrade to latest.

DocDrydenn commented 1 week ago

That's it. Thanks!