Sidekiq error for Jobs::DeleteReplies Job

[martin (Martin Brennan)]

The fix is here:

https://github.com/discourse/discourse/commit/18da1d5b07445e1de3a1326aabcca68091093dd7

This migration did not work as expected:

DB.exec("UPDATE topic_timers SET duration_minutes = (duration * 60 * 24) WHERE duration_minutes != duration AND status_type = 7 AND duration IS NOT NULL")
DB.exec("UPDATE topic_timers SET duration_minutes = (duration * 60) WHERE duration_minutes != duration AND status_type != 7 AND duration IS NOT NULL")

WHERE duration_minutes != duration does not work if duration_minutes is NULL, which all of them arewere.

@Overgrow

Thanks for confirmation. Should I expect more problems with other topic_timers? Which type of the timer is affected? Only “delete post after x”? It really accumulated a lot in the queue (thousands in few hours)… (luckily I have prometheus… )

Yes only the Jobs::DeleteReplies job directly referred to the new duration_minutes job, so other timers should have been unaffected (from what I can tell).