Following own relay then unfollowing doesn't work
Environment
- Installation type (OTP or From Source): OTP
- Pleroma version (could be found in the "Version" tab of settings in Pleroma-FE): 2.3.0
- Elixir version (
elixir -v
for from source installations, N/A for OTP):N/A - Operating system: Void Linux
- PostgreSQL version (
psql -V
): 13.2
Bug description
A while ago, I must have self-followed my own relay at https://social.beckmeyer.us/relay
. I am trying to remove it now, but it does not work. The unfollow
command appears to succeed, but https://social.beckmeyer.us/relay
still shows up in ./bin/pleroma_ctl relay list
.
Full output of unfollow and list commands below:
09:14:13.226 [debug] QUERY OK db=0.1ms idle=466.9ms
begin []
09:14:13.227 [debug] QUERY OK source="activities" db=0.4ms
SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE ((a0."data")->>'type' = $1) AND (a0."actor" = $2) AND (coalesce((a0."data")->'object'->>'id', (a0."data")->>'object') = $3) ORDER BY a0."id" desc nulls last LIMIT 1 ["Follow", "https://social.beckmeyer.us/relay", "https://social.beckmeyer.us/relay"]
09:14:13.227 [debug] QUERY OK source="activities" db=0.4ms
SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 LEFT OUTER JOIN "objects" AS o1 ON (o1."data"->>'id') = COALESCE(a0."data"->'object'->>'id', a0."data"->>'object') WHERE ((a0."data")->>'id' = $1) [""]
09:14:13.227 [debug] QUERY OK source="objects" db=0.2ms
SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE ((o0."data")->>'id' = $1) ["https://social.beckmeyer.us/contexts/d4430304-ffe5-4064-8cf6-b719e6d8d990"]
09:14:13.228 [debug] QUERY OK db=0.2ms
INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id" [%{"id" => "https://social.beckmeyer.us/contexts/d4430304-ffe5-4064-8cf6-b719e6d8d990"}, ~N[2021-04-22 13:14:13], ~N[2021-04-22 13:14:13]]
09:14:13.237 [debug] QUERY OK db=7.9ms
INSERT INTO "activities" ("actor","data","local","recipients","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7) ["https://social.beckmeyer.us/relay", %{"actor" => "https://social.beckmeyer.us/relay", "context" => "https://social.beckmeyer.us/contexts/d4430304-ffe5-4064-8cf6-b719e6d8d990", "context_id" => 3087007, "id" => "https://social.beckmeyer.us/activities/cdf73a7e-03f6-4ebf-896e-876d10827c14", "object" => %{"actor" => "https://social.beckmeyer.us/relay", "cc" => [], "context" => "https://social.beckmeyer.us/contexts/d4430304-ffe5-4064-8cf6-b719e6d8d990", "context_id" => 3087007, "id" => "https://social.beckmeyer.us/activities/0973f31f-eb64-4960-9625-c928fa68db97", "object" => "https://social.beckmeyer.us/relay", "published" => "2021-04-22T13:14:13.228268Z", "state" => "cancelled", "to" => ["https://social.beckmeyer.us/relay"], "type" => "Follow"}, "published" => "2021-04-22T13:14:13.228242Z", "to" => ["https://social.beckmeyer.us/relay"], "type" => "Undo"}, true, ["https://social.beckmeyer.us/relay"], <<0, 0, 1, 120, 249, 183, 117, 108, 157, 205, 45, 65, 240, 66, 0, 0>>, ~N[2021-04-22 13:14:13], ~N[2021-04-22 13:14:13]]
09:14:13.256 [debug] QUERY OK db=18.2ms
commit []
09:14:13.256 [info] relay: unfollowed instance: https://social.beckmeyer.us/relay: id=https://social.beckmeyer.us/activities/cdf73a7e-03f6-4ebf-896e-876d10827c14
https://social.beckmeyer.us/relay
https://relay.beckmeyer.us/actor
09:16:04.241 [debug] QUERY OK source="following_relationships" db=0.6ms idle=373.3ms
SELECT u1."ap_id" FROM "following_relationships" AS f0 INNER JOIN "users" AS u1 ON f0."following_id" = u1."id" WHERE (f0."follower_id" = $1) AND (f0."state" = $2) [<<0, 0, 1, 111, 131, 0, 208, 159, 70, 181, 54, 213, 230, 42, 0, 0>>, 2]
09:16:04.242 [debug] QUERY OK source="activities" db=0.8ms idle=370.6ms
SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE ((a0."data")->>'type' = $1) AND (a0."data"->>'state' = 'pending') AND (a0."actor" = $2) ["Follow", "https://social.beckmeyer.us/relay"]