Failing to migrate a foreign key from one model to another

Question

I have three models: assembly, configurator, and genus. I want to move a "genus" foreign key from the assembly model to the configurator model. I moved it in the python code, generated a migration, and but that fails utterly:

django.db.utils.OperationalError: (1025, "Error on rename of './isotek_intranet_django/aion_assembly' to './isotek_intranet_django/#sql2-848-19e5' (errno: 152)")

Which is like useful but not. My backend database is MariaDB. Here is the relevant bits of the migration:

operations = [
    migrations.RemoveField(
        model_name='assembly',
        name='genus',
    ),
    migrations.AddField(
        model_name='configurator',
        name='genus',
        field=models.ForeignKey(default=1, to='aion.Genus'),
    ),
]

What (and why) am I doing wrong?

Note that I can run my tests just fine. It is updating a currently existing database that fails.

Django is 1.8 release.

Wait, aren't the first two operations doing the exact same thing? — gbs, Oct 21 '15 at 13:12
Possibly. Removing the raw SQL does not change the error I get. There's a lot of stabbing in the dark... — Sardathrion - against SE abuse, Oct 21 '15 at 13:14
Which version of django are you running? There is the recently fixed [bug](https://code.djangoproject.com/ticket/22460) that you might be running into. — gbs, Oct 21 '15 at 13:31

score 1 · Accepted Answer · edited May 23 '17 at 11:52

1

You're possibly running into this bug. In this case it means that you'll have to delete the constraint before dropping the foreign key. As a short term fix you can try to do this manually by following this answer.

edited May 23 '17 at 11:52

Community

1
1

answered Oct 21 '15 at 13:36

gbs

1,255
13
12

Failing to migrate a foreign key from one model to another

1 Answers1