Melroy van den Berg

> As I said for the update queries, I think the problem are locked rows and not missing indices, because they update by id and we have indices for that...

> So the 6 digits query below took 101782 ms. Auw.. that is **1.7 minutes**! The queries (yes more then once) that took the longest time on Jerry's server (potentially...

- [x] 25th - Even after PR #1254 is merged, I see other calls being made to banned instances (I created another follow-up PR: https://github.com/MbinOrg/mbin/pull/1258): ```json {"message":"Error thrown while handling...

Most of the issues are now solved I think. I still sometimes see `couldnt_find_person` and also a lot of `couldnt_find_community` errors! couldnt_find_person examples: ```json {"message":"[ApHttpClient::logRequestException] ApHttpClient:getActivityObject failed: https://lemmy.world/post/38454371, ex: App\\Exception\\InvalidApPostException:...

Duplicate key violation errors in dislike (missing checks): ```sh 16:20:53 WARNING [messenger] Error thrown while handling message App\Message\ActivityPub\Inbox\DislikeMessage. Sending for retry #1 using 300000 ms delay. Error: "Handling "App\Message\ActivityPub\Inbox\DislikeMessage" failed:...

Invalid API response exception (`App\\Exception\\InvalidApPostException`): ``` {"message":"[ApHttpClient::logRequestException] ApHttpClient:post failed: https://leaf.dance/inbox, ex: App\\Exception\\InvalidApPostException: Post failed: https://leaf.dance/inbox, status code: 400, {\"@context\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"https:\\/\\/kbin.melroy.org\\/contexts\"],\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/019a644a-d8f1-7598-9598-44c47e876f87\",\"type\":\"Announce\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/m\\/tech\",\"object\":{\"id\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/activity\",\"type\":\"Create\",\"actor\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\",\"published\":\"2025-11-07T22:56:24Z\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/followers\",\"https:\\/\\/floss.social\\/users\\/omgubuntu\"],\"object\":{\"id\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\",\"type\":\"Note\",\"summary\":null,\"inReplyTo\":\"https:\\/\\/floss.social\\/users\\/omgubuntu\\/statuses\\/115509219495321399\",\"published\":\"2025-11-07T22:56:24Z\",\"url\":\"https:\\/\\/famichiki.jp\\/@RachelThornSub\\/115510882137562946\",\"attributedTo\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/followers\",\"https:\\/\\/floss.social\\/users\\/omgubuntu\"],\"sensitive\":false,\"atomUri\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\",\"inReplyToAtomUri\":\"https:\\/\\/floss.social\\/users\\/omgubuntu\\/statuses\\/115509219495321399\",\"conversation\":\"tag:floss.social,2025-11-07:objectId=101607956:objectType=Conversation\",\"context\":null,\"content\":\"@omgubuntu Yes, here\\u2019s a link.https:\\/\\/mastodon.social\\/@nixCraft\\/115501880824995582\",\"contentMap\":{\"en\":\"@omgubuntu Yes, here\\u2019s a link.https:\\/\\/mastodon.social\\/@nixCraft\\/115501880824995582\"},\"interactionPolicy\":{\"canQuote\":{\"automaticApproval\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"]}},\"attachment\":[],\"tag\":[{\"type\":\"Mention\",\"href\":\"https:\\/\\/floss.social\\/users\\/omgubuntu\",\"name\":\"@[email protected]\"}],\"replies\":{\"id\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/replies\",\"type\":\"Collection\",\"first\":{\"type\":\"CollectionPage\",\"next\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/replies?only_other_accounts=true&page=true\",\"partOf\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/replies\",\"items\":[]}},\"likes\":{\"id\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/likes\",\"type\":\"Collection\",\"totalItems\":0},\"shares\":{\"id\":\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/statuses\\/115510882137562946\\/shares\",\"type\":\"Collection\",\"totalItems\":0}}},\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/famichiki.jp\\/users\\/RachelThornSub\\/followers\",\"https:\\/\\/floss.social\\/users\\/omgubuntu\"],\"published\":\"2025-11-08T16:26:58+00:00\",\"audience\":\"https:\\/\\/kbin.melroy.org\\/m\\/tech\"}. Truncated content: {\"error\":\"unknown\",\"message\":\"\"}....

Small investigation says these are the current indexes we are using in the `favourite` table: Some indexes have no name, but just `idx_`. But are most likely linked directly to...

So long story short, I believe the indexes are correct and also the unique indexes are here for a reason.. The problem is just the incredible amount of rows in...

I also tried Scalar, I see the same "Default response" message (instead of using the description) when using Scalar api reference interface with `$ref` responses: 

@jean-michelet Would you be willing to help me with this issue? To briefly explain the issue. You can use Fastify with swagger as you know, using schemas. So I'm using...