title: "Error Code: 1205. Lock wait timeout exceeded; try restarting transaction" on delete event
body: <p>I'm trying to delete a row in my table </p>
  
  <pre><code>delete from tbllink where linkid=243
  </code></pre>
  
  <p>but i keep getting that error message: </p>
  
  <blockquote>
    <p>Error Code: 1205. Lock wait timeout exceeded; try restarting
    transaction</p>
  </blockquote>
  
  <p>As mentioned in other questions, I tried running : </p>
  
  <pre><code>show open tables where in_use&gt;0;
  </code></pre>
  
  <p>This returned 0 results. I also tried running: </p>
  
  <pre><code>show processlist
  </code></pre>
  
  <p>This returned these columns:</p>
  
  <pre><code>&gt; 2244  username IP:50487   newdatabasetemp Sleep   1777        
  &gt; 2247  username IP:50723   newdatabasetemp Sleep   1346        
  &gt; 2249  username IP:50725   newdatabasetemp Sleep   1285
  </code></pre>
  
  <p>I tried reconnecting to the server but still the same result.</p>