Django: sudden DB reset after Heroku sleep

by

Heroku dynos have an ephemeral filesystem (https://devcenter.heroku.com/articles/dynos#ephemeral-filesystem). Since you are using SQLite which is actually a file on the filesystem, everything will run smoothly until the dyno running your application needs to restart – so its filesystem will be reset and you’ll lose everything !

To avoid it just configure your application to use Heroku-Postgresql.

More Related Contents:

  1. Django: Deploying an application on Heroku with sqlite3 as the database
  2. H14 error in heroku – “no web processes running”
  3. OperationalError: database is locked
  4. How can I modify Procfile to run Gunicorn process in a non-standard folder on Heroku?
  5. No web processes running Django in heroku
  6. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  7. Command not found: django-admin.py
  8. gunicorn command not found, but it’s in my requirements.txt
  9. Heroku fails to install pywin32 library
  10. “no such table” exception
  11. sqlite3.OperationalError: unable to open database file
  12. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  13. Django staticfiles not found on Heroku (with whitenoise)
  14. How to upgrade sqlite 3.8.2 to >= 3.8.3
  15. Heroku: ModuleNotFoundError :No module named ‘requests’
  16. django makemigrations and migrate on heroku server don’t create tables
  17. No web processes running Error – Deploying Django on Heroku
  18. Deploying Django to Heroku (Psycopg2 Error)
  19. Collectstatic error while deploying Django app to Heroku
  20. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip [duplicate]
  21. Pillow installed, but getting “no module named pillow”
  22. How to query as GROUP BY in django?
  23. In Django, how does one filter a QuerySet with dynamic field lookups?
  24. How to read datetime back from sqlite as a datetime instead of string in Python?
  25. Is this the way to validate Django model fields?
  26. Django: signal when user logs in?
  27. Bulk insert huge data into SQLite using Python
  28. Can one use the Django database layer outside of Django?
  29. The view didn’t return an HttpResponse object. It returned None instead
  30. CSRF Token missing or incorrect

Leave a Comment