Db migration fails

Rails
1

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:inopen’
/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:inopen_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:inopen_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:innew’
/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:ingem_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:inrequire’
/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:inevaluate_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:inevaluate_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:inload_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:inload_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:inprocess’
/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:inrun’
/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:inrequire’
/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:innew_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:incall’
/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:ineach’
/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:ininvoke_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:ininvoke_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:ineach’
/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:ininvoke_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:ininvoke_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:ininvoke_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:ineach’
/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:instandard_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:inrun’
/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:inrun’
/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.

Im 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

2

On Nov 30, 3:10pm, Franck [email protected] wrote:

*** [err :: ps-test-app1] rake aborted!
[root@ps-test-app1 current]# rake RAILS_ENV=production db:migrate
open' /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

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 J.

3

Matt J. wrote in post #965255:

On Nov 30, 3:10pm, Franck [email protected] wrote:

*** [err :: ps-test-app1] rake aborted!
[root@ps-test-app1 current]# rake RAILS_ENV=production db:migrate
open' /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

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 J.

Matt,

Thank you for your response. You are exactly right, I traced it to
that. I fixed it by verifying the information in the backgroundrb.yml
file.

-Franck