When Migrations Go Bad

Agile Web Development with Rails 5.1 — by Sam Ruby, David Bryant Copeland, with Dave Thomas (99 / 107)

👈 Advanced Migrations | TOC | Schema Manipulation Outside Migrations 👉

Migrations suffer from one serious problem. The underlying DDL statements that update the database schema are not transactional. This isn’t a failing in Rails — most databases just don’t support the rolling back of create table, alter table, and other DDL statements.

Let’s look at a migration that tries to add two tables to a database:

In the normal course of events, the up method adds tables, one and two, and the down method removes them.

But what happens if there’s a problem creating the second table? We’ll end up with a database containing table one but not table two. We can fix whatever the problem is in the migration, but now we can’t apply it — if we try, it will fail because table one already exists.

We could try to roll the migration back, but that won’t work. Because the original migration failed, the schema version in the database wasn’t updated, so Rails won’t try to roll it back.

At this point, you could mess around and manually change the schema information and drop table one. But it probably isn’t worth it. Our recommendation in these circumstances is simply to drop the entire database, re-create it, and apply migrations to bring it back up-to-date. You’ll have lost nothing, and you’ll know you have a consistent schema.

All this discussion suggests that migrations are dangerous to use on production databases. Should you run them? We really can’t say. If you have database administrators in your organization, it’ll be their call. If it’s up to you, you’ll have to weigh the risks. But, if you decide to go for it, you really must back up your database first. Then, you can apply the migrations by going to your application’s directory on the machine with the database role on your production servers and executing this command:

This is one of those times where the legal notice at the start of this book kicks in. We’re not liable if this deletes your data.

👈 Advanced Migrations | TOC | Schema Manipulation Outside Migrations 👉

Related posts:

Arduino is an open-source platform that makes DIY electronics projects easier than ever. Gone are the days when you had to learn electronics theory and arcane programming languages before you could even get an LED to blink. Now, with this new edition of the bestsellingArduino: A Quick-Start Guide, readers with no electronics exp

Female-focused weight loss programs are one of the most popular ways to get in shape. The key is to find successful workouts program that has workouts. That you enjoy and can stick with for the long…

In the age of masternode coins, there are those that do it well and those that do it not so well. There are many variables that can affect the health and life of a cryptocurrency and we would like to…