Re: Deadlock Detection in InnoDB storage engine

[Aftab Khan]

provide us output of following:

SHOW CREATE TABLE OB_SEQUENCE_INFO\G

EXPLAIN SELECT 
  obsequence0_.ID AS ID77_,
  obsequence0_.NAME AS NAME77_,
  obsequence0_.VALUE AS VALUE77_,
  obsequence0_.INCREMENT_SIZE AS INCREMENT4_77_,
  obsequence0_.IS_POOLED AS IS5_77_,
  obsequence0_.POOL_SIZE AS POOL6_77_,
  obsequence0_.PARTY_ROLE_ID AS PARTY7_77_ 
FROM
  OB_SEQUENCE_INFO obsequence0_ 
WHERE obsequence0_.NAME = 'bill' 
  AND obsequence0_.PARTY_ROLE_ID = '21ce44c2d23a11e1a3bf68b599c22bdc' FOR 
  UPDATE