Modify

Ticket #694 (closed defect: invalid)

Opened 4 years ago

Last modified 4 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:

Description

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?

Attachments

Change History

comment:1 Changed 4 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:

http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html

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.

View

Add a comment

Modify Ticket

Action
as closed
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.