Public
- Public
- Network
- Groups
- Popular
- People

Conversation

Notices

this ad CAN be blocked, bitch (kirby@lab.nyanide.com)'s status on Friday, 02-Aug-2024 07:23:12 JST this ad CAN be blocked, bitch

If anybody else wants to downgrade to 2.6.3 on from source after upgrading and getting 500 hell, as the Pleroma user and in /opt/pleroma:

MIX_ENV=prod mix ecto.rollback --to 20230504173400 # The error this produces can be disregarded

git reset --hard 7566b4a348c66fcea45bcb017979ece9c7b45b3a # Apparently this is bad in some circumstances but this is what i chose to do

[ run mix deps.get and mix compile, then start pleroma ]

In conversation about 4 months ago from lab.nyanide.com permalink
- (mint@ryona.agency)'s status on Friday, 02-Aug-2024 07:23:12 JST
  in reply to
  
  @kirby Frozen federation aside, did you by any chance had cleanup_attachments enabled? For years it did literally nothing, but after some recent commit it apparently started executing some heavy query.
  https://git.pleroma.social/pleroma/pleroma/-/issues/1540
  In conversation about 4 months ago permalink
  Attachments
  1. Some query keeps hammering my DB (#1540) · Issues · Pleroma / pleroma · GitLab
    
    This query: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1)) has been...
- (mint@ryona.agency)'s status on Friday, 02-Aug-2024 07:25:36 JST
  in reply to
  
  @kirby No, attachment dedupes are Pleroma.Upload.Filter.Dedupe filter.
  
  In conversation about 4 months ago permalink
- this ad CAN be blocked, bitch (kirby@lab.nyanide.com)'s status on Friday, 02-Aug-2024 07:25:37 JST this ad CAN be blocked, bitch
  in reply to
  @mint That sounds like a lot function used for deduplicating posts, I have that [deduplicating] enabled
  
  In conversation about 4 months ago permalink

Public

Conversation

Notices

Feeds