Guest User

Untitled

a guest
Jan 22nd, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. background:
  2. RAILS >= 3.0
  3. SQLITE3 >= 3.7.5
  4.  
  5.  
  6. >> Delayed::Job.all
  7.  
  8. Delayed::Backend::ActiveRecord::Job Load (0.3ms) SELECT "delayed_jobs".* FROM "delayed_jobs"
  9.  
  10. => [#<Delayed::Backend::ActiveRecord::Job id: 1, priority: 0, attempts: 0,
  11. handler: "--- !ruby/ActiveRecord:Build \nattributes: \n id: 1\n...", last_error: nil,
  12. run_at: "2011-09-09 15:00:20", locked_at: nil, failed_at: nil, locked_by: nil,
  13. created_at: "2011-09-09 15:00:20", updated_at: "2011-09-09 15:00:20">]
  14.  
  15.  
  16.  
  17. >> Delayed::Worker.new.work_off
  18.  
  19. SELECT "delayed_jobs".* FROM "delayed_jobs" WHERE
  20. ((run_at <= '2011-09-09 15:20:45.037467' AND (locked_at IS NULL OR locked_at < '2011-09-09 11:20:45.037488')
  21. OR locked_by = 'host:CvX-MBP.local pid:39528') AND failed_at IS NULL)
  22. ORDER BY priority ASC, run_at ASC LIMIT 5
  23.  
  24. => [0, 0]
  25. (0 done, 0 failed)
  26.  
  27.  
  28.  
  29.  
  30. THE PROBLEM?
  31.  
  32. SELECT * FROM delayed_jobs WHERE run_at <= '2011-09-09 15:20:45.037467'
  33.  
  34. returns no records
  35.  
  36.  
  37.  
  38. WHAT DOES?
  39.  
  40. THIS:
  41. SELECT * FROM delayed_jobs WHERE DATETIME(run_at) <= '2011-09-09 15:20:45.037467'
  42.  
  43.  
  44.  
  45. WHO IS TO BLAME?
  46.  
  47. RAILS?
  48.  
  49. SQLITE3?
Add Comment
Please, Sign In to add comment