-
-
Notifications
You must be signed in to change notification settings - Fork 486
heroku row limit exceeded
compwron edited this page Sep 21, 2022
·
6 revisions
Heroku gets mad if we have too much in our database. You will get an email (if you have heroku access)
The most likely culprit is the versions
table, which isn't (yet) wiped when we re-seed (but it should be, whups)
heroku run rails c --app casa-qa
PaperTrail::Version.delete_all
heroku run rails c --app casa-r4g-staging
Do NOT do this in prod.
If we need to upgrade the database to allow more rows, do something like this:
heroku addons:create heroku-postgresql:hobby-basic --app casa-production
heroku maintenance:on --app casa-production
heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_ROSE_URL --app casa-production
heroku pg:promote HEROKU_POSTGRESQL_ROSE --app casa-production
heroku maintenance:off --app casa-production