Unable to delete very old oauth2 clients

[mateuszklimas]

Preflight checklist

• [x] I could not find a solution in the existing issues, docs, nor discussions.
• [x] I agree to follow this project's Code of Conduct.
• [x] I have read and am following this repository's Contribution Guidelines.
• [x] I have joined the Ory Community Slack.
• [ ] I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

vibrant-dubinsky-6d1qtx5k0i

Describe the bug

Hello,

recently we tried to delete very old (3/4 old) oauth2 clients, but the DELETE request gets canceled after some time:

I asked the question on the Slack community channel. They advised me to wait for a month, because they are cleaning a db, which was likely cause of the issue, but after that time I am still unable to delete clients. Here's the URL to the thread: https://ory-community.slack.com/archives/C02MR4DEEGH/p1739368982779679

Issue created as per Jonas request.

Reproducing the bug

I'm not able to provide the reproduction steps since they are really old oauth2 clients (3/4 years+). Deletion requests for the new ones works as expected.

Relevant log output

Relevant configuration

Version

ory-network

On which operating system are you observing this issue?

Ory Network

In which environment are you deploying?

Ory Network

Additional Context

No response