My database backup was 5.4 GB and I had to upgrade from Postgresql 15 to 16. It took about 1.5 hours to do that.

But now I hope everything works.

I had big problems running Lemmy 0.19.1 and Nextcloud together on the same server. Each for them worked nice, but when they run together they hogged so many resources that I had to stop one of them. In addition to that there was the problem of my posts and comments not being federated correctly. Sometimes a restart would help for a while but then it would stop again. That's not fun when you're the only person on a server and no other server can see what you wrote. That made me use lemmy much less to be honest.

Anyway, let's see if 0.19.2 fixes some of those problems. I have a workaround for the load problem, I'm trying to switch from Nextcloud to Radicale for CardDav and CalDav and from Nextcloud to Syncthing for file syncing. And in the release notes they promis that they fixed the federation problems, so I'm hopeful.

The long awaited update of 0.19 is here so I upgraded. This gave me huge problems because the CPU load is constantly going up to 100 which brings my whole server down, not just Lemmy. There is a bug for it https://github.com/LemmyNet/lemmy/issues/4334 but it's not getting the traction I thought it would get since very many instances have this problem.

I tried to contain the problem in the docker instance, but somehow limiting load to 0.5 in docker-compose didn't do anything. Then further down in the bug in a comment someone suggested to do database.pool_size: 30 in lemmy.hjson because the default of 95 was to high. With then I got down the load to around 2 which is ok.

But with this higher load I had to shut down Nextcloud because that would then bring everything down together. My guess is that I didn't really optimize Nextcloud and I have so many services running that it's on the brink of not being able to run all of them together.

It seems Nextcloud is a heavy weight, and Lemmy wasn't, but now something is wrong and it hogs resources. With the change at least I still can run Lemmy, need to find a similar solution for Nextcloud too.

There is a table which has been 12 GB big in the database but it's data is only useful for debugging, so it can be truncated with:

TRUNCATE TABLE received_activity;

Finally the one bug which really bugged me is fixed, showing the context around a comment in the notifications. Especially when there were many comments on a post it was impossible to figure out what the person in the notifications responded to.

This time it went increadibly painless. I changed the docker image tag in the docker-compose, restarted the server, had to wait for about 3 minutes - probably the database upgrade - and then it was back online.

Hi! I realized that this community for some reason has already 49 subscribers but only 5 users. The whole idea of this community was just to document for myself what I've been doing to this instance over time. There is nothing interesting happening here.

So did you somehow subscribe automatically or on purpose?

I upgraded this instance to 0.18.2 now.

Also the SSD was full and I had the same problem as tps://github.com/LemmyNet/lemmy/issues/3173#issuecomment-1599043254 by deleting the 0 bytes big file snap.0000000002503768.generating I got it up and running again.

I followed lemmy.ml with preemptively blocking threads.net, I have no desire to federate with Zuckerberg.

I did it on all my ActivityPub instances, Lemmy, Mastodon and PeerTube.

Test from Mastodon to lemmy

After a little fix hopefully it's possible now to post new posts to my lemmy instance.

@jemmy\_meta

cross-posted from: https://jemmy.jeena.net/post/13205

> I wrote a very simple UserScript for the browser which can be used for example with https://www.tampermonkey.net/ to be injected in all the pages where there is the sidebar telling you you're not logged in but can subscribe by copy and pasting this string. > > A replace this string with a link to the search of my instance so I then can easily subscribe to it. > > It has one flaw though, it needs to run once a second for all the time because I couldn't figure out how to trigger it when you move around on the instance, DOMContentLoaded only triggers once and then the rest happens with XHR requests, but the popstate doesn't get fired when I navigate.

cross-posted from: https://kbin.social/m/kbinMeta/t/98604

> I just realized that it might not be a technical issue that I can't subscribe to any kbin.social magazines from my one-person lemmy instance but that I might not be on the whitelist. > > Every time I try to subscribe to any magazine I get "Subscription Pending". First I thought it was some technical issue, cloudflare, server overloaded, etc. especially because I had similar issues with lemmy instances. > > Today I updated to lemmy 0.18.0 and all the lemmy servers started letting me subscribe, but not /kbin but perhaps there is something incompatible. But I found threads about people subscribing to kbin from lemmy successfully. And then I was reading https://kbin.social/m/kbinMeta/t/93050/How-do-I-request-federation and then it dawned to me that I might just either not be on a whitelist or even worse on a black list. > > How is it supposed to work? > > Is this the reason why my single-user instance can't subscribe to any https://kbin.social magazine? I'm not even getting an error, just "Subscription Pending". That sounds kind of broken and different to how Mastodon is dealing with that issue. > > Do I somewhere need to apply to be able to subscribe to any /kbin magazines? If so where do I do that? Is there a email I can sent my application to? Or is the idea that if you have a single user instance you create a new user on every instance to find some meta-magazine where you can ask to be able to subscribe to a magazine on that instance? > > Or are small instances not part of the design? > > I also see that my comments in threads of other instances which kbin federates with don't show up here either, which is understandable if my instance is banned.

