0

i have a delete statement when running that getting error 

#1205 - Lock wait timeout exceeded; try restarting transaction

my delete statement is 

DELETE FROM `hotspot_sentences` WHERE doc_id = 459

when i run 

show open tables WHERE In_use > 0

getting 0 no of rows

on running SHOW FULL PROCESSLIST

enter image description here

Shahneel Ahmed
  • 163
  • 3
  • 18
  • try `SHOW FULL PROCESSLIST;`. This output should help you identify the cause for the lockup. – Fang Jun 01 '18 at 11:35
  • possible duplicate: https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa – Rahul Jain Jun 01 '18 at 11:36
  • Fang i updated the question please check – Shahneel Ahmed Jun 01 '18 at 11:40
  • How many rows do you have in table, and what is the timeout set in mysql ? try with **SHOW VARIABLES LIKE '%innodb_lock_wait_timeout%'** – Alpesh Jikadra Jun 01 '18 at 12:35

0 Answers0