There are a lot of issues with lemmy 0.18.0. I started a discussion on the GitHub project on some of them. Feel free to go contribute to the discussion there.

https://github.com/LemmyNet/lemmy/issues/3314

For me, I have to do ‘url: “http://pictrs:8080/” ‘ instead of 127.0.0.1 in the config.hjson file

I checked this, and my lemmy.hconf file already has the host for pictrs set to http://pictrs:8080.

The only thing that has worked so far is manually unsetting my site’s image icon by unsetting it directly int he Database.

And yes… I see sync issues as well. I’ve responded to some comments multiple times because I didn’t see my original response at a later time.

I also added the proxy network to both lemmy-ui and pictrs, but that did not resolve the issue.

I had to manually remove the sites icon from the database for the site to start working again.

update site set icon = null where id = 1;

I’m going to try removing the proxy network and instead use pictrs:8080 on the internal network as that feels more secure.

Update: What “fixed” the pictrs issue for me was changing it from the internal address to my web site domain / external address.

Still not 100% though, plenty of other errors in the logs.

Note: this seems like it has something to do with the database, and something getting royally messed up post upgrade.

After trying all sorts of network hacks and updates, I eventually just decided to backup my Postgres container, and nuke it.

With a fresh Postgres DB running along with 0.18.0, my self hosted site is back online. Of course, my local post history and all my subs are gone… but at least my site is operational again.

I’d advise anyone self-hosting to not upgrade to 0.18.0 yet.

deleted by creator

deleted by creator

That sounds correct to me.

I wonder if these are real users or if someone wrote a script to register users via the lemmy API… 🤔

I self host! Very nice having an instance all to myself.

Too slow! 😀

Yes. Absolutely does happen on other instances that have thousands of users.

That actually sounds like something I would have enjoyed. I joined Reddit around the time it started taking over, I think.

That’s pretty neat! I’ve honestly never seen it mentioned on Reddit before, so got a bit excited to see someone mention it here, admittedly maybe too excited.

I really hope someone is doing some level of performance testing on those changes to make sure the changes fix the performance issues.

Have you tried enabling the slow query logs @[email protected]? I went through that exercise yesterday to try to find the root cause but my instance doesn’t have enough load to reproduce the conditions, and my day job prevents me from devoting much time to writing a load test to simulate the load.

I did see several queries taking longer than 500ms (up to 2000ms) but they did not appear related to saving posts or comments.

Oh, Big-O notation? I never thought I’d see someone else mention big O notation out in the wild!

:high-five:

I did see it, thanks. I’m hoping to find some time to contribute this week.

Welcome here, and thanks for creating the CR community.

Is it Thursday yet?