Re: "Lock wait timeout exceeded" time out on insert.

[Nic Whale]

Thanks again Rick for answering,

I have only included the transactions for ID=275459.


2011-12-13 09:12:18 ssra 275459 SET autocommit=0
2011-12-13 09:12:18 ssra 275459 SELECT lastupdated from operative where id =65277 LOCK IN SHARE MODE
2011-12-13 09:12:18 ssra 275459 SELECT lastupdated from op2 where id =63900 LOCK IN SHARE MODE
2011-12-13 09:12:18 ssra 275459 SELECT lastupdated from op3 where id =58290 LOCK IN SHARE MODE
2011-12-13 09:12:18 ssra 275459 SELECT id,.... from aa where .....
2011-12-13 09:12:18 ssra 275459 rollback
2011-12-13 09:12:18 ssra 275459 SET autocommit=1
2011-12-13 09:12:23 ssra 275459 SET autocommit=0
2011-12-13 09:12:23 ssra 275459 SELECT id,.... from operative where ....
2011-12-13 09:12:23 ssra 275459 SELECT id,..... from user where (id = 65365) order by id desc
2011-12-13 09:12:23 ssra 275459 SELECT id,.... from operative where ....
2011-12-13 09:12:23 ssra 275459 SELECT id,..... from user where (id = 65365) order by id desc

What is your thinking? Curios cause this following transactions did not start till 13 seconds later?

Cheers

Nick