Please disregard. I reset the db, re-ran the migrations and all is good. On Dec 21, 4:25 pm, joshmckin <[email protected]> wrote: > 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.
