3898: Assume a job Failed if it has started but state fields indicate Queued.

diff --git a/services/api/db/migrate/20140918153705_add_state_to_job.rb b/services/api/db/migrate/20140918153705_add_state_to_job.rb
index 176b0e4df2431b469161b928609197dddafe6772..20625c979ceb6c932d8d893239da5f6d6eb5f5ff 100644 (file)
--- a/services/api/db/migrate/20140918153705_add_state_to_job.rb
+++ b/services/api/db/migrate/20140918153705_add_state_to_job.rb
@@ -9,8 +9,8 @@ class AddStateToJob < ActiveRecord::Migration
       Job.update_all({state: 'Failed'}, ['state is null and success = ?', false])
       Job.update_all({state: 'Complete'}, ['state is null and success = ?', true])
       Job.update_all({state: 'Running'}, ['state is null and running = ?', true])
-      # Locked, but not Running/Failed/Complete? Let's assume it failed.
-      Job.update_all({state: 'Failed'}, ['state is null and is_locked_by_uuid is not null', true])
+      # Locked/started, but not Running/Failed/Complete? Let's assume it failed.
+      Job.update_all({state: 'Failed'}, ['state is null and (is_locked_by_uuid is not null or started_at is not null)'])
       Job.update_all({state: 'Queued'}, ['state is null'])
     end
   end