capistrano hangs

rubyonrails-talk
1

Any idea why this command takes upwards of 15 minutes to complete?

run "cd #{release_path} && ORACLE_HOME=/home/oracle RAILS_ENV=production rake db:migrate"

When running it against my local Postgres it completes in a few seconds or so. Running it against my local Oracle XE takes only slightly longer. But running it with capistrano over ssh is taking years away from my life. :frowning:

Thanks,

2

Hi Greg

How big is your production database? If you ssh in and run the command by hand is it still slow? If you are changing an existing table against a running app it may be waiting for a lock - this happens with MySQL too.

HTH

Greg Donald wrote: