I’ve ran into this problem the other day – after running
cap production deploy:migrations the
cap output had stuck on running the migrations step. Before calling Chip and Dale, I decided to take a closer look at what was going on.
To understand why my deploy stuck on attempt to run migrations, I logged into server with production database and ran:
$ psql my_production_database -c "SELECT datname,procpid,current_query FROM pg_stat_activity;" datname | procpid | current_query -----------------------+---------+------------------------------------------------------------- my_production_database | 10312 | <IDLE> my_production_database | 12345 | COPY select * from some_really_big_table ... TO STDOUT; my_production_database | 54321 | <line_from_one_of_my_rails_migrations> my_production_database | 14123 | SELECT datname,procpid,current_query FROM pg_stat_activity;
I immediately spotted something curious with:
COPY select * from some_really_big_table ... TO STDOUT;`
Why is it even being run during migrations? Clearly, this line had nothing to do with my migrations.
... TO STDOUT;? Turns out this: at the moment of running the first of my migrations, the database backup was still running, triggered by cron!
0 15 * * * pg_dump my_production_database | gzip /home/my_project/my_production_database_backup.sql.gz
Apparently there were two ways out.
1. Wait until backup finishes
This would be much more preferable way of resolving the issue, yet not for me. In my case a regular backup is 20Gb (8Gb compressed), and, what was even more depressing the backup process was at it’s very early stage. In order to approximately find out current progress of a backup, one may go with two options:
- if you already know the approx. timeframe the backup generation finishes within, calculate current running time by subtracting current servers time from the time the backup starts (inspect
crontab -lfor that)
- if you don’t know the approx. time, but you have your server under a New Relic (or similar service) provisioning, you can see how long the backup was taking starting yesterday.
2. Kill the backup process
In my case, the backup finished in approx. 5 hours, and it was running for only an hour by the time I was investigating the problem. So here’s what I did:
kill the backup process (it will make the
capcommand finish with failure, but that’s ok):
$ sudo kill -9 12345
go to the folder, where capistrano keeps all the project releases. For me it was:
refresh the symlink (this is usually done by capistrano itself, yet now we have to do it manually, since cap command finished with a failure):
ln -s /var/projects/my_project/releases/20130613155542/ current
move inside the
check the status of migrations, that ran so far (optional):
RAILS_ENV=production rake db:migrate:status
run the migrations:
RAILS_ENV=production rake db:migrate
restart the application:
All done now! Of course, the rule of thumb should be: do not deploy while having DB backup in progress.