Rails 4.2 migration error but no rollback

Question

I have a migration with many remove_column.

I start it, but there is an error :

-- remove_column(:responses, :text_fr)
-> 0.5544s
-- remove_column(:responses, :text_en)
-> 0.2906s
-- remove_column(:topics, :text_fr)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Can't DROP 'text_fr'; check that column/key exists

It's my fault because I don't give the good name of column.

But my problem is : there is no automatic rollback !

I have fix the name of column in migration file, but now it's not working because text_fr don't exist in responses table...

I remember before, when an error occur, there was a rollback as if migration had not occurred...

So how enable auto-rollback of migrations?

I'm using mysql2 gem.

@emaillenin there is no solution since for this case? – Matrix Sep 15 '15 at 16:16 — Matrix, Sep 15 '15 at 16:16

score 1 · Accepted Answer · edited May 23 '17 at 10:27

1

Since MySQL does not support transaction, implement up and down methods for your migrations.

edited May 23 '17 at 10:27

Community

1
1

answered Sep 15 '15 at 16:18

Raj

22,346
14
99
142

Why rails don't do it automaticly (when it's possible)? Like "remove_column" => "add_column" ... – Matrix Sep 15 '15 at 16:31
yes, you should do `rake db:rollback` to do that – Raj Sep 15 '15 at 16:44

Rails 4.2 migration error but no rollback

1 Answers1