Dear lemmy, today I fucked up (midwest.social)

submitted 2 years ago by [email protected] to c/[email protected]

29 comments fedilink hide all child comments

Deleted something I shouldn't have. I learned my lesson, but I had to revert to a backup that was about 3 days old. My bad.

you are viewing a single comment's thread
view the rest of the comments

[-] [email protected] 6 points 2 years ago

Thanks. Yeah, this is what happens when my need to try everything to resolve an issue gets the better of me too fast. My filesystem was 90% full and I didn't want it to run out, so I deleted something I shouldn't have. If you have any idea why my disk would be using up lots of storage even though I'm using an S3 bucket and have my logs limited let me know.

[-] [email protected] 5 points 2 years ago

Yes, that might actually be the activitypub table in the database. You can safely delete older entries, like from two weeks ago or older. Otherwise it just keeps growing with the logs of all activitypub objects that the server has sent out received.

[-] [email protected] 2 points 2 years ago

Do you know where I can find the query to do that? Databases are not my forte.

[-] [email protected] 2 points 2 years ago

W3 Schools entry on SQL DELETE statement

I don't know the actual table definitions for lemmy, but it should look something like:

DELETE FROM activitypub
WHERE createdDate < ((SELECT CURRENT_DATE) - interval '2 weeks')

load more comments (1 replies)

load more comments (3 replies)

this post was submitted on 19 Jul 2023

81 points (96.6% liked)

main

1440 readers

1 users here now

Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.

founded 3 years ago

MODERATORS

[email protected]