Uptime update
So we're at the next hurdle in keeping Friendica.World stable.
We now hit an issue where a cleanup job hangs the database. The database query it fires takes too long, and after a while this starts locking other processes in the database. Then the database connections fill up to the maximum, and the site becomes available.
I've raised an issue for this : github.com/friendica/friendica… and someone proposed a workaround they are using, we might try that as well until a fix has been created.
expired content cleanup hangs the instance · Issue #14828 · friendica/friendica
I have searched open and closed issues for duplicates Bug Description There's a query that runs for a very long time (> 30 minutes) and causes all other sessions in MariaDB to go into Waiting for t...GitHub
like this
reshared this
𓂀 Cynni 💜
in reply to Ruud • •Thank you for all the hard work that you do!
I know I keep Tooting that it's offline every now and then (although yesterday, it seemed more off than on when I tried to use it). But I am really grateful for all the hard work. And I wish I was a Fedi wizzkid, so I could jump in and try to help out...
The next few months I am having some more expensive bits that need to be done and paid for. But after that, I'll do my best to send a little cup of Ko-fi coffee your way (I'll check how I can donate when I have some funds). I also wish I had more funds, so I could easily support the Fedi bits that provide me with a home for my social media needs... Alas...
Anywhoo.... Thanks so much for your hard work and I hope that the temporary fix will help to resolve (some of) the issues!
Adam likes this.
𓂀 Cynni 💜
in reply to 𓂀 Cynni 💜 • •Ruud likes this.
Adam
in reply to Ruud • •like this
𓂀 Cynni 💜 and Mark like this.
Ruud
in reply to Ruud • •like this
Adam, gargle, 𓂀 Cynni 💜 and Anders Nicolaysen like this.
gargle reshared this.
Adam
in reply to Ruud • •@Ruud I'd charitably call that "less than ideal"... ;)
Fingers crossed!
like this
Ruud and 𓂀 Cynni 💜 like this.