RocketDerp

This is a 'ui / front-end issue', it belongs on https://github.com/LemmyNet/lemmy-ui It is also a well known issue and generally described as version 0.18 removal of the websockets API interface.

I'm trying to raise this issue to significant attention without getting everyone defensive about the project. So far, that has been very difficult. The GitHub project page boldly presents Lemmy...

Thinking out loud. This is a very direct where clause of a single record. ``` Index Scan using idx_comment_post on comment c (cost=0.43..23.45 rows=34 width=10) (actual time=0.306..154.030 rows=359 loops=1) Index...

Grep of the code seems to reveal that the most recent migration that created this function is here, back on April 4, 2022: https://github.com/LemmyNet/lemmy/blob/102124b6d29edd7d799ee12a6f6df05dbbbf4f6c/migrations/2022-04-04-183652_update_community_aggregates_on_soft_delete/up.sql#L178 ``` create or replace function site_aggregates_comment_delete()...

yha, this makes no sense: Doing `update site_aggregates set comments = comments - 1 where id = 1737` is bogus. Your id = 1, your own local instance. 1737 would...

Ok, I found the April 4, 2022 pull request where these triggers were being worked on... there is a lot of comments about it by developers. It seems to me...

yna, I was just showing what the code current has. Who is going to do the pull request? This is a major discovery! Great job!

Community aggregate updating looks pretty suspect too, https://github.com/LemmyNet/lemmy/blob/102124b6d29edd7d799ee12a6f6df05dbbbf4f6c/migrations/2022-04-04-183652_update_community_aggregates_on_soft_delete/down.sql#L15 ``` -- Community aggregate functions create or replace function community_aggregates_post_count() returns trigger language plpgsql as $$ begin IF (TG_OP = 'INSERT') THEN...

DISCLAIMER: I still don't know where these SQL statements are coming from. The filenames clearly seem machine generated, [2022-04-04-183652](https://github.com/LemmyNet/lemmy/tree/102124b6d29edd7d799ee12a6f6df05dbbbf4f6c/migrations/2022-04-04-183652_update_community_aggregates_on_soft_delete) filenames down to the second of a timestamp. I assume they...

From what I understand, #3649 shows it happens with relatively small accounts. A local user can trigger it... Is it even confirmed that federated peers do a DELETE? I'm working...