9116 2016-02-15 11:52:31 +0000 migrations fail to apply on mysql 2016-03-01 13:52:03 +0000 1 1 7 Build System, Metadata & Runtime Toaster toaster 2.1 x86 Multiple VERIFIED FIXED Medium+ major 2.1 M3 1 michael.g.wood michael.g.wood belen.barros.pena brian.avery jessica.zhang stanciux.mihail stanciux.mihail --- --- Yes (doc changes required) oldest_to_newest 59000 0 michael.g.wood 2016-02-15 11:52:31 +0000 Currently the migrations fail to apply on mysql django.db.utils.OperationalError: (1829, "Cannot drop column 'id': needed in a foreign key constraint 'D1a8c915f90ee0694e71f27b384a7341' of table 'toaster.orm_customimagerecipe_packages'") This is because of mysql doesn't support being able to drop a primary key which is currently 'in use'. orm.0002_auto_20151210_1209 We may need to detect if we're using mysql and do a slightly different migration. 59093 1 michael.g.wood 2016-02-16 10:59:06 +0000 After investigation we have no choice other than to reset migrations I've tried adding an intermediate migration which drops the CustomImageRecipe table and recreates it but this hits a Django bug https://code.djangoproject.com/ticket/24225 I've also tried renaming it and various combinations of removing all the fields which hold the foreign key relationship and then re-creating them with the corrected relationships. We also have a slightly broken migration tree with two migrations 0002 that depend on the initial migration. 59136 2 brian.avery 2016-02-17 03:55:34 +0000 If I have a toaster.sqlite from jethro, these migrations break on the existing jethro database. If so, we will need to spell out in the docs that in order to take advantage of the new image customization feature users will need to start with a fresh db. 59530 3 michael.g.wood 2016-02-29 14:59:27 +0000 http://git.yoctoproject.org/cgit/cgit.cgi/poky/commit/?id=8469e5802590551dbf88a26539b9cfe5710c074d (Bitbake rev: 19bd63fc3a28dcbd0f531a5b06a037da34568bac) 59580 4 stanciux.mihail 2016-03-01 13:52:03 +0000 Verified while setting up MySQL instance for GDC.