db migration fails

I'm deploying new rails applications. Everything works well except when it comes to the db migration:

* executing "cd /var/rails/benefits_test/releases/20101129190121 && /opt/ruby-enterprise-1.8.7-2010.02/bin/rake RAILS_ENV=production db:util:migrate" servers: ["ps-test-app1"] [ps-test-app1] executing command ** [out :: ps-test-app1] (in /filestore/rails/benefits_test/releases/20101129190121) *** [err :: ps-test-app1] rake aborted! *** [err :: ps-test-app1] getaddrinfo: Name or service not known *** [err :: ps-test-app1] *** [err :: ps-test-app1] (See full trace by running task with -- trace) command finished failed: "sh -c 'cd /var/rails/benefits_test/releases/20101129190121 && /opt/ruby-enterprise-1.8.7-2010.02/bin/rake RAILS_ENV=production db:util:migrate'" on ps-test-app1

When I manually run it with '--trace' I see nothing evident: [root@ps-test-app1 current]# rake RAILS_ENV=production db:migrate --trace (in /filestore/rails/benefits_test/releases/20101129190121) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment rake aborted! getaddrinfo: Name or service not known /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:861:in `initialize' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:861:in `open' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:861:in `open_server' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:759:in `open_server' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:757:in `each' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:757:in `open_server' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:1342:in `initialize' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:1630:in `new' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/drb/drb.rb:1630:in `start_service' /filestore/rails/benefits_test/releases/20101129190121/vendor/plugins/ backgroundrb/lib/backgroundrb.rb:11 /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in `gem_original_require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in `require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/ activesupport-2.3.5/lib/active_support/dependencies.rb:158:in `require' /filestore/rails/benefits_test/releases/20101129190121/vendor/plugins/ backgroundrb/init.rb:1:in `evaluate_init_rb' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin.rb:158:in `evaluate_init_rb' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/ activesupport-2.3.5/lib/active_support/core_ext/kernel/reporting.rb: 11:in `silence_warnings' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin.rb:154:in `evaluate_init_rb' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin.rb:48:in `load' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin/loader.rb:38:in `load_plugins' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin/loader.rb:37:in `each' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/rails/plugin/loader.rb:37:in `load_plugins' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/initializer.rb:369:in `load_plugins' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/initializer.rb:165:in `process' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/initializer.rb:113:in `send' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/initializer.rb:113:in `run' /filestore/rails/benefits_test/releases/20101129190121/config/ environment.rb:23 /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in `gem_original_require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in `require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/ activesupport-2.3.5/lib/active_support/dependencies.rb:156:in `require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/ activesupport-2.3.5/lib/active_support/dependencies.rb:521:in `new_constants_in' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/ activesupport-2.3.5/lib/active_support/dependencies.rb:156:in `require' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rails-2.3.5/ lib/tasks/misc.rake:4 /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:636:in `call' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:636:in `execute' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:631:in `each' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:631:in `execute' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:597:in `invoke_with_call_chain' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/monitor.rb:242:in `synchronize' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:590:in `invoke_with_call_chain' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:607:in `invoke_prerequisites' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:604:in `each' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:604:in `invoke_prerequisites' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:596:in `invoke_with_call_chain' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/1.8/monitor.rb:242:in `synchronize' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:590:in `invoke_with_call_chain' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:583:in `invoke' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2051:in `invoke_task' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2029:in `top_level' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2029:in `each' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2029:in `top_level' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2068:in `standard_exception_handling' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2023:in `top_level' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2001:in `run' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:2068:in `standard_exception_handling' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ lib/rake.rb:1998:in `run' /opt/ruby-enterprise-1.8.7-2010.02/lib/ruby/gems/1.8/gems/rake-0.8.7/ bin/rake:31 /opt/ruby-enterprise-1.8.7-2010.02/bin/rake:19:in `load' /opt/ruby-enterprise-1.8.7-2010.02/bin/rake:19

I can ping the db with no problems and I can also telnet to the db successfully from the app server:

[root@ps-test-app1 20101129190121]# telnet ps-test-db 3306 Trying 10.204.47.161... Connected to ps-test-db.localdomain (10.204.47.161). Escape character is '^]'. 4 5.1.33jSD7(_*2J\rJWW.~R\[                 ot packets out of orderConnection closed by foreign host.

I’m using the following “database.yml”:

production:   adapter: mysql   database: tsise_development   username: *user*   password: *pass*   host: ps-test-db   reconnect: true

Can someone please help me out?

Thanks, Franck

The db:migrate part is a red herring - the issue is that when Rails tries to load your environment, something in the BackgrounDRb config is blowing up. I'd suggest you check that to see what might be causing the problem...

--Matt Jones

Matt Jones wrote in post #965255: