Re-validate the results of a workunit

• workunit id in a shell variable 'id'
• setting transition_time is only necessary for immediate re-validation

  echo "UPDATE workunit SET need_validate = 1, file_delete_state = 0, transition_time = 0, batch = 8 WHERE id = $id;
  UPDATE result SET outcome = 1, file_delete_state = 0, validate_state = 0 WHERE server_state = 5 AND workunitid = $id;" | mysql EinsteinAtHome
  

Re-validate validate-error results

START TRANSACTION;
UPDATE workunit SET need_validate = 1, file_delete_state = 0, transition_time = 0 WHERE id in (SELECT workunitid FROM result WHERE outcome = 6);
UPDATE result SET outcome = 1, file_delete_state = 0, validate_state = 0 WHERE outcome = 6;
COMMIT