secondbase icon indicating copy to clipboard operation
secondbase copied to clipboard

On heroku we can't run migrations for second_db

Open misteral opened this issue 8 years ago • 5 comments

Rails: 4.2.3

Migration status stuck on this state and config: https://gist.github.com/misteral/a87538b1c66007d4d9ec322716884822

I can easy run migration from local comp after change development second db as production redshift second_db. How I can fix it?

misteral avatar May 22 '17 05:05 misteral

What error are you getting when trying to run migrations on heroku?

hmadison avatar May 22 '17 12:05 hmadison

No, errors. It run second_db_migrations on primary db. Look https://gist.github.com/misteral/a87538b1c66007d4d9ec322716884822#file-gistfile1-txt-L791

misteral avatar May 22 '17 13:05 misteral

This looks like a db:migrate:status command. We do not have any support for that command. So the report would not be accurate. Would this be a fair assessment?

metaskills avatar Jul 11 '17 01:07 metaskills

@metaskills this is db:migrate:status command listed as a prof what system incorrectly take primary db as secondary db (db name is the same), but database.yml has corrected config, it work in started rails app. Make sense?

misteral avatar Jul 11 '17 09:07 misteral

Thanks, it does make sense but at the same time does not help. Can you share the output of a Heroku command that does something wrong and/or investigate what is happening? I can't tell from the logs you are sharing nor can I think of any reason it wold work locally vs on any remote server. Unless that remote server has some ENV that changes behavior I am unfamiliar with. Anything you can provide to debug more would be helpful.

metaskills avatar Jul 11 '17 11:07 metaskills