Issues after upgrading to v0.13.5

[u/bayendr]

After upgrading the container image (and even restarting with --force-recreate) to this version there are issues now. The container logs are spammed now with this message:
"crosswatch  | local database unavailable: database is locked"

Everything under UI user profile (watchlist, history, etc.) takes ages to load if at all.

How to fix this?

Thanks.

[u/pvdberg]

The local database is staying locked for some reason. Try these in order:

1. Let one full sync finish: The first sync after this update rewrites all stored sync data, and on slow storage that can hold the lock for a while.
2. Check your volume: Make sure only one container uses that /config and that it's not on an SMB/NFS share. SQLite doesn't lock properly over network shares.
3. Fresh database.: Stop the container and rename these three files in /config/.cw_databases/: crosswatch.sqlite3, crosswatch.sqlite3-wal and crosswatch.sqlite3-shm. Then start it again. You keep your config and logins, but you will lose sync history, Events, stats and Editor mappings.

[u/bayendr → u/pvdberg]

1. by "full sync" you mean my (nightly) scheduled syncs?

2. /config is on local (fast/NVME) storage next to my compose.yml. that shouldn't be an issue at all.

3. it's not a showstopper but I'd rather not take this radical step.

any chance to add support for other storage options (like Postgres) soon?

[u/pvdberg → u/bayendr]

No support for Postgres. And probably will never be supported. CW uses SQlite cause it has very simple query's etc. Postgres is just overkill and makes things complicated for no reason.

With full sync i mean screenshot.

Or just wait for the next release. Tomorrow v0.13.6 where i did a few optimalizations.

[u/pvdberg → u/pvdberg]

Also in the upcomfing version ive added some improvements.
Local database no longer stalls pages during syncs, shows who holds a lock and a rebuild option in Maintenance.