1 defmodule Pleroma.Repo.Migrations.RemoveDuplicatesFromActivityExpirationQueue do
4 import Ecto.Query, only: [from: 2]
9 where: j.queue == "activity_expiration",
10 where: j.worker == "Pleroma.Workers.PurgeExpiredActivity",
11 where: j.state == "scheduled",
13 {fragment("(?)->>'activity_id'", j.args), fragment("array_agg(?)", j.id), count(j.id)},
14 group_by: fragment("(?)->>'activity_id'", j.args),
15 having: count(j.id) > 1
18 |> Enum.map(fn {_, ids, _} ->
19 max_id = Enum.max(ids)
20 List.delete(ids, max_id)
24 from(j in Oban.Job, where: j.id in ^duplicate_ids)
25 |> Pleroma.Repo.delete_all()