Conversation

Notices

1. shitpisscum :verified: (shitpisscum@shitpisscum.mooo.com)'s status on Sunday, 12-Feb-2023 22:56:58 JST shitpisscum :verified:
   :alert: ATTENTON :alert: ShitPissCum Social is back online!
   What happened

   Database became too big and it was constantly timing out, causing Pleroma to completely shit itself

   How I fixed it

   First I set a cron job to restart Pleroma service every hour to avoid too much downtime untill I figure out what to do. Then I decided to do the most obvious thing which was to migrate the database to a more powerful machine. First backup didn't restore properly for whatever reason (I'm pretty sure it was because the old db server is Potgres 12 and the new one is Postgres 14 and I didn't use --quote-all-identifiers but someone else is gonna say there's no way that was the issue. Who cares, it works now). Then I ran sudo -Hu postgres vacuumdb --all --analyze-in-stages as recommended by Pleroma maintainers and it seems to be working now.

   What next

   I'm running Pleroma 2.4.3 and a few people told me there's a significant performance improvement in 2.5.0 so that's the next thing I'm going to do (have to be careful with that because Pleroma's built in updater can brick the whole thing if you look at it the wrong way, talking from experience)

   
   

   Thank you for using ShitPissCum Services

   •  likes this.
   • top dog (dcc@pp.dembased.xyz)'s status on Monday, 13-Feb-2023 01:35:24 JST top dog

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     • The Problem
     @marine @p @verita84 @shitpisscum > phone are good bros HAR HAR HAR
     ok brk
   • The Problem (marine@breastmilk.club)'s status on Monday, 13-Feb-2023 01:35:25 JST The Problem

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     • top dog

     @verita84 @p @dcc @shitpisscum sounds like a skill issue if you ask me

   • Vivi Nella Verita :Debian_logo: (verita84@poster.place)'s status on Monday, 13-Feb-2023 01:35:26 JST Vivi Nella Verita :Debian_logo:

     in reply to

     • pistolero :thispersondoesnotexist:
     • top dog
     @dcc @p @shitpisscum
     
     I get it, i hate typing a complete sentence on them. IOS and Android are both shitty lol. IOS just slightly better keyboard
   • top dog (dcc@pp.dembased.xyz)'s status on Monday, 13-Feb-2023 01:35:27 JST top dog

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     • top dog
     @verita84 @p @shitpisscum *no use to trust
     I fucking hate phones
   • top dog (dcc@pp.dembased.xyz)'s status on Monday, 13-Feb-2023 01:35:28 JST top dog

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     @verita84 @p @shitpisscum sir i have to use to trust Eskimo pussy fs's when i know what works wont lost me data
   • Vivi Nella Verita :Debian_logo: (verita84@poster.place)'s status on Monday, 13-Feb-2023 01:35:29 JST Vivi Nella Verita :Debian_logo:

     in reply to

     • pistolero :thispersondoesnotexist:
     • top dog
     @dcc @p @shitpisscum
     
     We will see if Lain takes another 2 year break.
     
     BTRFS is reliable now, it's not the old days. Distros are even using it by default now.
   • top dog (dcc@pp.dembased.xyz)'s status on Monday, 13-Feb-2023 01:35:30 JST top dog

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     @p @verita84 @shitpisscum thank you p, you explained better than i could
   • pistolero :thispersondoesnotexist: (p@freespeechextremist.com)'s status on Monday, 13-Feb-2023 01:35:31 JST pistolero :thispersondoesnotexist:

     in reply to

     • Vivi Nella Verita :Debian_logo:
     @verita84 @shitpisscum
     
     > You might as well switch to Akkoma at this point
     
     :vomit:
     
     > It has more features and is actually being developed on.
     
     So is Pleroma.
     
     > pg_backup and _pg_restore are not that reliable. You are safer storing the DB on btrfs and doing routine snapshots
     
     Zero major data loss instances on FSE, running continuously since 2018. Except the upload problem a long time back (which was a problem with rsync, not Postgres), we've never lost data. This is more than I can say for btrfs, which does seem to lose data.
     
     > so you never have to re-import the database again because its slow and unreliable.
     
     It's only slow because of that missing index, which is no longer missing.
   • Vivi Nella Verita :Debian_logo: (verita84@poster.place)'s status on Monday, 13-Feb-2023 01:35:32 JST Vivi Nella Verita :Debian_logo:

     in reply to
     @shitpisscum
     
     You might as well switch to Akkoma at this point, It has more features and is actually being developed on. That's what I did for 3 instances which started having similar issues with you
     
     pg_backup and _pg_restore are not that reliable. You are safer storing the DB on btrfs and doing routine snapshots so you never have to re-import the database again because its slow and unreliable.
   • top dog (dcc@pp.dembased.xyz)'s status on Monday, 13-Feb-2023 01:36:59 JST top dog

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     • The Problem
     @marine @p @verita84 @shitpisscum >i am so good at irony
     sir the point is your saying a shitty product is fine because "skill issue" when infact its a flawed peace of tech
   • The Problem (marine@breastmilk.club)'s status on Monday, 13-Feb-2023 01:37:00 JST The Problem

     in reply to

     • pistolero :thispersondoesnotexist:
     • Vivi Nella Verita :Debian_logo:
     • top dog

     @dcc @p @verita84 @shitpisscum if you can’t type a single sentence on it, that’s a skill issue. Nowhere did I say that “phone good”; sounds like you have a skill issue in reading too. Might I suggest trying this?

   • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸 (phenomx6@fedi.pawlicker.com)'s status on Monday, 13-Feb-2023 03:24:28 JST 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸

     in reply to

     • Vivi Nella Verita :Debian_logo:
     • Paulo
     • Rock DJ :fedora: :vibe: 💢
     @verita84 @Paulo @dj @shitpisscum https://gitlab.eientei.org/eientei/pleroma/-/commits/pleroma-akkoma-emoji-port
     https://gitlab.eientei.org/eientei/pleroma-fe/-/commits/pleroma-akkoma-emoji-port
     
     Have fun
   • Rock DJ :fedora: :vibe: 💢 (dj@rojogato.com)'s status on Monday, 13-Feb-2023 03:24:29 JST Rock DJ :fedora: :vibe: 💢

     in reply to

     • Vivi Nella Verita :Debian_logo:
     • Paulo
     @verita84 @Paulo @shitpisscum
     If you want stability then rebased, works great with pleroma-fe. akkoma gave me problems, probably because I wanted to use mrf's but who knows. You do get less features than akkkoma.
   • Vivi Nella Verita :Debian_logo: (verita84@poster.place)'s status on Monday, 13-Feb-2023 03:24:29 JST Vivi Nella Verita :Debian_logo:

     in reply to

     • Paulo
     • Rock DJ :fedora: :vibe: 💢
     @dj @Paulo @shitpisscum
     
     
     We can react with any emoji my nigga. Nobody else has this :makima:
   • Paulo (paulo@marsey.moe)'s status on Monday, 13-Feb-2023 03:24:30 JST Paulo

     in reply to

     • Vivi Nella Verita :Debian_logo:
     @verita84 @shitpisscum at that point just switch to soapbox, it's fast, reliable and feature complete
   • Vivi Nella Verita :Debian_logo: (verita84@poster.place)'s status on Monday, 13-Feb-2023 03:24:30 JST Vivi Nella Verita :Debian_logo:

     in reply to

     • Paulo
     @Paulo @shitpisscum
     
     yeah, Akkoma or ReBased at this point. Once you switch, you won't be able to undo it