@mint@shitpisscum Wait untill someone figures out a way to make the "proxy" domain point to something that's not Soapbox. I wonder if I already saw that kind of setup somewhere :thinkerman:
A question about pleroma's totally sensible and intuitive db schema: my /api/v1/instance/peers returns ~11000 instances but there's only ~5000 in the instances table. Where the fuck are the rest of the instances stored?
@7666@Economic_Hitman@shitpisscum
>what are you goofballs doing to cause this
I left it federating for over 2 years so the db is too big (~11.000.000 activities) and is often timing out. For some reason Pleroma is extremely bad at handling db timeouts and is often locking up (not crashing, if it was crashing systemd would restart it).
FAQ
How are you going to fix it
Getting a more powerful db server.
Alternative way would be to hire Erlang devs to fork the project and implement some sort of exception handling but then you're stuck with paying someone to maintain your own fork. And your db is still timing out, you just kind of hide it (getting a blank tl instead of "502 uwu shit's fucked hihih"). So yea, I'll just get a more powerful server lol.
What about pg_repack, updating Pleroma, pgtune.leopard.in.ua etc?
Might give some temporary performace boost but I guarantee it'll be back here in a few months.
Logs?
[error] Internal server error: %DBConnection.ConnectionError{message: "connection not available and request was dropped from queue after 414ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:\n\n 1. Ensuring your database is available and that you can connect to it
>mine's fine
Congrats, you won the "Works on my machine" award. You will be contacted by ShitPissCum Services South Eastern Europe within the next 5 to 10 week days to arrange the delivery
@dogsexvomitbot and @pigpoopballsbot both experienced a brief downtime due to the "rebooted the computer but forgot to start the scripts, should probably make a job that starts them on boot but whatever" issue. Both bots should be back up and running. Sorry for the inconvenience and thank you for choosing ShitPissCum Services South Eastern Europe @shitpisscum@shitpisscum :bob:
Home tl is broken but known network and notifications somehow work. Haven't seen this failure mode yet lol, will investigate later. Also federation seems to be working better than it used to in the past week or so :thinkerman:
Owner and operator of ShitPissCum Services South Eastern Europe. Visit http://shitpisscum.net/ to learn more about the services we provide.One of many admins of cum.salon and cum.campTech, electronic music and general purpose shitposting. Posts are often NSFW, this is not a family friendly instance.Backup accounts:Primary:@shitpisscum@social.mrhands.horse Secondary:@shitpisscum@freecumextremist.com@shitpisscum@bae.st @shitpisscum@poa.st @shitpisscum@paypig.org (RIP)Contact email:shitpisscum@cock.lishitpisscum@goatse.emailnostr npub1jh700f6mznn4t7eeycprm4nsyv7yrd5ljpyhf99gc328hv296nps4f6am8Gimme some fake internet money pls: monero:43xTi1m33drNbX3VFQJR5hXgeH1F2TZ2zhdsPzyHqXxdNd25ChJNscjJu9XYcLXdh9ASuJa9ECkdjf5TEACruYh6FmAxwa6ubiq:0x86A70ec0176e03c5c2a9Be8a6faA0d381661FF70bitcoin:bc1q6dmxkzwgfunpcxsrkp2j3m5em3ksfrnq2a6xux