I have an Rails 2.3.10 app deployed to heroku running in a non- production environment. I recent setup delayed job and have been in the process of trying to deploy to heroku but keep getting a database error (see below). I've ran the migration manually using: heroku rake db:migrate and heroku rake db:migrate RAILS_ENV='uat' but as you can see I still get an error.
I think that Heroku is not putting the correct env entry in the database.yml but am not sure how to check the file. The app was successfully deployed in the past but was not using heroku's postgres db (mostly simpldb stuff and webservices) Help please. Thanks Josh rake aborted! PGError: ERROR: relation "delayed_jobs" does not exist : UPDATE "delayed_jobs" SET locked_by = null, locked_at = null WHERE (locked_by = 'host:railgun64.46004 pid:4296') /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/ abstract_adapter.rb:227:in `rescue in log' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/ abstract_adapter.rb:204:in `log' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/rpm/lib/ new_relic/agent/instrumentation/active_record_instrumentation.rb:65:in `block in log_with_newrelic_instrumentation' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/rpm/lib/ new_relic/agent/method_tracer.rb:141:in `trace_execution_scoped' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/rpm/lib/ new_relic/agent/instrumentation/active_record_instrumentation.rb:62:in `log_with_newrelic_instrumentation' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/ postgresql_adapter.rb:520:in `execute' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/abstract/ database_statements.rb:265:in `update_sql' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/ postgresql_adapter.rb:531:in `update_sql' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/abstract/ database_statements.rb:49:in `update' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/connection_adapters/abstract/ query_cache.rb:19:in `update_with_query_dirty' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/.gems/gems/ activerecord-2.3.10/lib/active_record/base.rb:851:in `update_all' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/ delayed_job/lib/delayed/backend/active_record.rb:39:in `clear_locks!' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/ delayed_job/lib/delayed/worker.rb:97:in `ensure in start' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/ delayed_job/lib/delayed/worker.rb:97:in `start' /home/app/462ddd02-57d5-4ea2-b0dd-39dc965d903e/vendor/plugins/ delayed_job/lib/delayed/tasks.rb:13:in `block (2 levels) in <top (required)>' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:634:in `call' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:634:in `block in execute' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:629:in `each' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:629:in `execute' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:595:in `block in invoke_with_call_chain' /usr/ruby1.9.2/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:581:in `invoke' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2041:in `invoke_task' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `block (2 levels) in top_level' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `each' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `block in top_level' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:2013:in `top_level' /usr/ruby1.9.2/lib/ruby/1.9.1/rake.rb:1992:in `run' /usr/ruby1.9.2/bin/rake:31:in `<main>' -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
