pleroma

commit: b3e6953d23250393010adb01fc604f97fd17eb96
parent: d73e8b6b1262d12ec27c4478ce9ec5cad76d9ebb
Author: rinpatch <rinpatch@sdf.org>
Date:   Sat,  9 May 2020 21:52:00 +0000

Merge branch 'fix/skeleton-migration-nonlocal-locals' into 'develop'

insert skeletons migration: fix for non-local locals

Closes #1746

See merge request pleroma/pleroma!2502
Diffstat:
M
CHANGELOG.md
1
+
M
priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs
2
+-

2 files changed, 2 insertions(+), 1 deletion(-)
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -44,6 +44,7 @@ The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.0.0/).
 
 ### Fixed
 - Healthcheck reporting the number of memory currently used, rather than allocated in total
+- `InsertSkeletonsForDeletedUsers` failing on some instances 
 
 ## [2.0.3] - 2020-05-02
 
diff --git a/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs b/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs
@@ -30,7 +30,7 @@ defmodule Pleroma.Repo.Migrations.InsertSkeletonsForDeletedUsers do
           Repo,
           "select distinct unnest(nonexistent_locals.recipients) from activities, lateral (select array_agg(recipient) as recipients from unnest(activities.recipients) as recipient where recipient similar to '#{
             instance_uri
-          }/users/[A-Za-z0-9]*' and not(recipient in (select ap_id from users where local = true))) nonexistent_locals;",
+          }/users/[A-Za-z0-9]*' and not(recipient in (select ap_id from users))) nonexistent_locals;",
           [],
           timeout: :infinity
         )