Sidekiq error for Jobs::DeleteReplies Job

[martin (Martin Brennan)]

The fix is here:

FIX: Topic timer duration_minutes was not backfilled correctly (#12004)

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).