title: How is it possible to have deadlocks without transactions?
body: <p>My code is a bit of a mess, I'm not sure where the problem is, but I'm getting deadlocks without using any transactions or table locking. Any information about this would help.</p>
  
  <p>I've looked up deadlocks and it seems the only way to cause them is by using transactions.</p>
  
  <pre><code>Error Number: 1213
  Deadlock found when trying to get lock; try restarting transaction
  UPDATE `x__cf_request` SET `contact_success` = 1, `se_engine_id` = 0, `is_fresh` = 1 WHERE `id` =  '28488'
  </code></pre>
  
  <p>Edit: Why downvotes? It's a valid question. If it's impossible just say why, so that other people can see when they run into this issue.</p>