Skip to main content


I switched libranet.de from stable to develop. The dbstructure update is running for more than 10 hours now and it's still not finished. 🤔 Altering the post-user table takes forever.
@helpers@forum.friendi.ca
in reply to Steffen K9 🍮

@Steffen K9 🍮
10 hours is a lot.
Sometimes the instance gets stuck in maintenance mode.
You could try a ./bin/console maintenance 0
After that, check if the instance is working fine and the db update is finished.
in reply to Raroun

I guess mytop is very handy to have a glance at the running db processes.
in reply to Steffen K9 🍮

@Steffen K9 🍮 @Raroun Also check with iotop for bottle necks on I/O side. E.g. I set some kernel proccesses to idle on my gaming/multi-media system. Maybe changing processes with jbd2 at the start may help read/write performance.
in reply to Steffen K9 🍮

That table has a size of 70 GB. 😳 After 17.5 hours the alter table query is still running. Geez!
in reply to Steffen K9 🍮

wow .. I switched with opensocial.at to develop as well (109GB DB). It took some hours, but not more than "just" one night. But it was with my old db settings. I recently tuned some parameters like you're using.
in reply to Steffen K9 🍮

Are there any account settings that us users could individually tweak when it comes back up to make this less painful in the future?
in reply to alysonsee (Mdn)

nope. but thanks. that was the first time a database update was such a pain.
in reply to Steffen K9 🍮

Any news, Steffen? About 11 hours ago, I saw that the update made progress, and a reload of the page prompted me to log in. But once I entered my credentials, the login process didn’t complete. Now the libranet.de site doesn’t load at all.
in reply to alysonsee (Mdn)

update is finished after nearly 2 days. the queue is long. there's a lot of delayed posts to deliver now. should be done in a couple of hours.
in reply to Kasel

yep. update is finished after nearly 2 days. the queue is long. there's a lot of delayed posts to deliver now. should be done in a couple of hours.
in reply to Steffen K9 🍮

FYI, it looks like it’s still catching up. I thought I had caught up on all my notifications only to come back a few minutes ago to see more notifications about events from before I last checked notifications. And one of my connections let me know that I replied to a post that she had deleted and is confused about why I could see it. She actually replied twice to me. The time stamps say that she posted them each about four hours ago. But I am just now seeing them come in a few minutes apart.
in reply to alysonsee (Fca)

Your “yep. sorry. it’s working again after 2 days” post from 16 hours ago just showed up.
in reply to Steffen K9 🍮

Thank you for the update. Iss this why libranet.de is offline currently?

Friendica Support reshared this.

in reply to Noam Bergman

yes. should be working again. just a pretty high load until all postponed deliveries are done.
Unknown parent

Steffen K9 🍮
Yep. That feature is half done. The only thing that's missing is the UI/frontend for the votes.