[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
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
Hi all,
This is my first time on the mysql mailing list, I appreciate if someone
can help me with a major problem I encountered with mysql.
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