this post was submitted on 02 Oct 2023

158 points (98.2% liked)

Lemmy.World Announcements

29028 readers

4 users here now

This Community is intended for posts about the Lemmy.world server by the admins.

Follow us for server news 🐘

Outages 🔥

https://status.lemmy.world

For support with issues at Lemmy.world, go to the Lemmy.world Support community.

Support e-mail

Any support requests are best sent to [email protected] e-mail.

Report contact

DM https://lemmy.world/u/lwreport
Email [email protected] (PGP Supported)

Donations 💗

If you would like to make a donation to support the cost of running this platform, please do so at the following donation URLs.

If you can, please use / switch to Ko-Fi, it has the lowest fees for us

Join the team

founded 1 year ago

MODERATORS

158

[Done] Brief outage for Pictrs upgrade today Oct 2nd 18:30 CEST is finished (self.lemmyworld)

submitted 1 year ago* (last edited 1 year ago) by lwadmin to c/lemmyworld

26 comments fedilink hide all child comments

Edit : OK so the outage was less brief than expected. The upgrade of the 3GB pictrs database took over 1 hour, and the version 0.4 database is now 14.5 GB... But anyway, it seems to be working alright now!

We will upgrade pictrs today, from 0.3.1 to 0.4.4. This will enable us to switch to S3 storage later on, and is needed for more anti-CSAM tools. Outage should only involve picture uploads, and should be brief.

you are viewing a single comment's thread
view the rest of the comments

[–] ruud 18 points 1 year ago (1 children)

OK, the pictrs database upgrade is taking it's time... please wait.. ;-)

pictrs_1     | {"timestamp":"2023-10-02T16:31:44.746467Z","level":"WARN","fields":{"message":"new"},"target":"pict_rs::repo","span":{"name":"Migrating Database from 0.3 layout to 0.4 layout"},"spans":[]}

[–] bappity 10 points 1 year ago (1 children)

how's it faring? 👀

[–] ruud 10 points 1 year ago (1 children)

It's building a 0.4 database, which is already twice as big as the 0.3 one

[–] ruud 9 points 1 year ago (1 children)

It's grown from 3.1 GB to over 8GB and still running...

[–] [email protected] 8 points 1 year ago (2 children)

thats a lot of pictures

[–] antik 16 points 1 year ago (1 children)

And that's just his personal collection of feet pics

[–] ruud 13 points 1 year ago

Don't tell them about the feetish

[–] ruud 13 points 1 year ago (3 children)

That's not the pictures... The picture take up 1.2 TB.. it's just the database with the metadata about the pictures. (11.8 GB now...)

[–] 9point6 5 points 1 year ago* (last edited 1 year ago) (2 children)

I'm curious, how much storage in total is needed for a Lemmy instance like this one currently?

[–] ruud 7 points 1 year ago

1.2 TB for pictures and 100GB for Postgres

[–] [email protected] 5 points 1 year ago

For reference I run a pretty small instance. I'm at 34GB for the main database, and about 120GB of media. (Doesn't count backups)

My instance is much, much smaller though. A few hundred users, and probably only a couple dozen actually active.

[–] diffcalculus 4 points 1 year ago (2 children)

Who pays for that s3 storage?

[–] ruud 9 points 1 year ago

The people that donate to lemmy.world

[–] ruud 6 points 1 year ago

But it’s not in S3 yet. Still on disk.

[–] [email protected] 2 points 1 year ago

I know. Giant database = Giant × 10² amount of Pictures