Can you invoke a remote shell into your Heroku dyno?
heroku run -a your_app iex -S mix, I think. From there, you can try this:
System.get_env("DATABASE_URL")
And see what’s wrong.
dimitarvp
0
tenzil
I got this when i ran above command, this error " (RuntimeError) connect raised KeyError exception:" was raised 20 + times before terminating the process.
18:09:36.334 [error] GenServer #PID<0.458.0> terminating
** (RuntimeError) connect raised KeyError exception: key :database not found. The exception details are hidden, as they may contain sensitive data such as database credentials. You may set :show_sensitive_data_on_connection_error to true when starting your connection if you wish to see all of the details
(elixir) lib/keyword.ex:393: Keyword.fetch!/2
(postgrex) lib/postgrex/protocol.ex:92: Postgrex.Protocol.connect/1
(db_connection) lib/db_connection/connection.ex:69: DBConnection.Connection.connect/2
(connection) lib/connection.ex:622: Connection.enter_connect/5
(stdlib) proc_lib.erl:249: :proc_lib.init_p_do_apply/3
Last message: nil
18:09:36.338 [info] Application myapp exited: shutdown
iex(1)> {"Kernel pid terminated",application_controller,"{application_terminated,myapp,shutdown}"}
Kernel pid terminated (application_controller) ({application_terminated,myapp,shutdown})
Crash dump is being written to: erl_crash.dump...done
Thanks @dimitarvp, i appreciate your help 
0
dimitarvp
At this point I recommend you generate a new Phoenix project with mix and using the proper switches (namely you want an Ecto Repo, use the same module and app name as your current project etc.) and then just search for the differences between your project and the freshly generated one.
0
dimitarvp
BTW, do you also have this in your config file?
config :myapp, ecto_repos: [MyApp.Repo]
Additionally, have you tried actually adding the database key?
config :MyApp, MyApp.Repo,
adapter: Ecto.Adapters.Postgres,
pool_size: String.to_integer(System.get_env("POOL_SIZE") || "5"),
ssl: true,
url: System.get_env("DATABASE_URL"),
show_sensitive_data_on_connection_error: true,
+ database: "your_db_name_here"
0
NobbZ
How do you deploy? And have you updated your config from Mix.Config to Config, and especially have you done that consequently for all files in config?
0
tenzil
As its an heroku app, i just do
git push heroku master this does the trick.
And @dimitarvp, i haven’t tried that database: "your_db_name_here"
1
dimitarvp
I should have recommended that earlier, but I assumed you had it somewhere.
Basically, you can’t go without that. You need a database name in which your app to persist stuff! 
1
NobbZ
That does not answer any of my questions…
Does your buildpack use releases or mix phx.server?
Have you properly updated your config files for 1.9?
0
tenzil
NobbZ
Okay, one question answered, last one was if you have properly updated the config into the new format.
It won’t work when you mixed things up. Either fully use 1.8 syntax or 1.9.
0