Friendica
  • Přihlásit se
Steffen K9 🍮
Steffen K9 🍮

Steffen K9 🍮

steffen@misskey.de

Steffen K9 🍮

steffen@misskey.de
Operator of LIBRANET.de, venera.social and misskey.de, #Fediverse enthusiast, #Coffee addict. I like #Music, #Cycling, #Relaxing, #ScienceFiction, #Linux, #Nextcloud, #Friendica, #Misskey and you! 😀
ActivityPub
2023-02-06 14:02:23 2023-01-29 12:45:30 2023-01-29 12:44:43 4190625

Steffen K9 🍮
Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

3 years ago • •

Steffen K9 🍮

3 years ago • •


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
@Friendica Support
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Raroun
friendica - Link to source

Raroun

in reply to Steffen K9 🍮 • 3 years ago • •
@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.
@Steffen K9 🍮
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Raroun
friendica - Link to source

Raroun

in reply to Steffen K9 🍮 • 3 years ago • •
@Steffen K9 🍮
You can also check if the db is still busy via „top“ or „htop“.
@Steffen K9 🍮
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Raroun

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to Raroun • 3 years ago • •
I guess mytop is very handy to have a glance at the running db processes.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Roland Häder🇩🇪
friendica - Link to source

Roland Häder🇩🇪

in reply to Steffen K9 🍮 • 3 years ago • •
@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.
@Steffen K9 🍮 @Raroun
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to Steffen K9 🍮 • 3 years ago • •
That table has a size of 70 GB. 😳 After 17.5 hours the alter table query is still running. Geez!
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Roland Häder🇩🇪
friendica - Link to source

Roland Häder🇩🇪

in reply to Steffen K9 🍮 • 3 years ago • •
@Steffen K9 🍮 Do you need to keep so much around? Maybe setup some purging? Or is it already enabled?
@Steffen K9 🍮
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Roland Häder🇩🇪

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to Roland Häder🇩🇪 • 3 years ago • •
it is enabled.
  •  Detected languages
  •  Raw content
  •  Share via ...

Anders Rytter Hansen likes this.

in reply to Steffen K9 🍮

Philipp Holzer
friendica - Link to source

Philipp Holzer

in reply to Steffen K9 🍮 • 3 years ago • •
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.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

alysonsee (Mdn)
mastodon - Link to source

alysonsee (Mdn)

in reply to Steffen K9 🍮 • 3 years ago • •
Are there any account settings that us users could individually tweak when it comes back up to make this less painful in the future?
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to alysonsee (Mdn)

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to alysonsee (Mdn) • 3 years ago • •
nope. but thanks. that was the first time a database update was such a pain.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Robert Logger 🇳🇱 [Mastodon]
mastodon - Link to source

Robert Logger 🇳🇱 [Mastodon]

in reply to Steffen K9 🍮 • 3 years ago • •
Good luck.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Robert Logger 🇳🇱 [Mastodon]

Robert Logger 🇳🇱 [Mastodon]
mastodon - Link to source

Robert Logger 🇳🇱 [Mastodon]

in reply to Robert Logger 🇳🇱 [Mastodon] • 3 years ago • •
Since Libranet.de runs on Tusky and Misskey doesn't, I miss it!
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

steve
mastodon - Link to source

steve

in reply to Steffen K9 🍮 • 3 years ago • •

@libranet Any further updates? Not even seeing the updating page any more.

Thanks 👍

@LIBRANET.de Announcements
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to steve

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to steve • 3 years ago • •
yep. sorry. it's working again after 2 days.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Schmaker
friendica (DFRN) - Link to source

Schmaker

in reply to Steffen K9 🍮 • 3 years ago z Fedilab •
@Steffen K9 🍮
I just wonder - can't it be related to acitivypubtroll.cf attack?
@Friendica Support
@Friendica Support @Steffen K9 🍮
  •  Detected languages
  •  Raw content
  •  Share via ...

Anders Rytter Hansen likes this.

Friendica Support reshared this.

in reply to Schmaker

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to Schmaker • 3 years ago • •
no. libranet.de was never affected by that. it was "only" a very slow database update.
  •  Detected languages
  •  Raw content
  •  Share via ...

Friendica Support reshared this.

in reply to Steffen K9 🍮

alysonsee (Mdn)
mastodon - Link to source

alysonsee (Mdn)

in reply to Steffen K9 🍮 • 3 years ago • •
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.
  •  Detected languages
  •  Raw content
  •  Share via ...

Anders Rytter Hansen likes this.

in reply to alysonsee (Mdn)

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to alysonsee (Mdn) • 3 years ago • •
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.
  •  Detected languages
  •  Raw content
  •  Share via ...
in reply to Steffen K9 🍮

Kasel
mastodon - Link to source

Kasel

in reply to Steffen K9 🍮 • 3 years ago • •
It's working a little bit now.
  •  Detected languages
  •  Raw content
  •  Share via ...

Anders Rytter Hansen likes this.

in reply to Kasel

Steffen K9 🍮
misskey - Link to source

Steffen K9 🍮

in reply to Kasel • 3 years ago • •
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.
  •  Detected languages
  •  Raw content
  •  Share via ...

Serafina Pekkala likes this.

in reply to Steffen K9 🍮

Kasel
mastodon - Link to source

Kasel

in reply to Steffen K9 🍮 • 3 years ago • •
🥰
  •  Raw content
  •  Share via ...
⇧