Hello,



There is transaction that keeps several locks.



(from innodb status):



---TRANSACTION 0 101247934, ACTIVE 2209 sec, process no 3136, OS thread id
1189648704

4 lock struct(s), heap size 1216, 1 row lock(s), undo log entries 6

MySQL thread id 7902, query id 3160394 foo.example.com t 1.2.3.4 foo-test

Trx read view will not see trx with id >= 0 101252647, sees < 0 101252647



How can I find which lock is held?



Ilya.