Hello, are there any known issues with the API per...
# ory-networkb
bitter-salesclerk-267
02/12/2025, 2:03 PMHello, are there any known issues with the API performance, I am unable to delete oauth2 clients?
m
magnificent-energy-493
02/12/2025, 2:42 PM
afaik no, what is the error you are getting?
b
bitter-salesclerk-267
02/12/2025, 3:14 PMSo I am clicking on "Delete" in the UI for the oauth2 client, the request is being sent but after some time it's being cancelled:
bitter-salesclerk-267
02/12/2025, 3:15 PMI checked my Logs & Events page, but no luck there
b
bland-eye-99092
02/12/2025, 3:16 PMYea, seems like the request is just timing out in the frontend, because our DB commit (in our DB) is taking very long. We'll investigate, thanks for the message!
b
bitter-salesclerk-267
02/12/2025, 3:17 PMIf you'll need anything from my end, just let me know 🙂
bitter-salesclerk-267
02/12/2025, 3:18 PMI'm not sure if that helps but we are running very old project which is on the legacy subscription and is not within any workspace
b
bland-eye-99092
02/12/2025, 3:18 PMyea that could be a factor. Do you have many OAuth2 clients?
b
bitter-salesclerk-267
02/12/2025, 3:19 PM26 for this project
m
magnificent-energy-493
02/12/2025, 3:28 PM
in the meantime you should also be able to use the API directly or via the CLI
ory delete oauth2-clientb
bitter-salesclerk-267
02/12/2025, 3:31 PMThat doesn't save me since our API uses ory API directly in order to manage the clients and it also fails - that's how I noticed the issue
bitter-salesclerk-267
02/12/2025, 3:32 PMI know that I could try using Ory CLI, but it's a very temporary workaround since some part of our applications rely on that API endpoint
b
bland-eye-99092
02/12/2025, 3:34 PMFWIW, the problem is internally on our side and most likely due to cascading deletion issues. I am guessing the client in question has a lot of data associated with it, e.g. tokens, challenges, etc.
I've forwarded the issue to the team, and they will take a look. Is this blocking you at the moment?
b
bitter-salesclerk-267
02/12/2025, 3:36 PMI tried different clients with the same result
bitter-salesclerk-267
02/12/2025, 3:36 PMThere might be a lot of data since they are ~3-4 years old
bitter-salesclerk-267
02/12/2025, 3:37 PMIt is blocking our cleanups, but I guess I can wait a bit, it's not business critical issue
h
high-optician-2097
02/12/2025, 4:47 PM
Probably a foreign key related issue
high-optician-2097
02/12/2025, 4:48 PM
If the client has a ton of data associated it can cause time outs with the database we use. We have already filed reports with our vendor but they have not yet solved the issue.
You can wait 30 days after which most stale data will be cleaned up automatically and hen try again
b
bitter-salesclerk-267
02/13/2025, 1:49 PMSo, what you are saying is that when oauth2 client is not used, no tokens or other data is generated, and all of the old data will be gradually removed, so in ~30days it should work?
b
bland-eye-99092
02/13/2025, 2:01 PMYes
b
bitter-salesclerk-267
02/13/2025, 2:11 PMFYI, probably your explanation is correct, since I don't encounter any issues with the old unused oauth2 clients
bitter-salesclerk-267
03/18/2025, 2:22 PM@bland-eye-99092 @high-optician-2097 hello guys, it's past a month as you suggested but I'm still unable to delete the old oauth2 clients 😞
f
faint-terabyte-48594
04/29/2025, 12:51 PM@high-optician-2097 @bland-eye-99092 we're still unable to delete those old clients, despite their inactivity for 2 months now
faint-terabyte-48594
04/29/2025, 12:52 PMseems like a major issue on Ory side TBH - what if those were threat actors and we would need to delete them ASAP?
faint-terabyte-48594
04/29/2025, 12:53 PMshould we create a ticket for this?
b
bland-eye-99092
04/29/2025, 1:00 PMyes please
b
bitter-salesclerk-267
04/29/2025, 2:51 PM6 Views