tim-schilling/CharacterService — Issue #4: Can't deploy column drop migrations to EngineYard
Author: tim-schilling
Created: 2012-01-11 02:54:08+00:00
State: open

https://cloud.engineyard.com/apps/20072/environments/31008/deployments/464911

ODE_ENV=production MERB_ENV=production rake db:migrate'\'
== CreateCharacters: migrating ===============================================
-- create_table(:characters)
-> 0.0175s
== CreateCharacters: migrated (0.0176s) ======================================

== CreateQualities: migrating ================================================
-- create_table(:qualities)
-> 0.0176s
-- add_index(:qualities, :character_id)
-> 0.0248s
== CreateQualities: migrated (0.0425s) =======================================

== CreateVotes: migrating ====================================================
-- create_table(:votes)
-> 0.0175s
-- add_index(:votes, :character_id)
-> 0.0247s
== CreateVotes: migrated (0.0422s) ===========================================

== CharacterId: migrating ====================================================
-- remove_column(:characters, :characterId)
:: running ssh -i /home/deploy/.ssh/internal -o StrictHostKeyChecking=no -o PasswordAuthentication=no deploy@ec2-107-21-254-76.compute-1.amazonaws.com 'sudo sh -l -c '\''rm -rf /data/characterservice/releases/20120111024006'\'
~> [Attention] Maintenance page still up, consider the following before removing:
* Deploy hooks ran. This might cause problems for reverting to old code.
* Migrations ran. This might cause problems for reverting to old code.
* Your old code is still symlinked as current.

~> Need help? File a ticket for support.

rake aborted!
An error has occurred, all later migrations canceled:

Mysql2::Error: Can't DROP 'characterId'; check that column/key exists: ALTER TABLE `characters` DROP `characterId`

Tasks: TOP => db:migrate
(See full trace by running task with --trace)