title: MySQL - Query logged but not inserted in database
body: <p>I'm working on an automated system on LAMP stack and experiencing several query misses, i.e. the query gets executed by PHP but its not present in the database and there are no errors.</p>
  
  <p>So I enabled logging all queries in mysql to see if the query reaches there at all and sure enough, the query is there. It happened right now so I'll explain with an example:</p>
  
  <p>(BTW don't try to find errors in the queries. There aren't any. The same queries do execute most of the time)</p>
  
  <p>PHP executes:</p>
  
  <pre><code>$saveOrderQ = "INSERT INTO orders (order_id, parent_order, date_created, status, type, phase, ticker, quantity, entry_price, tp1, tp2, strategy, relative_volume, distance_from_close) VALUES ({$order-&gt;order_id}, 0, '$now', 'OPEN', 'BUY', 0, '$ticker', $positionsSize, $price, $tp1, $tp2, {$tickerAttr['strategy']}, $relativeVol, $distanceFromClose)";
  writeToLog($saveOrderQ); // I get the query in the log. This function's log is seperate from mysql log
  $saveOrder = mysqli_query($connect, $saveOrderQ);
  if(!$saveOrder){
      writeToLog("Failed to insert file 30daybreakout.php Line 59. Error: ".mysqli_error($connect)."\nQuery: $saveOrderQ"); // no error received
  }
  </code></pre>
  
  <p>MySQL log around the same time:</p>
  
  <pre><code>2020-04-13T09:23:02.222315+05:30    127059 Query    SELECT order_id FROM orders WHERE ticker = 'NSE:BALMLAWRIE' AND DATE(date_created) = '2020-04-13' AND parent_order = 0 AND phase &lt; 3
  2020-04-13T09:23:02.356930+05:30    127059 Query    INSERT INTO orders (order_id, parent_order, date_created, status, type, phase, ticker, quantity, entry_price, tp1, tp2, strategy, relative_volume, distance_from_close) VALUES (200413000329794, 0, '2020-04-13 09:23:01', 'OPEN', 'BUY', 0, 'NSE:BALMLAWRIE', 54, 91.3, 94.95, 98.6, 1, 108.87022900763, 6.5966141272621)
  </code></pre>
  
  <p>This entry is simply not present in the orders table. </p>
  
  <p>My best guess is that somehow the order table is locked but I don't know for sure. How do I troubleshoot it?</p>