search

anjlab / rails-data-migrations

Run your data migration scripts like a master
MIT License
124 stars 15 forks source link

Issue with `data:migrate:down` Rake-task #14

Open andrykonchin opened 2 years ago

andrykonchin commented 2 years ago

Hi, I have noticed that there is a problem with rolling back a data migration.

Scenario:

Expected result - a migration is applied without errors Actual result - a migration is applied but it fails with error SQLite3::ConstraintException: UNIQUE constraint failed: data_migrations.version.

As far as I understand Rake-task data:migrate:down should remove a version of the rolled-back migration in the data_migrations table. But it doesn't. That's why when this migration is applied again and data:migrate:up tries to add a new row in the data_migrations table - conflicts with the unique constraint and fails.

xhuberdeau commented 2 years ago

Hi,

I've got the same problem there.

@andrykonchin, did you find a solution to your issue?

andrykonchin commented 2 years ago

Nope. The only solution is to fix the bug. It looks trivial.