Sorry NB is down. Adding support for chat and the migration is taking longer than expected
I think the migration stalled for some reason so I'm going to restart it.
Seems to be doing stuff now.
Hey @lanodan how long should I expect the 20200602125218_backfill_notification_types migration to take?
I think it should be long but feel free to report once it's done.
@lanodan Been going for about an hour and a half now
@lanodan Still going...
@lanodan I'm wondering if there's something wrong... Surely it shouldn't take this long should it?
I'm quite bad at knowing how much a SQL command takes, I often try normal programming modifications and then EXPLAIN.
@lanodan@queer.hacktivis.me
@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 I think that's just kinda incoming federation while it's running
https://git.pleroma.social/pleroma/pleroma/-/issues/1716
@lanodan Migration just finished.
@lanodan Looks like 20200527163635_delete_notifications_from_invisible_users is going to be another 20200602125218_backfill_notification_types 
@lanodan I'll let it go for at least 30 minutes to be sure it's a long boi
@lanodan Nevermind. Only took 08m34s
