RocketDerp

On Lemmy 0.18.2 now. I added logging to the insert_activity code to try and figure out what is going on here. This is what I saw: ``` 2023-07-12T16:50:25.172155Z DEBUG federation:...

Now this one isn't a simple "Like" object, but a new posting: ``` 2023-07-12T17:05:40.193915Z DEBUG federation: apub.lib.rs.insert_activity DbUrl(Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port:...

What's the behavior with 0.18.3 now that it has been released?

> * https://lemm.ee/c/[email protected] shows only 2 posts, (UI: 0.18.1-rc.11, BE: 0.18.1-rc.10) For the sort "Hot" and "Active", it shows only 3 (one was added 30 minutes ago), but "new" shows...

> I don't have good numbers though so I might be wrong. You can track these timings by enabling the pg_stat_statements.track='all' option. I wish I had caught this sentence 3...

> 2\. For all other triggers, if any remain, instead of directly updating they should set a `dirty: boolean` flag on the target row. There should be an index on...

> Hopefully crossed_fingers we already have unit tests to make sure those aggregates are the correct values My pending pull request with emergency/urgent changes to fix crashing servers has additional...

A proposed consolidated trigger that tackles head-on the performance issues of Lemmy API delete of a post, delete of an account, etc: https://github.com/LemmyNet/lemmy/pull/3727

I found another case of this, 7 hours ago from time of this comment: https://lemmy.world/post/1183289 origin to 3rd server: https://lemmy.ca/post/1245505 and I found it listed on a 4th server: https://lemm.ee/post/826998...

Spot checking this problem, it seems to be still ongoing, this is the same post on 3 servers: https://lemmy.lif.ovh/post/10872 https://lemmy.ca/post/1352524 https://lemmy.world/post/1341715 Lemmy.ml, the home to the community, no longer lists...