Post APsP4Wt4BGP9OTl9yy by Relected@shitposter.club
(DIR) More posts by Relected@shitposter.club
(DIR) Post #APsNugQhkNEG8iEcPA by drq@mastodon.ml
2022-11-22T22:47:35Z
4 likes, 6 repeats
Pleroma is the essential software for the Fediverse, but it seems like most heavily-used Pleroma servers have a lifespan of, on average, a year or two. After this, it starts having problems, that seem to come from its data model.I'm tired of seeing instances run by my peers (housing some of the greatest and coolest and friendliest communities I know, like Inidiefedi, or Udongein, or Expired Mentality) just die out of nowhere, out of the blue, out of thin air.We NEED to fix Pleroma, somehow, or develop an alternative that has 1:1 feature parity, but the data storage scheme of which isn't a ticking time bomb. I can't stress this enough, Pleroma is an absolutely critical piece of software to the Fedi.#pleroma #fediverse
(DIR) Post #APsOxfZBVqyQHkBmUK by lamp@mastodong.lol
2022-11-22T22:59:19Z
0 likes, 0 repeats
@drq what's up with the data storage; it corrupts itself over time or something?
(DIR) Post #APsP0e6XPAyycTD11M by espen@eboks.social
2022-11-22T22:59:53Z
0 likes, 0 repeats
@drq A fork happened a while back although I can't remember the name atm. Perhaps the code has received some TLC already? Or they are open to improve the storage. What's the reason for the communities imploding? Does it get slower and slower until it siezes up or what?
(DIR) Post #APsP4Wt4BGP9OTl9yy by Relected@shitposter.club
2022-11-22T23:00:12.187036Z
0 likes, 0 repeats
@drq a lot of pleroma instances are still fine after several years (SPC, Poast, CDROM, KFC (rip), absturtztaube, iddqd)
(DIR) Post #APsP8KcDkT9mUZh2US by SuperDicq@minidisc.tokyo
2022-11-22T23:01:15.934Z
5 likes, 1 repeats
@drq@mastodon.ml I run a nearly 3 year old Pleroma instance. It is a constant struggle to keep it running as the database completely deteriorates into a mess over time.There's a lot of things you can do fix it, like optimizing psql, playing with workers, queues and poolsizes, vacuuming, pruning old posts and many more things. However they are poorly documented.I think a quick and easy start to not letting Pleroma instances die would be a page that is just "Do this stuff in case of degraded database performance" with all the things listed there that I just mentioned.
(DIR) Post #APsPAnNHnH7WGYslxA by drq@mastodon.ml
2022-11-22T23:01:42Z
0 likes, 0 repeats
@espen Yes, it seems to be getting slower the more it's used, @a1batross might have more details on that.
(DIR) Post #APsPIOmP7Y4YIrFyzo by drq@mastodon.ml
2022-11-22T23:03:05Z
0 likes, 0 repeats
@lamp Its performance degrades, until it grinds to a halt, basically.
(DIR) Post #APsPJzsWfqnFeVslma by espen@eboks.social
2022-11-22T23:03:19Z
0 likes, 0 repeats
@drq Ah, Akkoma was the one I was thinking about. https://akkoma.social@a1batross
(DIR) Post #APsPMzjPg21Q4737Oy by drq@mastodon.ml
2022-11-22T23:03:51Z
0 likes, 0 repeats
@espen They did nothing about storage as of yet, I think.@a1batross
(DIR) Post #APsPhcI01t3LRT3mk4 by SuperDicq@minidisc.tokyo
2022-11-22T23:07:37.906Z
1 likes, 0 repeats
@drq@mastodon.ml For example I recently figured that decreasing the amount of federator queues greatly improves performance.By default this value was 50 and changing it to 5 seemed to help a lot. 5 is also the default in the latest version of Pleroma.Also I don't know what this value means or what it does because it is not documented anywhere.
(DIR) Post #APsPutfsheAV7rYyjA by drq@mastodon.ml
2022-11-22T23:09:55Z
0 likes, 0 repeats
@SuperDicq cc @a1batross
(DIR) Post #APsRvSR1fG9mqF0fIG by Hyolobrika@gleasonator.com
2022-11-22T23:32:36.038875Z
0 likes, 0 repeats
@drq @drq All those instances still load. Wdym?
(DIR) Post #APsSJcJMb074QGwhKC by drq@mastodon.ml
2022-11-22T23:36:54Z
1 likes, 0 repeats
@Hyolobrika They are unstable to the point of admins getting fed up and moving to shut down the instances.
(DIR) Post #APsSL6MkL5U3vPEhN2 by niconiconi@mk.absturztau.be
2022-11-22T23:36:35.701Z
1 likes, 1 repeats
@drq@mastodon.ml @lamp@mastodong.lol People call it "Pleroma database rot". After reaching a critical point, query time goes to the moon and the instance became completely unusable. The only workarounds are vacuum the database, rebuild the index, and upgrade the hardware, but only with limited effectiveness.
(DIR) Post #APsSR0Lfcm5t03Y0VU by lamp@mastodong.lol
2022-11-22T23:38:14Z
0 likes, 0 repeats
@niconiconi @drq iirc pleroma uses postgres?
(DIR) Post #APsdrg4sCLqfRfc0Rs by hakui@tuusin.misono-ya.info
2022-11-23T01:46:24.114137Z
0 likes, 0 repeats
@drq personal instance wins again :smug5:
(DIR) Post #APse5sSMyDWXtNNCFM by hakui@tuusin.misono-ya.info
2022-11-23T01:48:57.437719Z
2 likes, 0 repeats
hitting 3 years in 2 days and probably can last two more before giving way if i don't update anything ever
(DIR) Post #APseB8I1Wwx4Rh2XNg by hakui@tuusin.misono-ya.info
2022-11-23T01:49:55.051782Z
0 likes, 0 repeats
won't be looking forward to remaking after it dies with the latest version though
(DIR) Post #APserzQkLRfjQAYWMS by benis@cawfee.club
2022-11-23T01:56:33.653570Z
0 likes, 0 repeats
@hakui the finest quality g*rman software
(DIR) Post #APsewqf0NYvVfYXesK by hakui@tuusin.misono-ya.info
2022-11-23T01:58:32.267945Z
0 likes, 0 repeats
@benis no the parts i'm not looking forward to are the gleasonated features like (You) next to your own @
(DIR) Post #APsf1nWRTRUVNtteeO by benis@cawfee.club
2022-11-23T01:59:24.472529Z
0 likes, 0 repeats
@hakui I mean the part where it's a timebomb
(DIR) Post #APsf67G42RdBkiIMKW by benis@cawfee.club
2022-11-23T02:00:10.972529Z
0 likes, 0 repeats
@hakui is this why cawfee is fucking dying? @grips
(DIR) Post #APsf7iSZD1SLQ9uF3w by hakui@tuusin.misono-ya.info
2022-11-23T02:00:29.354683Z
0 likes, 0 repeats
@benis some igadgets' planned obsolescence lasts shorter than that
(DIR) Post #APsf9ShAn9JN6jZQp6 by hakui@tuusin.misono-ya.info
2022-11-23T02:00:48.944322Z
0 likes, 0 repeats
@benis @grips what symptoms are you getting? general slowness?
(DIR) Post #APsfKbIx7fW8ziYLVQ by grips@cawfee.club
2022-11-23T02:02:41.676015Z
0 likes, 0 repeats
@hakui @benis More or less. High load -> timeouts.
(DIR) Post #APsfPWS2ax0rOE9PW4 by birdulon@shpposter.club
2022-11-23T02:03:42.815395Z
1 likes, 0 repeats
@hakui (You) @benis sounds like a funny feature, hope my admin adds it one day
(DIR) Post #APsfPqqskIlcf3vX0q by FabolousIrving@ryona.agency
2022-11-23T02:03:02.847856Z
0 likes, 0 repeats
@drq and somehow you think that joining Mastodon will fix the problem.
(DIR) Post #APsfV4SHb3baIauSeW by hakui@tuusin.misono-ya.info
2022-11-23T02:04:42.885067Z
0 likes, 0 repeats
@grips @benis where the notifications panel momentarily gets "unable to fetch"?
(DIR) Post #APsfVnpCufgH0iyu8G by hakui@tuusin.misono-ya.info
2022-11-23T02:04:51.357629Z
1 likes, 0 repeats
@birdulon @benis :You:
(DIR) Post #APsfdolrHPJKGGEkPg by birdulon@shpposter.club
2022-11-23T02:06:17.567594Z
0 likes, 0 repeats
@hakui @benis bleh, BBCode was rejected and the html silently stripped the span styling
(DIR) Post #APsfgba8lxjOE15KfQ by benis@cawfee.club
2022-11-23T02:06:37.290818Z
0 likes, 0 repeats
@hakui @grips and timelines too
(DIR) Post #APsfidaWHitx1gEPke by hakui@tuusin.misono-ya.info
2022-11-23T02:07:08.841243Z
1 likes, 0 repeats
@birdulon @benis >n.text is undefinedtime to say nigger again
(DIR) Post #APsfkLGfN00Imnl3WS by grips@cawfee.club
2022-11-23T02:06:35.627242Z
0 likes, 0 repeats
@hakui @benis Yeah, everything throws that from time to time.Also "property 'match' is undefined" or something when I try to post in a bad moment, all sorts of stuff.
(DIR) Post #APsfnK1qQv4VoPFKbY by benis@cawfee.club
2022-11-23T02:07:29.704333Z
0 likes, 0 repeats
@grips @hakui why are you up anyway
(DIR) Post #APsfo9De6noaZm9ya0 by grips@cawfee.club
2022-11-23T02:07:58.145513Z
0 likes, 0 repeats
@benis @hakui I was cooking and writing my thesis.
(DIR) Post #APsfsqKnkTRhSEkIdM by benis@cawfee.club
2022-11-23T02:08:34.250364Z
1 likes, 0 repeats
@grips @hakui glhf
(DIR) Post #APsfuDewVr3w5Jp5KS by grips@cawfee.club
2022-11-23T02:09:03.031523Z
0 likes, 0 repeats
@benis @hakui about to suy off
(DIR) Post #APsfzeafoKt33fPvxg by benis@cawfee.club
2022-11-23T02:10:13.240553Z
0 likes, 0 repeats
@grips @hakui I still have three hours left in this shift, no suyation for me
(DIR) Post #APsg2hWHNQfl0loaqu by hakui@tuusin.misono-ya.info
2022-11-23T02:10:47.864549Z
2 likes, 0 repeats
@benis @grips oh i get that once in a while toomemento mori
(DIR) Post #APsg5073DeSbFw6xsm by hakui@tuusin.misono-ya.info
2022-11-23T02:11:11.750402Z
2 likes, 0 repeats
@benis @grips pat pat
(DIR) Post #APsgBFQFDAlITX4G1o by grips@cawfee.club
2022-11-23T02:11:15.507730Z
1 likes, 0 repeats
@benis @hakui I see, then ride on :yeenaw:
(DIR) Post #APsgCqGlhT0R2oOaVE by benis@cawfee.club
2022-11-23T02:11:28.101222Z
2 likes, 1 repeats
@hakui @grips the real pleroma was the friends we made along the way
(DIR) Post #APsgWap8ptmSvrtK0u by deadheat@cawfee.club
2022-11-23T02:15:02.179270Z
2 likes, 0 repeats
@grips @hakui @benis Reminder that whatever you do, the most important measure to keep the instance as light and stable as possible is to never update Pleroma. Thank you friend.
(DIR) Post #APsgkckGUOoowgIiCO by hakui@tuusin.misono-ya.info
2022-11-23T02:18:43.389555Z
1 likes, 0 repeats
@deadheat @grips @benis the only time i updated was for @shpuld 's FE optimization so my phone doesn't explode when i phonepost
(DIR) Post #APsgqzvxBhs2bJo7l2 by grips@cawfee.club
2022-11-23T02:19:45.822869Z
0 likes, 0 repeats
@deadheat @benis @hakui This sounds good until the versions diverge so much that federation breaks entirely (I've heard of an instance running 1.x that eventually ran into this).
(DIR) Post #APshmc5M0toHQrg4KO by deadheat@cawfee.club
2022-11-23T02:30:16.193680Z
2 likes, 0 repeats
@grips @benis @hakui smuglo.li was actually on 1.x to its last day
(DIR) Post #APsqt8RVWPuz6zDy4m by train@hachyderm.io
2022-11-23T04:12:15Z
0 likes, 0 repeats
@drq Well shit I wish I would of found this wonderful gem like 1 day ago :)..
(DIR) Post #APszFznQdOi4aZtCvA by tennoseremel@mstdn.io
2022-11-23T05:45:57Z
0 likes, 0 repeats
@drq And after they sort they DB problems (if that ever happens) it would be nice to have a good usable default theme, and not… that :blobcatderpy:
(DIR) Post #APtBMnsaXQ256gJciu by drq@mastodon.ml
2022-11-23T08:01:41Z
0 likes, 0 repeats
@catgirl to my knowledge, still is.@FloatingGhost
(DIR) Post #APtBXh3wDvBV9Loicy by drq@mastodon.ml
2022-11-23T08:03:41Z
0 likes, 0 repeats
@cheesus_crust @Hyolobrika just throwing more resources at the problem doesn't really solve it.
(DIR) Post #APtBs58aQHwvbniHMO by kaede@social.inex.rocks
2022-11-23T08:07:23Z
0 likes, 0 repeats
@drq @catgirl @FloatingGhost Expired mentality was on Akkoma during the last (in both senses) incident
(DIR) Post #APtUNZap2T3UDU5OdM by soapone@pone.social
2022-11-23T11:34:49Z
0 likes, 0 repeats
@drq Isn't pleroma written in PHP?Start with that problem.
(DIR) Post #APtUQwblvP00Sx8bdA by drq@mastodon.ml
2022-11-23T11:35:23Z
0 likes, 0 repeats
@soapone It's in Elixir, a dialect of Erlang.Language is not the problem here, the architecture is.
(DIR) Post #APtUXbfGBwBdXMwiuG by thatbrickster@shitposter.club
2022-11-23T11:36:38.626418Z
0 likes, 0 repeats
@soapone Pleroma is written in Elixir and webshit (HTML/CSS/JS). I don't believe there to be any PHP.@drq
(DIR) Post #APtUkL7D24LxyX5gVk by Thegreenman@sunny.garden
2022-11-23T11:38:52Z
0 likes, 0 repeats
@drqAs someone who wants to start a pleroma instance, I'd like to know why the data storage fails.
(DIR) Post #APtVam6ZviXIk0naNc by opal@ap.maladaptive.art
2022-11-23T11:48:23.100966Z
0 likes, 0 repeats
@soapone @drq no it isnt, where would anyone come up with that
(DIR) Post #APtVkxJV70nmOohJcu by opal@ap.maladaptive.art
2022-11-23T11:50:09.508728Z
0 likes, 0 repeats
@drq i really want to build an alternative server but its such a big project for me to just bite the bullet on right now
(DIR) Post #APtVwokWmM93JTzmIS by drq@mastodon.ml
2022-11-23T11:52:18Z
1 likes, 0 repeats
@opal Yes. Like, a drop-in replacement with a convenient data migration script.Frontend shall stay, because honestly, it's great when themed right.
(DIR) Post #APtW4HVeFSLiXPavsu by opal@ap.maladaptive.art
2022-11-23T11:53:43.012155Z
0 likes, 0 repeats
@drq yeah i wont be developing a frontend for mine because i personally want to run it without one, but mastoapi compatibility should allow any frontend to work
(DIR) Post #APtWgPhQFMPmwVHiRU by drq@mastodon.ml
2022-11-23T12:00:33Z
0 likes, 0 repeats
@opal Pleroma once was a direct replacement for GNU Social.Looks like it itself has to be replaced now.
(DIR) Post #APtWoBQPCdCOzJ1vpw by opal@ap.maladaptive.art
2022-11-23T12:02:00.363132Z
0 likes, 0 repeats
@drq ive seen this as inevitable for a while, given its architecture
(DIR) Post #APtX8EqGCxRvNRgdCy by crystal@tsunde.ru
2022-11-23T12:02:14.972375Z
0 likes, 0 repeats
@drq @soapone what's exactly wrong with the architecture tho
(DIR) Post #APtX8FGqc6iUhu7reK by mo@mastodon.ml
2022-11-23T12:05:33Z
0 likes, 0 repeats
@crystal storing JSON in database, and creating timelines from them. Timelines are very complex query i guess, and performance degrades to zero when DB becomes too large (Mastodon, for example, caches timelines in Redis)@drq @soapone