Your New Waifu @sjw@gameliberty.club

@lanodan Looks like 20200527163635_delete_notifications_from_invisible_users is going to be another 20200602125218_backfill_notification_types

@Lumeinshin@neckbeard.xyz @Elfie@neckbeard.xyz @sjw@neckbeard.xyz @nerdman Pretty much. It's trying to catch up on federation.

@Elfie@neckbeard.xyz @sjw@neckbeard.xyz
https://git.pleroma.social/pleroma/pleroma/-/issues/1857

@lanodan Migration just finished.

@Jojothegoodperson@freespeechextremist.com @matrix @PrettyPrivates
https://git.pleroma.social/pleroma/pleroma/-/issues/1857

@thor@mstdn.social my pp very hard rn

@dqn cc @Elfie@neckbeard.xyz

@PrettyPrivates @matrix would you licc?

@lanodan I think that's just kinda incoming federation while it's running
https://git.pleroma.social/pleroma/pleroma/-/issues/1716

@lanodan Yeah. I've also got netdata running on the server
https://neckbeard.xyz/netdata/#menu_system;theme=slate;help=true;update_always=true

@lanodan Postgres logs are just filled with stuff about @igel's broken accountJun 10 15:40:43 neckbeard.shittyurl.org postgres[2520292]: 2020-06-10 15:40:43.220 PDT [2520292] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"

@lanodan Well, postgres isn't really using any CPU.