Janitor purge does not remove lines from hydra_oauth2_flow - Githubissues

ory / hydra

The most scalable and customizable OpenID Certified™ OpenID Connect and OAuth Provider on the market. Become an OpenID Connect and OAuth2 Provider over night. Broad support for related RFCs. Written in Go, cloud native, headless, API-first. Available as a service on Ory Network and for self-hosters.

https://www.ory.sh/?utm_source=github&utm_medium=banner&utm_campaign=hydra

Apache License 2.0

15.64k stars 1.5k forks source link

Janitor purge does not remove lines from hydra_oauth2_flow #3877

Open jderboven opened 2 weeks ago

jderboven commented 2 weeks ago

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.
[ ] I have joined the Ory Community Slack.
[ ] I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

No response

Describe the bug

As of time passes by, I noticed a high load within my database and especially in hydra_oauth2_flow.

All of the lines are status = 6 which is denied by the script from janitor as far as I've seen

My database is like around 140Go and it's been 4 months since I've set up the environment ... How can I fix this ?

Reproducing the bug

Just set up everything and get

Relevant log output

No response

Relevant configuration

No response

Version

2.1.0

On which operating system are you observing this issue?

None

In which environment are you deploying?

None

Additional Context

No response