Conversation

Notices

1. Embed this notice
   silverpill (silverpill@mitra.social)'s status on Thursday, 30-May-2024 16:04:02 JST silverpill

   in reply to

   • Nimda
   • Clément VILLISEK

   @nimda @clemv I don't think postgresql tuning will have significant effect. But you can try to change this value to 20, and re-compile the backend: https://codeberg.org/silverpill/mitra/src/branch/main/mitra_activitypub/src/queues.rs#L76

   • Embed this notice
     Nimda (nimda@wizard.casa)'s status on Thursday, 30-May-2024 16:04:03 JST Nimda

     in reply to

     • Nimda
     • Clément VILLISEK

     @silverpill and it looks like incoming activities are fighting the current again, incoming activities: 38032

     I think these are the culprit, I'm willing to take drastic actions tomorrow (nuking @clemv follow list just to get the queue down, (or something) but will wait and hope he gives the go ahead, or you give a better suggestion, before I do that):

     May 29 23:43:54 mitra mitra[18680]: 2024-05-29T23:43:54 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:54 mitra mitra[18680]: 2024-05-29T23:43:54 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:54 mitra mitra[18680]: 2024-05-29T23:43:54 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:54 mitra mitra[18680]: 2024-05-29T23:43:54 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:54 mitra mitra[18680]: 2024-05-29T23:43:54 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:55 mitra mitra[18680]: 2024-05-29T23:43:55 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:55 mitra mitra[18680]: 2024-05-29T23:43:55 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:55 mitra mitra[18680]: 2024-05-29T23:43:55 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:55 mitra mitra[18680]: 2024-05-29T23:43:55 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce May 29 23:43:57 mitra mitra[18680]: 2024-05-29T23:43:57 mitra::activitypub::views [INFO] received in /users/clemv/inbox: Announce
   • Embed this notice
     Nimda (nimda@wizard.casa)'s status on Thursday, 30-May-2024 16:04:03 JST Nimda

     in reply to

     • Nimda
     • Clément VILLISEK

     @silverpill @clemv I also saw this posted the other day: https://docs.pleroma.social/backend/configuration/postgresql/ -- I haven't done any postgres tuning, so maybe I'll give that a go too

   • Embed this notice
     Nimda (nimda@wizard.casa)'s status on Thursday, 30-May-2024 16:04:04 JST Nimda

     in reply to

     • Nimda

     but after troubleshooting today, we're running some new code thanks to @silverpill

   • Embed this notice
     Nimda (nimda@wizard.casa)'s status on Thursday, 30-May-2024 16:04:05 JST Nimda

     Wizard Casa users: there's going to be incoming timeline lag as the incoming federation queue flushes out (slowly), looks like it will take at least a day to finish