I have an INSERT waiting for a table lock, and i do not understand why.
---TRANSACTION 0 308691, ACTIVE 5 sec, process no 8876, OS thread id
1296547864 inserting
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 320
MySQL thread id 79126, query id 1113322 bil.oneeighty.com 216.187.166.2
voxcall update
INSERT INTO voxinternal.Entity ( Entity_ID, Entity_Name, Entity_Type,
Who, Ins_Date ) VALUES ( 'OLEO', 'Ole Matadors', 'Organization', 'PYTH',
now() )
------- TRX HAS BEEN WAITING 5 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `voxinternal/Entity` trx id 0 308691 lock mode IX
waiting
------------------
The MySQL version is 5.1.7-beta-max-log
Can any one illuminate me?
I have read all documentation that i can find that appears pertinent.
Does anyone know how I may find out who already has a lock in/on the
table?
Can one find out what locks are going to be issued when some particular
piece of SQL is executed?
I appreciate any help.
Paul
