The Friendica nodes libranet.de and venera.social are currently in maintenance mode. There is an update for the database structure. This has now been running for 26 hours. There is nothing I can do except waiting until it is completed. Sorry for the long service interruption.
Update: The database structure update on venera.social is finally done. This node is up and running again. Unfortunately, the structure update on libranet.de isn't completed yet. I can't say how long this will take. The process is painfully slow. I'm very sorry about the terrible situation. But all I can do is waiting until the database update is completed.
I found out that ALTER TABLE statements on MySQL/MariaDB can be very, very slow when the query is executed on very large tables with many indices. The post-user table (that's the one that is responsible for the long running update) is huge. The table has a size of 140 GB and has 36 indices.
I'll continue to observe the progress. I'm unhappy about the situation and want to apologize for the long downtime.
@libranet Thanks for the update! Running the nodes is appreciated.
@libranet Looks like it’s at least inching forward. That “update post-user table” took a long time. Let us know if you need us to clean out old posts or change any settings to help freshen up the state of things.
@alysonsee Now it's at "updating post-user table" again.
@kasel I’m not sure if that’s progress or not. Such a bummer.
@libranet Thanks for the update. I was worried it had crashed and disappeared completely (happened to me on Firefish) so pleased to hear we’ll be back to normal soon. Thanks for looking after this for us.
@libranet Is there any update on this? I can’t see any progress from earlier in the week.
@libranet@mastodon.social I am here, in this instance, precisely, to receive this kind of announces.
Thanks for saying.
But...logically, i will be in this instance, not only to receive announces.
Hello!
#ADifferentIntroduction
@libranet Hi, any update or time estimate?
@libranet Thanks for your update of the situation.
@libranet no need to apologize you have given us fantastic platform out of the kindness of your heart and/or for the fun of it for years without significant downtime and never even asking for a dime.
Thanks for working on it.
Is there any evidence that the update will succeed in reasonable time?
One alternative plan would be to interrupt the process, back out the software update, and restore everything from the latest back up.
@libranet do you have enough visibility to the progress to update us more than /5d?
@libranet
> Last steps to repair the database, I hope...
Endspurt beim Daumendrücken!?!