Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

[BUG] Transacional migrations

#51

Each migration has to be ATOMIC. Or you execute the WHOLE migration or nothing is executed. The actual state is that the migration commanded is splitted by ";", resulting in many commands per migration. If a migration fails in the middle the database gets in an unmanageable state and has to be recreated.

Ideas:
- Allow only one DDL or many DML per migration (because DDL has an implicit transaction) - Search all migration files before executing to guarantee that there is only one DDL command per migration

I don't think these ideas are very good indeed. There should be a way to solve this problem.

Reported by Guilherme Chapiewski · June 17th, 2009 @ 01:02 AM

State: invalid
Milestone: none
Assigned to: Guilherme Chapiewski Guilherme Chapiewski

Activity

  1. Wandenberg Peixoto
    Wandenberg Peixoto
    • State changed from new to invalid
    • Milestone cleared.
    • Milestone order changed from 0 to 0

    Is better to adopt the process of only put one DDL command per migration, but not force this on the tool.

    April 10th, 2012 @ 12:35 AM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.