Search code examples
djangodjango-southdjango-syncdb

Getting error with SOUTH and django migration

I got this error while migrating Sentry app in django. I am using mysql

 ! Since you have a database that does not support running
 ! schema-altering statements in transactions, we have had
 ! to leave it in an interim state between migrations.

! You *might* be able to recover with:   = DROP TABLE `sentry_groupedmessage` CASCADE; []
   = DROP TABLE `sentry_message` CASCADE; []

what should i do

Solution

  • Your problem is that the migration failed, and MySQL does not have support for Transactions, so South doesn't know in which state the tables are in.

    The only way how you can recover it from this point is:

    • Inspect the tables and check in which state of the migration they are (which columns changed etc)
    • Backup both tables (Dump them out)
    • Delete the tables.
    • Recreate the tables using the migrate command.
    • If the migration was not successful yet, use south to go the a state where the table matches the schema of your dumped-out data
    • Import your dump
    • Migrate again