Flame stopped working about flame HOT 7 CLOSED

Can you show listing of /app/data mounted volume?

from flame.

$ docker-compose run app ls -Al /app/data                                                                                                │
total 96                                                                                                                                                            │
-rwxr-xr-x    1 root     root         94208 Jun 25 02:00 db.sqlite                                                                                                  │
drwxr-xr-x    2 root     root          4096 Jun 25 02:05 uploads

from flame.

Are you getting the same error after restart?

from flame.

Yeah, I tried restarting multiple times and pulled the newest image as well.

from flame.

Here are a few things you can try. First copy db.sqlite and save it somewhere else outside mounted volume.

• You can disable model synchronization and check if it changes anything. Console into running container and run nano db.js. Change value of: const syncModels = false; to true, save file and restart the container.
• Open your database file with software like SQLiteStudio. Check how many tables you have. You should have 6 (apps, bookmarks, categories, config, weather, sqlite_sequence). If you have more you can try to drop them, save file and restart the container.
• The last option is to stop container, delete database file and run it again. App will create new file but all data will be gone. If you disabled synchronization you need to re-enable it before stopping container.

from flame.

from flame.

I just checked my sqlite db and I have two additional tables apps_backup and bookmarks_backup.
Deleted the two tables and everything is back up running.

Thanks for the help.

@gitcatpeter seems like a good suggestion. If flame cannot start because of a db-issue it could look if a backup exists and use that one.

from flame.