betweenGo

Recently I tried running my RoR applications on Oracle.

I noticed that when I ran rake db:migrate it would hang. Specifically it would hang during the schema dump phase.

E:\work\sandbox>rake db:migrate --trace -v
(in E:/work/sandbox)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump

I realized later that this was because the schema dump phase is very slow and the database I was using had many other tables from other applications. When I left it running it finally completed after 10 minutes.

You can see the slow progress of the schema dump phase by tailing schema.rb in the db directory.

Related posts:

1. ‘Error in my_thread_global_end()’ when running rake db:migrate
2. Deploying to Production Notes
3. Upgrading MeetingKoreans.com to Rails 1.2.6
4. Ruby on Rails and Oracle
5. You Used Ruby to Write WHAT?!