Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.6

Bug #11696 getDefinitionFromDatabase() ends with ROLLBACK, without START TRANSACTION
Submitted: 2007-07-28 13:19 UTC
From: floele Assigned:
Status: Open Package: MDB2_Schema (version CVS)
PHP Version: Irrelevant OS: Irrelevant
Roadmaps: (Not assigned)    
Subscription  


 [2007-07-28 13:19 UTC] floele (Florian Schmitz)
Description: ------------ Hi once again ;) I hope that I got an MDB2_Schema bug instead of an MDB2 one this time at least... I recently submitted 11692 which already mentions my problem, but now I realised that this bug is in fact unrelated to it. So what I am doing is thw following: $db->supports('transactions') && $db->beginTransaction(); $db->query(...); $previous_schema = $schema->getDefinitionFromDatabase(); die(); // usually I'd continue with updateDatabase() and a few more queries and then commit it all together, but that won't work either so I have this for simplicity. Interestingly, the query log shows a ROLLBACK at the bottom, without a START TRANSACTION at the beginning. See: http://pastebin.ca/637004 I highlighted the important parts. Expected result: ---------------- Either no ROLLBACK at the end, or a new nested transaction at the beginning. Actual result: -------------- ROLLBACK at the end, without starting a new transaction.

Comments

 [2007-08-29 16:32 UTC] ifeghali (Igor Feghali)
Hello Florian, I still have no clue on this one... Will investigate this later. regards, iGor.
 [2008-01-30 12:36 UTC] ifeghali (Igor Feghali)
Weird getDefinitionFromDatabase() doesn't end any transaction directly. It may be somewhat related to Bug #11692. Let's wait for it.
 [2008-03-10 20:40 UTC] ifeghali (Igor Feghali)
Bug #11692 is fixed. Re-opening this one.