capistrano hangs

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,

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: