For the second time my N8N has crashed and reverted back 30 days

My self-hosted version crashed last night and restarted as if it were the 15th of December. The backup on Digital Ocean shows the size dropped 4GB overnight. When i restore that to another droplet - it doesn’t remember the subdomain, and doesn’t have the workflows (even though the size showed it to be greater) - any ideas?

@Andrew_Hastie are you using SQLite as your database?

You can check for Workflows using the sqlite3 command line tool to open the database and see if any workflow records exist:
sqlite3 /path/to/snapshot/database.sqlite "SELECT id, name FROM workflow_entity;"
If this command returns a list, your workflows are still in the file.

1 Like

Yes - I am using sqlite, the system was fine until a crash at 3am on the 14th Jan, when it restarted all of the worflows and logs had gone back to Dec 15th. Even restoring the digital ocean backup from the 13th to a new droplet (when it was all good) only returned the same Dec 15th data