[resending this with another mail user agent to bypass the spam filter]
Dear Andy,
I have this weird problem with 1 transaction locking out another for
no
apparent reason and in an inconsistent fashion. I'm using mysql
4.0.18
with innodb tables. The table in question has 2 primary keys: CID and
Dear Marko,
It does look like the result of a gap lock, but notice that I used both
primary keys in the where clause of my update query, therefore it should
only match (and update) 1 row. From my understanding (correct me if I'm
wrong, my knowledge of how mysql works is gleaned from the mysql docs
