Public
- Public
- Network
- Groups
- Featured
- Popular
- People

Conversation

Notices

Embed this notice
Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 05:24:26 JST Matty

Chicken wings

In conversation Tuesday, 29-Nov-2022 05:24:26 JST from nicecrew.digital permalink
- Embed this notice
  CatboyCumDump :blacklight: (catboycumdump@poa.st)'s status on Tuesday, 29-Nov-2022 05:24:24 JST CatboyCumDump :blacklight:
  in reply to
  @graf @matty @alex @chudbere there should almost definititely be a scheduled job that clears that queue, there's no reason someone who hasn't logged in in that long should have impact on newer/active accounts. I'd even wager there are less intrusive strategies to update the notifications table on the fly for those users given the original status metadata is preserved.
  
  In conversation Tuesday, 29-Nov-2022 05:24:24 JST permalink
- Embed this notice
  Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 05:24:24 JST Alex Gleason
  in reply to
  @CatboyCumDump @graf @chudbere @matty Just seeing this. Trying to understand why rows in another table would have an impact on your ability to receive posts at all.
  
  In conversation Tuesday, 29-Nov-2022 05:24:24 JST permalink
- Embed this notice
  anime graf mays ?️? (graf@poa.st)'s status on Tuesday, 29-Nov-2022 05:24:25 JST anime graf mays ?️?
  in reply to
  @matty @alex the issue is backed up notifications on our end, again. clearing notifications that were seen immediately rectified the issue
  pleroma=# delete from notifications where seen = 't' and inserted_at < CURRENT_TIMESTAMP-'2 months'::interval; DELETE 3161876
  (sorry people who saw their notifications 2 months ago but 3.1 million delivered notifications is a lot)
  @chudbere jims account is also working fine now
  
  In conversation Tuesday, 29-Nov-2022 05:24:25 JST permalink
- Embed this notice
  anime graf mays ?️? (graf@poa.st)'s status on Tuesday, 29-Nov-2022 05:24:26 JST anime graf mays ?️?
  in reply to
  
  @matty saw it
  
  In conversation Tuesday, 29-Nov-2022 05:24:26 JST permalink
- Embed this notice
  Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 05:26:23 JST Alex Gleason
  in reply to
  @CatboyCumDump @graf @chudbere @matty Oh wait. Is this the same problem with subscriptions? Except now for remote users?
  Does Matty have like a thousand subscribers on Poast?
  
  In conversation Tuesday, 29-Nov-2022 05:26:23 JST permalink
- Embed this notice
  Chudbere (Clairebere) :duckjam: (chudbere@chudbuds.lol)'s status on Tuesday, 29-Nov-2022 05:28:44 JST Chudbere (Clairebere) :duckjam:
  in reply to
  It's gotta be related to subscribers because the only account that was affected on chudbuds was Jim, likely due to people on poaat being subscribed to him. Post replies that don't trigger a bell were federating over to poast but not his top level posts.
  
  In conversation Tuesday, 29-Nov-2022 05:28:44 JST permalink
  
  Alex Gleason likes this.
- Embed this notice
  Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 05:29:21 JST Alex Gleason
  in reply to
  @chudbere @matty @CatboyCumDump @graf If that’s the case then we know the solution. Same thing we did for local accounts, but do it for remote too.
  
  In conversation Tuesday, 29-Nov-2022 05:29:21 JST permalink
- Embed this notice
  Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 05:30:04 JST Matty
  in reply to
  *shrug*
  
  I have no idea. I'd like to find out, at least locally, what the subscriber count is.
  
  In conversation Tuesday, 29-Nov-2022 05:30:04 JST permalink
- Embed this notice
  Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 05:30:04 JST Alex Gleason
  in reply to
  @matty @chudbere @CatboyCumDump @graf We need graf to query the db of poast and tell us.
  
  In conversation Tuesday, 29-Nov-2022 05:30:04 JST permalink

Public

Conversation

Notices

Feeds