I upgraded this instance to 0.18.0 but it's extreamly slow now. When I click on something I need to wait for several seconds to get to the page. Not sure what the problem is yet.

There's an exploit where people are mass registering bot accounts on instances with open signups. Turn on captchas or you may get defederated if botters find this place.

Lemmy right now is quite buggy when it comes to searching communities from other instances. There is a ugly workaround which works most of the time:

What I do is:

• I take the name “[email protected]”
• copy and paste it into the search in my instance
• press “search”
• it shows “No results.”
• I go to Communities on my instance
• I click on “All”
• At the bottom of the list I can see “[email protected]” and the Subscribe button

I guess it is some kind of a bug. If I post a url of a post, it also takes qute some time, several seconds, until it shows up.

Other people have similar workarounds: htps://jemmy.jeena.net/comment/7062

Then there is often the problem with subscribing, when an instance is very bussy you might get a orange buttor "Subscription Pending". The only way of getting subscribed to that community is to click it again so it disappears and trying to subscribe again. For /kbin instances I was not able to subscribe to any of their communities yet.

Sometimes I see some usefull links around Lemmy or /kbin, they're not worth it to bookmark but I still want to remember it. So here I will be adding those links which are usefull and I want to remember.

Backstory with reddit

I've joined reddit in 2006 I didn't know what it was but back then it was important to get your short username before it was gone. I didn't use it until about 3 years ago when I realized I could post my photos there like https://www.reddit.com/r/pics/comments/ets2ex/yesterday_i_was_at_a_sumo_wrestling_tournament_in/ to get them in front of many critical eyes.

And since then I was lazy, I knew I was feeding another monster after being able to get rid of google (with the exception of YouTube), Twitter, Facebook, I was still using reddit, mostly for reading but also for the occasional posting.

When I moved to Korea, I wanted to participate in r/Korea which I did for a very short time, until I posted a link to a video with a Fire close to Seoul and got accused of self promotion because instead of using YouTube or imgurl or some 3rd party video hoster I posted it on my own PeerTube instance. I'm banned from posting there until this day and I'm too proud and don't think I did anything wrong to reach out to the mods of r/Korea and beg them to unban me. At least I still was able to read.

Anyway, back then I was very frustrated and kind of wanted to leave but when I looked around the Fediverse alternatives were not there yet. But they are now!

Why this instance?

I'm oldschool IndieWeb and basically this page from the IndieWeb wiki explains it quite well why I don't trust other people to host my stuff: https://indieweb.org/site-deaths

I already host a single user Mastodon instance and a family PeerTube instance and my own website.

If possible then I want to own the content I'm posting and be in control of my identity. If I would join a different lemmy or /kbin instance then I feel that i would not gain much over staying at reddit. I would not be able to decide if the instance stays online or not, I would not be able to decide what I can post and what not, I would also not be able to move to a different server or software, etc. So not very different from being on reddit.

I don't plan on opening this instance to anyone else but me. Perhaps the Threadyversi becomes a huge success and my family wants to join then let's see but I don't think that will happen :D

When I host myself then I have the ultimate freedom. Yes it's still a bit difficult to get an instance up and running but I am sure it will get easier over time.

Why lemmy and not /kbin?

I am aware of all the political implications with the developers of lemmy, but /kbin is written in PHP and MySQL. I know it's a stupid reason but I just really don't want to mess with PHP anymore. And lemmy is written in Rust (at least the backend) which I feel has a promising future.

What also is cool is that both are licensed under the AGPL.

I just set up this instance, it took me 4 days of trial and error but whatever. A interesting thing is how a new Instance is introduced to the rest of the Threadyverse.

There was no connection to anything and then after I posted my first comment on lemmy.world suddenly other instances started to ping my instance and from this first interaction this list was created:

• lemmy.wiuf.net
• beehaw.org
• lemmy.one
• dubvee.org
• infosec.pub
• culture0.cc
• lemmy.world
• sh.itjust.works
• lemmy.ml
• lemmy.timgilbert.be
• lemmyfly.org
• lemmy.ca
• lemm.ee
• lemmy.1204.org
• lemitar.meta1203.com
• feddit.de
• jemmy.jeena.net
• leddit.social
• feddit.nl
• szmer.info
• lemmy.bradis.me
• lmmy.tvdl.dev

And I guess it will just grow from there, you can see the connected instances under https://jemmy.jeena.net/instances