many postgresql and pleroma log errors.
OS: Debian 10 Upgrade Pleroma 1.1.9 to 2.0.0
after the update I have a lot of error messages and the Postgresql database grows very quickly.
postgresql log:
2020-03-08 14:42:15.288 UTC [5146] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:15.288 UTC [5146] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-02-26:objectId=6985120:objectType=Conversation) already exists.
2020-03-08 14:42:15.288 UTC [5146] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:15.612 UTC [5266] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:15.612 UTC [5266] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103726301471024079) already exists.
2020-03-08 14:42:15.612 UTC [5266] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:16.287 UTC [5148] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:16.287 UTC [5148] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/pizza/statuses/103726350592356231) already exists.
2020-03-08 14:42:16.287 UTC [5148] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:16.545 UTC [5153] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:16.545 UTC [5153] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103726354713034513) already exists.
2020-03-08 14:42:16.545 UTC [5153] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:16.875 UTC [5152] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:16.875 UTC [5152] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-03-02:objectId=7072921:objectType=Conversation) already exists.
2020-03-08 14:42:16.875 UTC [5152] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:18.125 UTC [5144] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:18.125 UTC [5144] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103750987038349112) already exists.
2020-03-08 14:42:18.125 UTC [5144] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:18.125 UTC [5152] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:18.125 UTC [5152] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103750987038349112) already exists.
2020-03-08 14:42:18.125 UTC [5152] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:18.691 UTC [5145] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:18.691 UTC [5145] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://blobturtle.club/users/reitrace/statuses/103750993716809643) already exists.
2020-03-08 14:42:18.691 UTC [5145] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:18.942 UTC [5150] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:18.942 UTC [5150] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://blobturtle.club/users/reitrace/statuses/103751009242994626) already exists.
2020-03-08 14:42:18.942 UTC [5150] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:19.120 UTC [5266] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:19.120 UTC [5266] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://social.illegalpornography.com/users/BestGirlGrace/statuses/103752178628546043) already exists.
2020-03-08 14:42:19.120 UTC [5266] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:19.275 UTC [5153] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:19.275 UTC [5153] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103751040073945659) already exists.
2020-03-08 14:42:19.275 UTC [5153] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:19.334 UTC [5146] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:19.334 UTC [5146] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://social.illegalpornography.com/users/BestGirlGrace/statuses/103752199568477233) already exists.
2020-03-08 14:42:19.334 UTC [5146] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:19.497 UTC [5152] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:19.497 UTC [5152] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103752283614807510) already exists.
2020-03-08 14:42:19.497 UTC [5152] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:19.957 UTC [5145] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:19.957 UTC [5145] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-03-03:objectId=7113405:objectType=Conversation) already exists.
2020-03-08 14:42:19.957 UTC [5145] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:20.075 UTC [5266] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:20.075 UTC [5266] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103762016240882099) already exists.
2020-03-08 14:42:20.075 UTC [5266] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:20.469 UTC [5148] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:20.469 UTC [5148] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-03-04:objectId=7123007:objectType=Conversation) already exists.
2020-03-08 14:42:20.469 UTC [5148] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:20.609 UTC [5144] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:20.609 UTC [5144] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:mastodon.xyz,2020-03-05:objectId=56541611:objectType=Conversation) already exists.
2020-03-08 14:42:20.609 UTC [5144] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:21.760 UTC [5144] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:21.760 UTC [5144] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103783808262322320) already exists.
2020-03-08 14:42:21.760 UTC [5144] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:21.786 UTC [5146] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:21.786 UTC [5146] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(https://goblin.camp/users/moss/statuses/103784093693031375) already exists.
2020-03-08 14:42:21.786 UTC [5146] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:22.320 UTC [5152] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:22.320 UTC [5152] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-03-08:objectId=7199326:objectType=Conversation) already exists.
2020-03-08 14:42:22.320 UTC [5152] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
2020-03-08 14:42:22.376 UTC [5150] pleroma@pleroma ERROR: duplicate key value violates unique constraint "objects_unique_apid_index"
2020-03-08 14:42:22.376 UTC [5150] pleroma@pleroma DETAIL: Key ((data ->> 'id'::text))=(tag:goblin.camp,2020-03-08:objectId=7200629:objectType=Conversation) already exists.
2020-03-08 14:42:22.376 UTC [5150] pleroma@pleroma STATEMENT: INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
..
Pleroma Log:
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.809 [error] Error while fetching https://diaspodon.fr/users/AugierLe42e/statuses/103497324306245180: {:error, "Transmogrifier failure."}
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.809 [error] Couldn't fetch "https://diaspodon.fr/users/AugierLe42e/statuses/103497324306245180", error: nil
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.917 [error] Error while fetching https://mastodon.tetaneutral.net/users/ithil/statuses/103497339317648573: {:error, "Transmogrifier failure."}
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.917 [error] Couldn't fetch "https://mastodon.tetaneutral.net/users/ithil/statuses/103497339317648573", error: nil
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.919 [error] Error while fetching https://diaspodon.fr/users/AugierLe42e/statuses/103497275740639473: {:error, "Transmogrifier failure."}
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.919 [error] Couldn't fetch "https://diaspodon.fr/users/AugierLe42e/statuses/103497275740639473", error: nil
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.946 [error] Error while fetching https://mastodon.tetaneutral.net/users/ithil/statuses/103497306841784637: {:error, "Transmogrifier failure."}
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.946 [error] Couldn't fetch "https://mastodon.tetaneutral.net/users/ithil/statuses/103497306841784637", error: nil
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.959 [error] Error while fetching https://diaspodon.fr/users/AugierLe42e/statuses/103497324306245180: {:error, "Transmogrifier failure."}
Mar 08 14:44:03 pleroma.envs.net pleroma[4286]: 14:44:03.959 [error] Couldn't fetch "https://diaspodon.fr/users/AugierLe42e/statuses/103497324306245180", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.013 [error] Error while fetching https://diaspodon.fr/users/AugierLe42e/statuses/103497349511249898: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.013 [error] Couldn't fetch "https://diaspodon.fr/users/AugierLe42e/statuses/103497349511249898", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.013 [error] Error while fetching https://mastodon.tetaneutral.net/users/ithil/statuses/103497339317648573: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.013 [error] Couldn't fetch "https://mastodon.tetaneutral.net/users/ithil/statuses/103497339317648573", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.017 [error] Error while fetching https://diaspodon.fr/users/AugierLe42e/statuses/103497349511249898: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.017 [error] Couldn't fetch "https://diaspodon.fr/users/AugierLe42e/statuses/103497349511249898", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.060 [error] Error while fetching https://mastodon.tetaneutral.net/users/ithil/statuses/103497403357312800: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.060 [error] Couldn't fetch "https://mastodon.tetaneutral.net/users/ithil/statuses/103497403357312800", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.418 [error] Error while fetching https://framapiaf.org/users/bonyred64/statuses/103585028055763998: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.418 [error] Couldn't fetch "https://framapiaf.org/users/bonyred64/statuses/103585028055763998", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.799 [error] Error while fetching https://mastodon.social/users/choriza/statuses/103679705647301640: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.799 [error] Couldn't fetch "https://mastodon.social/users/choriza/statuses/103679705647301640", error: nil
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.846 [error] Error while fetching https://framapiaf.org/users/bonyred64/statuses/103588873183168381: {:error, "Transmogrifier failure."}
Mar 08 14:44:04 pleroma.envs.net pleroma[4286]: 14:44:04.846 [error] Couldn't fetch "https://framapiaf.org/users/bonyred64/statuses/103588873183168381", error: nil
Mar 08 14:44:06 pleroma.envs.net pleroma[4286]: 14:44:06.991 [error] Error while fetching https://framapiaf.org/users/bonyred64/statuses/103639473252934408: {:error, "Transmogrifier failure."}
Mar 08 14:44:06 pleroma.envs.net pleroma[4286]: 14:44:06.991 [error] Couldn't fetch "https://framapiaf.org/users/bonyred64/statuses/103639473252934408", error: nil
Mar 08 14:44:07 pleroma.envs.net pleroma[4286]: 14:44:07.031 [error] Error while fetching https://tutut.delire.party/users/almet/statuses/103022795376952982: {:error, "Transmogrifier failure."}
Mar 08 14:44:07 pleroma.envs.net pleroma[4286]: 14:44:07.031 [error] Couldn't fetch "https://tutut.delire.party/users/almet/statuses/103022795376952982", error: nil
Mar 08 14:44:08 pleroma.envs.net pleroma[4286]: 14:44:08.392 [error] Error while fetching https://tutut.delire.party/users/almet/statuses/103085985759213033: {:error, "Transmogrifier failure."}
Mar 08 14:44:08 pleroma.envs.net pleroma[4286]: 14:44:08.392 [error] Couldn't fetch "https://tutut.delire.party/users/almet/statuses/103085985759213033", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.178 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102889431355584722: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.178 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102889431355584722", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.178 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102889431355584722: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.178 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102889431355584722", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.221 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102892089285812718: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.221 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102892089285812718", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.281 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102892089285812718: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.281 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102892089285812718", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.299 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102898026150023336: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.299 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102898026150023336", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.335 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102898026150023336: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.335 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102898026150023336", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.339 [error] Error while fetching https://framapiaf.org/users/bonyred64/statuses/103662674714103905: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.339 [error] Couldn't fetch "https://framapiaf.org/users/bonyred64/statuses/103662674714103905", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.390 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102903689280085201: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.390 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102903689280085201", error: nil
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.410 [error] Error while fetching https://mamot.fr/users/Eva/statuses/102903689280085201: {:error, "Transmogrifier failure."}
Mar 08 14:44:10 pleroma.envs.net pleroma[4286]: 14:44:10.410 [error] Couldn't fetch "https://mamot.fr/users/Eva/statuses/102903689280085201", error: nil