cuny-nytech/persist — pull request #8 by bcavallo (2014-11-03 21:07:23+00:00)
Title: Story posting site - not up on Heroku

Hi, This app allows you to post simple stories about train rides. The app works locally, but on heroku I just get a screen saying "Internal Server Error"

Here are my log files:
2014-11-03T20:38:52.306059+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
2014-11-03T20:38:52.306061+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
2014-11-03T20:38:52.306066+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/relation.rb:611:in `exec_queries'
2014-11-03T20:38:52.306090+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/tilt-1.4.1/lib/tilt/template.rb:103:in `render'
2014-11-03T20:38:52.306082+00:00 app[web.1]:	/app/views/home.erb:65531:in `instance_eval'
2014-11-03T20:38:52.306091+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:814:in `render'
2014-11-03T20:38:52.306067+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/relation.rb:493:in `load'
2014-11-03T20:38:52.306092+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:665:in `erb'
2014-11-03T20:38:52.306069+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/relation.rb:238:in `to_a'
2014-11-03T20:38:52.306094+00:00 app[web.1]:	trains.rb:24:in `block in

'
2014-11-03T20:38:52.306088+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/tilt-1.4.1/lib/tilt/template.rb:170:in `evaluate'
2014-11-03T20:38:52.306079+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/relation/delegation.rb:46:in `each'
2014-11-03T20:38:52.306096+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1603:in `call'
2014-11-03T20:38:52.306084+00:00 app[web.1]:	/app/views/home.erb:65531:in `singletonclass'
2014-11-03T20:38:52.306097+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1603:in `block in compile!'
2014-11-03T20:38:52.306087+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/tilt-1.4.1/lib/tilt/template.rb:170:in `call'
2014-11-03T20:38:52.306098+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:966:in `[]'
2014-11-03T20:38:52.306081+00:00 app[web.1]:	/app/views/home.erb:2:in `block in singletonclass'
2014-11-03T20:38:52.306085+00:00 app[web.1]:	/app/views/home.erb:65529:in `__tilt_16989360'
2014-11-03T20:38:52.306106+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:966:in `block (3 levels) in route!'
2014-11-03T20:38:52.306115+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:964:in `block in route!'
2014-11-03T20:38:52.306109+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:966:in `block (2 levels) in route!'
2014-11-03T20:38:52.306112+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1004:in `catch'
2014-11-03T20:38:52.306116+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:963:in `each'
2014-11-03T20:38:52.306108+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:985:in `route_eval'
2014-11-03T20:38:52.306110+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1006:in `block in process_route'
2014-11-03T20:38:52.306113+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1004:in `process_route'
2014-11-03T20:38:52.306119+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1076:in `block in dispatch!'
2014-11-03T20:38:52.306122+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `catch'
2014-11-03T20:38:52.306124+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `invoke'
2014-11-03T20:38:52.306126+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1073:in `dispatch!'
2014-11-03T20:38:52.306133+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:898:in `call!'
2014-11-03T20:38:52.306134+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:886:in `call'
2014-11-03T20:38:52.306147+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in `call'
2014-11-03T20:38:52.306149+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2014-11-03T20:38:52.306118+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:963:in `route!'
2014-11-03T20:38:52.306150+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2014-11-03T20:38:52.306127+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:898:in `block in call!'
2014-11-03T20:38:52.306151+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in `call'
2014-11-03T20:38:52.306121+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `block in invoke'
2014-11-03T20:38:52.306154+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2014-11-03T20:38:52.306128+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `block in invoke'
2014-11-03T20:38:52.306155+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2014-11-03T20:38:52.306130+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `catch'
2014-11-03T20:38:52.306131+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1058:in `invoke'
2014-11-03T20:38:52.306152+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in `call'
2014-11-03T20:38:52.306156+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in `call'
2014-11-03T20:38:52.306157+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/session/abstract/id.rb:225:in `context'
2014-11-03T20:38:52.306159+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/session/abstract/id.rb:220:in `call'
2014-11-03T20:38:52.306161+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/commonlogger.rb:33:in `call'
2014-11-03T20:38:52.306163+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:217:in `call'
2014-11-03T20:38:52.306160+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/logger.rb:15:in `call'
2014-11-03T20:38:52.306164+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:210:in `call'
2014-11-03T20:38:52.306167+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/methodo
verride.rb:21:in `call'
2014-11-03T20:38:52.306165+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/head.rb:11:in `call'
2014-11-03T20:38:52.306168+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:180:in `call'
2014-11-03T20:38:52.306177+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:2014:in `call'
2014-11-03T20:38:52.306179+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1478:in `block in call'
2014-11-03T20:38:52.306190+00:00 app[web.1]:	/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread'
2014-11-03T20:38:52.306184+00:00 app[web.1]:	/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service'
2014-11-03T20:38:52.306186+00:00 app[web.1]:	/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run'
2014-11-03T20:38:52.306180+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1788:in `synchronize'
2014-11-03T20:38:52.306182+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/sinatra-1.4.5/lib/sinatra/base.rb:1478:in `call'
2014-11-03T20:38:52.306183+00:00 app[web.1]:	/app/vendor/bundle/ruby/1.9.1/gems/rack-1.5.2/lib/rack/handler/webrick.rb:60:in `service'
2014-11-03T20:38:52.306597+00:00 app[web.1]: 54.197.214.5 - - [03/Nov/2014 20:38:52] "GET / HTTP/1.1" 500 30 0.0025
2014-11-03T
20:49:50.152879+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate:redo VERSION=20141026171349` by brencavallo@gmail.com
2014-11-03T20:49:52.706835+00:00 heroku[run.6923]: Awaiting client
2014-11-03T20:49:52.742487+00:00 heroku[run.6923]: Starting process with command `bundle exec rake db:migrate:redo VERSION=20141026171349`
2014-11-03T20:49:53.063815+00:00 heroku[run.6923]: State changed from starting to up
2014-11-03T20:49:55.104091+00:00 heroku[run.6923]: Process exited with status 1
2014-11-03T20:49:55.113150+00:00 heroku[run.6923]: State changed from up to complete
2014-11-03T20:50:59.047956+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate` by brencavallo@gmail.com
2014-11-03T20:51:03.608689+00:00 heroku[run.3062]: Starting process with command `bundle exec rake db:migrate`
2014-11-03T20:51:03.554584+00:00 heroku[run.3062]: Awaiting client
2014-11-03T20:51:03.869764+00:00 heroku[run.3062]: State changed from starting to up
2014-11-03T20:51:07.677050+00:00 heroku[run.3062]: Process exited with status 1
2014-11-03T20:51:07.688334+00:00 heroku[run.3062]: State changed from up to complete
2014-11-03T20:51:46.939581+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349` by brencavallo@gmail.com
2014-11-03T20:51:50.074365+00:00 heroku[run.3457]: Awaiting client
2014-11-03T20:51:50.124797+00:00 heroku[run.3457]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349`
2014-11-03T20:51:50.710973+00:00 heroku[run.3457]: State changed from starting to up
2014-11-03T20:51:54.551570+00:00 heroku[run.3457]: Process exited with status 1
2014-11-03T20:51:54.561121+00:00 heroku[run.3457]: State changed from up to complete
2014-11-03T20:52:00.461294+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349 --trace` by brencavallo@gmail.com
2014-11-03T20:52:03.570997+00:00 heroku[run.8009]: Awaiting client
2014-11-03T20:52:03.602059+00:00 heroku[run.8009]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349 --trace`
2014-11-03T20:52:03.904133+00:00 heroku[run.8009]: State changed from starting to up
2014-11-03T20:52:06.049325+00:00 heroku[run.8009]: Process exited with status 1
2014-11-03T20:52:06.059124+00:00 heroku[run.8009]: State changed from up to complete
2014-11-03T20:57:22.750014+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349` by brencavallo@gmail.com
2014-11-03T20:57:26.370404+00:00 heroku[run.1462]: Awaiting client
2014-11-03T20:57:26.407889+00:00 heroku[run.1462]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349`
2014-11-03T20:57:26.625131+00:00 heroku[run.1462]: State changed from starting to up
2014-11-03T20:57:30.406480+00:00 heroku[run.1462]: State changed from up to complete
2014-11-03T20:57:30.395525+00:00 heroku[run.1462]: Process exited with status 1
2014-11-03T21:00:45.538267+00:00 heroku[api]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349 --trace` by brencavallo@gmail.com
2014-11-03T21:00:50.869110+00:00 heroku[run.9467]: Starting process with command `bundle exec rake db:migrate VERSION=20141026171349 --trace`
2014-11-03T21:00:50.837519+00:00 heroku[run.9467]: Awaiting client
2014-11-03T21:00:51.265567+00:00 heroku[run.9467]: State changed from starting to up
2014-11-03T21:00:53.501754+00:00 heroku[run.9467]: Process exited with status 1
2014-11-03T21:00:53.517840+00:00 heroku[run.9467]: State changed from up to complete

