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
Conversation
Notices
-
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Sunday, 29-Jan-2023 21:44:46 JST Steffen K9 ? -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Sunday, 29-Jan-2023 22:46:50 JST Steffen K9 ? @raroun@friendica.opensocial.space I guess mytop is very handy to have a glance at the running db processes.
In conversation permalink -
Embed this notice
raroun (raroun@friendica.opensocial.space)'s status on Sunday, 29-Jan-2023 22:46:52 JST raroun @steffen
You can also check if the db is still busy via „top“ or „htop“.In conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Sunday, 29-Jan-2023 22:48:10 JST Steffen K9 ? @raroun@friendica.opensocial.space The DB is huge. So structure updates take some time. But this is really annoying. ☺️
In conversation permalink -
Embed this notice
raroun (raroun@friendica.opensocial.space)'s status on Sunday, 29-Jan-2023 22:48:11 JST raroun @steffen
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 conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Monday, 30-Jan-2023 02:10:43 JST Steffen K9 ? @raroun@friendica.opensocial.space yep. My DB is nearly 200 GB.
In conversation permalink -
Embed this notice
raroun (raroun@friendica.opensocial.space)'s status on Monday, 30-Jan-2023 02:10:44 JST raroun @steffen
So you probably have to wait ?
On a 50 Gigabyte DB the post-User table altering took around 10 minutes for me.In conversation permalink -
Embed this notice
alysonsee (alysonsee@mastodon.social)'s status on Monday, 30-Jan-2023 02:11:04 JST alysonsee @steffen Whenever there is downtime, I am reminded how much work you do to keep us connected to the Fediverse and that it has been far too long since I have donated to offset the costs. You still accepting €s at https://liberapay.com/SteffenK9/ ?
In conversation permalink Attachments
Steffen K9 ? likes this. -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Monday, 30-Jan-2023 02:11:19 JST Steffen K9 ? @alysonsee@mastodon.social yes, I do.
In conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Monday, 30-Jan-2023 05:59:48 JST Steffen K9 ? @helpers@forum.friendi.ca That table has a size of 70 GB. ? After 17.5 hours the alter table query is still running. Geez!
In conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:24:26 JST Steffen K9 ? @kasel@mastodon.social @helpers@forum.friendi.ca 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 conversation permalink -
Embed this notice
Kasel (kasel@mastodon.social)'s status on Tuesday, 31-Jan-2023 06:24:31 JST Kasel In conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:25:36 JST Steffen K9 ? @alysonsee@mastodon.social @helpers@forum.friendi.ca 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 conversation permalink -
Embed this notice
alysonsee (alysonsee@mastodon.social)'s status on Tuesday, 31-Jan-2023 06:25:37 JST alysonsee @steffen @helpers 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 conversation permalink Attachments
-
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:29:17 JST Steffen K9 ? @noam@sciences.social yes. should be working again. just a pretty high load until all postponed deliveries are done.
In conversation permalink -
Embed this notice
Noam Bergman (noam@sciences.social)'s status on Tuesday, 31-Jan-2023 06:29:23 JST Noam Bergman @steffen
Thank you for the update. Iss this why libranet.de is offline currently?In conversation permalink Attachments
-
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:30:57 JST Steffen K9 ? @schmaker@schmaker.eu @helpers@forum.friendi.ca no. libranet.de was never affected by that. it was "only" a very slow database update.
In conversation permalink Attachments
-
Embed this notice
schmaker (schmaker@schmaker.eu)'s status on Tuesday, 31-Jan-2023 06:30:59 JST schmaker @steffen
I just wonder - can't it be related to acitivypubtroll.cf attack?
@helpersIn conversation permalink Attachments
-
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:31:30 JST Steffen K9 ? @thewalkingdeaf@mastodonapp.uk @helpers@forum.friendi.ca @libranet@mastodon.social yep. sorry. it's working again after 2 days.
In conversation permalink -
Embed this notice
steve (thewalkingdeaf@mastodonapp.uk)'s status on Tuesday, 31-Jan-2023 06:31:33 JST steve @steffen @helpers @libranet Any further updates? Not even seeing the updating page any more.
Thanks ?
In conversation permalink -
Embed this notice
Robert Logger 🇳🇱 [Mastodon] (logger@mastodon.nl)'s status on Tuesday, 31-Jan-2023 06:31:52 JST Robert Logger 🇳🇱 [Mastodon] In conversation permalink Steffen K9 ? likes this. -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:32:45 JST Steffen K9 ? @alysonsee@mastodon.social @helpers@forum.friendi.ca nope. but thanks. that was the first time a database update was such a pain.
In conversation permalink -
Embed this notice
alysonsee (alysonsee@mastodon.social)'s status on Tuesday, 31-Jan-2023 06:32:46 JST alysonsee @steffen @helpers 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 conversation permalink -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:34:41 JST Steffen K9 ? @philipp@opensocial.at after 2 days I'm back. ? Btw. half the node's config was lost. sorry for the bad news about node.config.php migration. ?
In conversation permalink -
Embed this notice
Philipp Holzer (philipp@opensocial.at)'s status on Tuesday, 31-Jan-2023 06:34:43 JST Philipp Holzer @steffen 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 conversation permalink Attachments
-
Embed this notice
roland (roland@f.haeder.net)'s status on Tuesday, 31-Jan-2023 06:35:39 JST roland @steffen Do you need to keep so much around? Maybe setup some purging? Or is it already enabled? In conversation permalink Steffen K9 ? likes this. -
Embed this notice
clacke at libranet.de is my main (notclacke@misskey.de)'s status on Tuesday, 31-Jan-2023 06:35:50 JST clacke at libranet.de is my main @steffen Thanks, that explains it. ?
In conversation permalink Steffen K9 ? likes this. -
Embed this notice
Steffen K9 ? (steffen@misskey.de)'s status on Tuesday, 31-Jan-2023 06:36:13 JST Steffen K9 ? @notclacke sorry for the downtime. should work again now.
In conversation permalink -
Embed this notice
alysonsee (alysonsee@libranet.de)'s status on Wednesday, 01-Feb-2023 01:16:44 JST alysonsee @steffen Your “yep. sorry. it’s working again after 2 days” post from 16 hours ago just showed up. In conversation permalink Steffen K9 ? likes this. -
Embed this notice
alysonsee (alysonsee@libranet.de)'s status on Wednesday, 01-Feb-2023 01:16:46 JST alysonsee @steffen 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 conversation permalink -
Embed this notice
Robert Logger 🇳🇱 [Friendica] (logger@libranet.de)'s status on Wednesday, 01-Feb-2023 15:57:56 JST Robert Logger 🇳🇱 [Friendica] @steffen @noam But it's working, that's the most important thing. In conversation permalink Steffen K9 ? likes this. -
Embed this notice
Robert Logger 🇳🇱 [Friendica] (logger@libranet.de)'s status on Friday, 03-Feb-2023 02:49:44 JST Robert Logger 🇳🇱 [Friendica] @alfred @steffen Thanks. It gave some funny results yesterday like answers without questions.... By the way, is there a possibility that we can react in the future on polls? In conversation permalink -
Embed this notice
alfred (alfred@libranet.de)'s status on Friday, 03-Feb-2023 02:49:46 JST alfred @steffen The queue of deliveries and items to be fetched is completely processed. ? ✨ In conversation permalink
-
Embed this notice