[bug] "sql: no rows in result set" when attempting to accept an incoming follow request

[jessienab]

Describe the bug with a clear and concise description of what the bug is.

I received a follow request from another GTS user. When I attempt to accept the follow request, nothing happens in my client (Tusky), and I see this error in my container logs:

timestamp="04/05/2024 14:34:09.360" func=server.glob..func1.Logger.func13.1 level=INFO latency="2.722375ms" userAgent="Tusky/24.1 Android/13 OkHttp/4.11.0" method=POST statusCode=404 path=/api/v1/follow_requests/01HWN7GPKKWC2N4XN7DHRGS17N/authorize clientIP=0.0.0.0 errors="Error #01: sql: no rows in result set\n" requestID=9p7e4h4f04001537qwp0 msg="Not Found: wrote 45B

I'm not sure why this is happening, as I was able to accept a request from a user on tech.lgbt for example...

---

Possibly related, when I go to access this GTS users' profile, it takes a considerable amount of time to load the profile. However it does eventually load. As well, I can make and receive posts in general without issue, and I can make and receive posts from this specific user in general.

(The user is a friend of mine and they're the one I'm having issues accepting the follow from, but I don't want them to be bothered, thus why I edited their server URL. They're running the same GTS version as me)

timestamp="04/05/2024 14:34:55.216" func=httpclient.(*Client).DoSigned level=ERROR method=GET url=https://friend.gts.example/users/chihiro/statuses/01HX1NYSM1TBQTWPWNTG01DYRY pubKeyID=https://gts.nabein.me/users/jessie/main-key msg="backing off for 1m4s after http request error: Get \"https://friend.gts.example/users/chihiro/statuses/01HX1NYSM1TBQTWPWNTG01DYRY\": context deadline exceeded (Client.Timeout exceeded while awaiting headers)"
timestamp="04/05/2024 14:34:55.232" func=dereferencing.(*Dereferencer).enrichAccount level=ERROR requestID=rrse6h4f04001ky85w20 msg="error webfingering[1] remote account chihiro@friend.gts.example: fingerRemoteAccount: error webfingering @chihiro@friend.gts.example: Get \"https://friend.gts.example/.well-known/webfinger?resource=acct%3Achihiro%40friend.gts.example\": dial tcp: lookup friend.gts.example on 10.89.0.1:53: read udp 10.89.0.x:39594->10.89.0.x:53: i/o timeout (fast fail)"
timestamp="04/05/2024 14:34:55.232" func=httpclient.(*Client).DoSigned level=INFO method=GET url=https://friend.gts.example/users/chihiro requestID=rrse6h4f04001ky85w20 pubKeyID=https://gts.nabein.me/users/jessie/main-key msg="performing request"
timestamp="04/05/2024 14:35:05.236" func=dereferencing.(*Dereferencer).getAccountByURI level=ERROR requestID=rrse6h4f04001ky85w20 msg="error enriching remote account: enrichAccount: error dereferencing https://friend.gts.example/users/chihiro: Get \"https://friend.gts.example/users/chihiro\": net/http: request canceled while waiting for connection (Client.Timeout exceeded while awaiting headers) (fast fail)"
timestamp="04/05/2024 14:35:05.239" func=server.glob..func1.Logger.func13.1 level=INFO latency="13.776749852s" userAgent="Tusky/24.1 Android/13 OkHttp/4.11.0" method=GET statusCode=200 path=/api/v1/accounts/01HWN7GPKKWC2N4XN7DHRGS17N clientIP=0.0.0.0 requestID=rrse6h4f04001ky85w20 msg="OK: wrote 1.16kiB"
timestamp="04/05/2024 14:35:11.208" func=httpclient.(*Client).DoSigned level=INFO method=POST url=https://friend.gts.example/users/chihiro/inbox requestID=zf8y2h4f040000bkar0g pubKeyID=https://gts.nabein.me/users/jessie/main-key msg="performing request"
timestamp="04/05/2024 14:35:21.209" func=httpclient.(*Client).DoSigned level=ERROR method=POST url=https://friend.gts.example/users/chihiro/inbox requestID=zf8y2h4f040000bkar0g pubKeyID=https://gts.nabein.me/users/jessie/main-key msg="backing off for 1m4s after http request error: Post \"https://friend.gts.example/users/chihiro/inbox\": context deadline exceeded (Client.Timeout exceeded while awaiting headers)"

What's your GoToSocial Version?

0.15.0+git-15733cd

GoToSocial Arch

amd64, Docker (podman rootless)

What happened?

When attempting to accept the follow request, it remains in my notifications and an error is shown in container logs (see above).

What you expected to happen?

The request should be accepted, and the follow request notification should disappear.

How to reproduce it?

Unsure... I didn't change anything or update the container image, configs, etc recently...

Anything else we need to know?

I didn't explicitly put "from another GTS user" in the title because I don't know if this is an issue ONLY with GTS <> GTS follow requests or not...

Also unsure if it's related to #2211 at all... ?

Thank you!

[tsmethurst]

Off the top of my head it sounds like there might be some network issue with your friend's instance, especially the error messages you sent suggest that it's taking a very long time to respond to requests, to the extent that your instance is hanging up after trying to send requests to it and timing out. That should not cause the sql no rows error however, though it might be triggering some race condition somewhere...