Failed datalog jobs are "successful" if another unrelated job succeeds
According to the function datalogStatus(), the pending datalog jobs query is:
SELECT COUNT( * ) AS cnt, sys_datalog.action, sys_datalog.dbtable FROM sys_datalog, server WHERE server.server_id = sys_datalog.server_id AND sys_datalog.user = ? AND sys_datalog.datalog_id > server.updated GROUP BY sys_datalog.dbtable, sys_datalog.action
If I intentionally let 5 jobs crash on a slave node, and then submit a completely unrelated different job successfully, the server.updated field is updated and the 5 crashed jobs are "successful".
Would it be feasible to have the datalog remember for each individual job, whether it was successful or not? So we can retry failed jobs?