mastodon.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
The original server operated by the Mastodon gGmbH non-profit

Administered by:

Server stats:

360K
active users

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.

LIBRANET.de Announcements

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 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 In such cases it's often much faster to drop indices, alter table, recreate indices.