Post AddAUYOKCFWAyOJpQ0 by ezhevita@masto.ezhevita.dev
 (DIR) More posts by ezhevita@masto.ezhevita.dev
 (DIR) Post #AddAUYOKCFWAyOJpQ0 by ezhevita@masto.ezhevita.dev
       2024-01-07T20:19:34Z
       
       0 likes, 0 repeats
       
       really considering changing instances due to the mastodon disk usage and periodical cascade failures because of thatalso an absolutely hilarious timeline of events:one of my production services uses a postgresql databaseservice uses a lot of INSERT ON CONFLICT UPDATE queries and updates occur significantly more often than insertsa postgres sequence is used for assigning primary IDs for the new recordspostgres is generating a lot of new IDs using the sequence (even if they are not needed because of ON CONFLICT UPDATE) and it reaches an integer limitthe service can no longer execute queries in the database and reports errors to the self-hosted Sentry instance (which is on the same machine btw)since the service has a relatively high load, there is a lot of errors generated and they basically spam the fuck out of sentrysentry processes new messages slower than they arrivedisk space is mostly occupied by Mastodon (which also is on the same machine!) and there is already a small portion of it that is freekafka (or whatever message broker they use) persists more and more messages on the diskfree disk space goes to 0boom!
       
 (DIR) Post #AddAUZqMnTXjTeRjlY by bgtlover@linuxrocks.online
       2024-01-07T20:28:52Z
       
       0 likes, 0 repeats
       
       @ezhevita yeah, perhaps host something else, like acoma, pleroma, or firefish/sharkey/catodon?
       
 (DIR) Post #AddAUaXcCg8bdmgHB2 by ezhevita@masto.ezhevita.dev
       2024-01-07T20:33:53Z
       
       0 likes, 0 repeats
       
       @bgtlover that probably won’t solve a heavy disk usage, and also i consider mastodon one of the most stable fediverse software out therealso i’m really allergic to misskey and its forks due to the js bloat
       
 (DIR) Post #AddAUatasxicjwxpR2 by ezhevita@masto.ezhevita.dev
       2024-01-07T20:23:13Z
       
       0 likes, 0 repeats
       
       and also forgot to mention that sentry is hitting cpu pretty hard trying to process those messages while still failing since there is no space left for them to be recorded in the database
       
 (DIR) Post #AddAUbLbCq7W8o4C5Q by mo@mastodon.ml
       2024-01-08T08:45:58Z
       
       0 likes, 0 repeats
       
       @ezhevita Ruby is not better@bgtlover
       
 (DIR) Post #AddAUdQdT5Kyb0RFDM by ezhevita@masto.ezhevita.dev
       2024-01-08T07:17:26Z
       
       0 likes, 0 repeats
       
       i may have fucked something up because i’ve pruned all of the profiles avatars and headers using tootctl media remove --prune-profiles --include-follows --days 0 hoping that they would load dynamically after thatapparently, this is not the case and now i have to do tootctl accounts refresh --all with the ETA of 10 hoursthanks mastodon very cool