[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