Closed joelghill closed 1 year ago
Mm, I think I know what's causing this, and it's specific to rc2 (going from rc1 to rc3 this would have been avoided).
It shouldn't cause any real problems in the meantime but I'll write up some manual database commands that can be used to fix it, because it is very annoying!
Alright, these steps will force your instance to refresh header + avatar for each remote account the next time your instance sees it (so, lazy refresh):
DELETE FROM media_attachments WHERE remote_url IS NOT NULL AND status_id IS NULL;
UPDATE accounts SET avatar_media_attachment_id=NULL WHERE domain IS NOT NULL;
UPDATE accounts SET avatar_remote_url=NULL WHERE domain IS NOT NULL;
UPDATE accounts SET header_media_attachment_id=NULL WHERE domain IS NOT NULL;
UPDATE accounts SET header_remote_url=NULL WHERE domain IS NOT NULL;
UPDATE accounts SET fetched_at=NULL;
The next time your instance runs a media prune (normally every night @ midnight, but you can trigger this manually in the admin panel) it will log something like: timestamp="17/02/2023 08:39:32.278" func=media.(*manager).PruneAll.func1 level=INFO msg="pruned 11196 orphaned media"
-- this indicates that all the media that was divorced by the SQL commands has been cleaned up :)
@tsmethurst hey just following up to say this worked, thank you! Running v0.7.1 now and it smooth as butter!
Glad to hear it :)
Describe the bug with a clear and concise description of what the bug is.
Running the latest release candidate and I noticed many errors are being thrown when fetching profile information fro certain users.
Error log when fetching @kim@k.iim.gay:
.... it goes on for a while
Only seems to occur for some accounts, but Kim stood out since I think they are running a GtS instance? I'm also seeing errors from @obi@goblin.technology (also Gts?):
What's your GoToSocial Version?
v0.7.0-rc3
GoToSocial Arch
amd64 binary
Browser version
All clients
What happened?
Updated to latest v0.7.0-rc3 Configured S3 to not use proxy after using proxy Ran server
What you expected to happen?
No response
How to reproduce it?
No response
Anything else we need to know?
Feel free to mark this as closed or whatever, I just wanted to point out the errors in case you were not aware of whatever is causing them.
From a user experience the only weird behavior I'm seeing is that the profile image and banner from @kim@k.iim.gay is not loading on any of my clients.