It seems like the issue most likely is with db:migrate. If I do heroku run rake db:migrate --trace, I get:

Running `rake db:migrate --trace` attached to terminal... up, run.3665
** Invoke db:migrate (first_time)
** Invoke db:environment (first_time)
** Execute db:environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
rake aborted!
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `initialize'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `new'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/connection_handling.rb:87:in `connection'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/migration.rb:909:in `initialize'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/migration.rb:807:in `new'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/migration.rb:807:in `up'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/migration.rb:785:in `migrate'
/app/vendor/bundle/ruby/1.9.1/gems/activerecord-4.1.7/lib/active_record/railties/databases.rake:34:in `block (2 levels) in '
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:205:in `call'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:205:in `block in execute'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:200:in `each'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:200:in `execute'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:158:in `block in invoke_with_call_chain'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:151:in `invoke_with_call_chain'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/task.rb:144:in `invoke'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:116:in `invoke_task'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:94:in `block (2 levels) in top_level'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:94:in `each'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:94:in `block in top_level'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:88:in `top_level'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:66:in `block in run'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling'
/app/vendor/ruby-1.9.3/lib/ruby/1.9.1/rake/application.rb:63:in `run'
/app/bin/rake:38:in `

'
Tasks: TOP => db:migrate

So for some reason it seems like it's not recognizing files. I've spent a while online and nothing at all seems to be working. It may end up working before class, but not likely. Otherwise I'll ask about it after class.