"Command error" locks drone until reset

[darozak]

Certain programs generate a "Command error" which, once generated, will repeat until the drone is reset. It's not clear what program elements are generating this error and why it persists until reset. Keep a lookout for the recurrence of this error so we can determine what is happening here.

[darozak]

The command error appears to be generated when the drone submits a query for which there is no results, such as the following query for a sell order for resource 1010:

SELECT e.new_credits, e.new_quantity, i.available, e.drone FROM exmachinis.events AS e INNER JOIN ( SELECT drone, max(timestamp) AS my_time FROM exmachinis.events WHERE outcome = 1 AND event_type = 4 AND resource = 1010 GROUP BY drone) AS current_transactions ON e.timestamp = current_transactions.my_time AND e.drone = current_transactions.drone   INNER JOIN ( SELECT e2.drone, e2.new_quantity AS available FROM exmachinis.events AS e2 INNER JOIN (  SELECT drone, max(timestamp) AS my_time FROM exmachinis.events WHERE outcome = 1 AND locked = 0 AND (event_type = 1 OR event_type = 2) AND resource = 1010 GROUP BY drone) AS current_inventory ON e2.timestamp = current_inventory.my_time AND e2.drone = current_inventory.drone ) AS i ON e.drone = i.drone ORDER BY e.new_credits ASC;