Re: [sqlalchemy] TwoPhase commit not rolling back completely

2013-07-17 Thread Antoni Silvestre Padrós
Wow thank you that was it! I had some newer tables created in MyISAM and those table got to be always updated in transactions with other tables. On Wednesday, July 17, 2013 4:57:02 PM UTC+2, Michael Bayer wrote: > > > On Jul 17, 2013, at 10:32 AM, Antoni Silvestre Padrós < > antoni.s...@gmail.com

Re: [sqlalchemy] TwoPhase commit not rolling back completely

2013-07-17 Thread Michael Bayer
On Jul 17, 2013, at 10:32 AM, Antoni Silvestre Padrós wrote: > Hi, I have a service that sends transactions to many different mysql nodes > using sqlalchemy, one basic requirement for this service is to always have > the same state in all the nodes, thus if one update in one node fails I have

[sqlalchemy] TwoPhase commit not rolling back completely

2013-07-17 Thread Antoni Silvestre Padrós
Hi, I have a service that sends transactions to many different mysql nodes using sqlalchemy, one basic requirement for this service is to always have the same state in all the nodes, thus if one update in one node fails I have to rollback the transaction in the nodes that the update had been pr