dim.db no longer writable after creating admin account

[donmor]

Describe the bug dim.db get locked and was no longer writable after creating admin account.

To Reproduce Steps to reproduce the behavior:

1. Build dim from latest source (patched by #597)
2. Run dim and create the admin account
3. Add a library
4. See ERROR request{method=POST uri=/api/v1/library version=HTTP/1.1}: dim_web::routes::library: Error committing transaction err=Database(SqliteError { code: 5, message: "database is locked" }) in console

Device and browser including versions: Chromium 102.0.5005.63 (on Linux / loongarch64 PC)

Additional context Any operation writing the database gets a 500 response; creating accounts gets 401. I built dim with this fork(#597), this may affect the behavior of program.

[vgarleanu]

Does the lock occur on the latest master? First time seeing this issue and the scanner/dB code hasn't been modified in a long time.

[donmor]

Not sure... Now trying #593 to see if it works

[vgarleanu]

Not sure... Now trying #593 to see if it works

Please try latest master

[donmor]

I'm using loongarch64 (yet another new risc architecture) and latest master failed to build here because of the aged ring 0.16.20 dep (⊙_⊙;) So I have to use code from PRs with sqlx bumped to 0.7.x and patch it again to use nix 0.27+.

[donmor]

Okay it IS sqlx 0.7 patches that breaks the db XD Moving to #593 and #597

[donmor]

BTW I commented out use crate::inspect::ResultExt; in dim-core/src/scanner/movie.rs and dim-core/src/scanner/tv_show.rs as they throw errors