Data disappearing from SQLite after a machine restarts

Questions / Help
,
1

New to fly.io so sorry if this is a silly question!

I’m trying to deploy a discord bot that uses sqlite3. I’ve set up a volume attached to the machine (only one machine is used so that I wouldn’t have to worry about synchronizing DB on different volumes) and added this to my fly.toml:

[mounts]
  source = "vol"
  destination = "/data"

When I use a command of my discord bot to modify data saved in the DB, and then use another command that returns the modified data, they both worked just fine. The problem is, whenever the machine restarts, the data that were modified with bot commands would just revert back to the values assigned to them when I first created the volume.

I’ve tested the bot locally before deploying, and the data have always persisted (as they should) even if I restart the bot a few times, so I guess I missed something while setting up the volume.

2

You are probably not pointing to /data/.../something.db in your sqlite client.

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.