Database error

[mrm]

So, there are two issues here:

1. The error is cryptic. For background, I use the Heartbeat table to verify that database reads and writes work. Version 1 didn’t wrap this error properly with a “hey, I can’t write to your database, is that filesystem OK?”. I fixed this in v2 (which is still in alpha).

   What version of PhotoStructure are you running? (You can see this in the “about” page)

2. The underlying disk I/O problem–if you’re running docker, I actually recommend you use the :alpha build–there are a ton of bugfixes and new feature in v2.1. I suspect the error is coming from a bug in v1.1’s handling of database replicas–more details are here:

What's PS_FORCE_LOCAL_DB_REPLICA?

PhotoStructure + SQLite = PhotoStructure uses SQLite to store your PhotoStructure library metadata and to manage synchronization state. [image] SQLite is an open source, embedded, and extremely popular database engine. If PhotoStructure for Desktops used a different database engine (say, PostgreSQL), the installer would need to be 2-4x larger than it is currently (~100Mb), and memory requirements would increase as well. SQLite + remote filesystems = One sma…

(TL;DR: if your library is on a local disk, set PS_FORCE_LOCAL_DB_REPLICA=false in your docker container configuration)