Ticket #694 (closed defect: invalid)

Opened 5 years ago

Last modified 5 years ago

South Unable to Do DDL Transactions Under MySQL

Reported by: ortsed Owned by: andrew
Priority: major Milestone: 1.0
Component: commands Version: unknown
Keywords: Cc:


Every time South needs to run a DDL Transaction while using a MYSQL DB (for rolling back changes and other edits), it throws an "unable to run DDL Transaction error" and suggests using a different DB.

We have been able to get around this by setting:

has_ddl_transactions = True

in the mysql.py script, as it looks like MySQL 5.1.37 does have DDL Transactions, but maybe the script needs to be split up for different versions of MySQL?

Change History

comment:1 Changed 5 years ago by andrew

  • Status changed from new to closed
  • Resolution set to invalid
  • Milestone set to 1.0

I'm afraid MySQL still lacks support for DDL transactions, as of version 5.5:


If you put True there, it may appear to work, but it's probably going to fail to roll back properly if you have more than database call in that migration.

Note: See TracTickets for help on using tickets.