NYCPHP Meetup

NYPHP.org

[nycphp-talk] when MySQL "rollback" doesn't

David Mintz dmintz at davidmintz.org
Tue Mar 23 17:37:10 EST 2004


On Tue, 23 Mar 2004, Daniel Convissor wrote:

> Not to doubt you, but, uh, I guess I will, you're using innodb tables,
> right?  Okay, you are.  So, you've got a bug in your code.  Echo out each
> query before you execute it.  Make sure the scripts/queries are executing
> in the order you expect.  Then, if that doesn't get you no love, go to the
> length of copying/pasting the queries in the same order into a MySQL
> command line shell.
>

Ouch. So that means it *should* work... but I already rewrote this method
to do all its own SQL and tested it pretty thoroughly. It passed, so I
declared victory and committed it to my little repository. Now I gotta
decide whether to roll back (so to speak) to the previous revision and
wage more war... I was pretty much echoing the hell out of everything. And
yes the tables are InnoDB.

I think I'll go get on the subway now so I can get a front row seat at the
meeting. (Said he, changing the subject (-: )

Thanks Dan,


---
David Mintz
http://davidmintz.org/

        "Anybody else got a problem with Webistics?" -- Sopranos 24:17



More information about the talk mailing list