database resets when changing docker compose

[edwin-nz]

Describe the bug
Have a working system using the documented docker compose and image: bpatrik/pigallery2:latest

After making a change to the env setting below, it lost all the users setup. The system reverted to default admin:admin but kept my previous server config settings.

environment:
  - NODE_ENV=production 

The docker-compose uses docker volume for the db as per the documented docker compose below so it should be persistent and that is the correct behaviour when I restart the container. Suspect a bug is resetting the SQLite database when the docker compose is changed.

volumes:
db-data:

[edwin-nz]

I've now switched to mysql which does not have the above problem.

[bpatrik]

that looks odd, but very hard to debug from these info.