Your New Waifu @sjw@gameliberty.club

@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.

@lanodan I'm wondering if there's something wrong... Surely it shouldn't take this long should it?

@lanodan Still going...

@lanodan Oh! It's 130 MB

@lanodan Got 846638.
Output of \d+ notifications:

@lanodan For what exactly? Just "this migration takes too long!"? I don't really know if it's much of an issue. Maybe add a warning or something but still kinda unavoidable assuming it's actually working.

@lanodan Yeah... However, my database is over 100 GB these days.