https://www.ory.com/ logo
Join Slack
Powered by
We are seeing insert statements failed frequently ...
# general
d
We are seeing insert statements failed frequently for hydra_outh2_flow and delete getting failed for hydra_outh2_access tables.
m
Hello @dry-match-53735 are you using Ory Kratos or Ory Hydra? Ory Hydra has a 
janitor
command built-in which is what you are looking for probably.
d
Thank you Vincent. Not sure exactly. As of now I thought both are same. If it is Ory Kratos what is the tool need to be use to clean up the tables.
m
@dry-match-53735 Ory Kratos does not have such a tool, it also does not have the tables that you mentioned.
d
Ok thank you Vincent. We will try with janitor tool. We are seeing more locks on the tables and couple of insert statements are failed. Is there any configuration parameters to avoid these issues.
m
Sorry @dry-match-53735 I can't really help with database/production issues... however Ory does offer professional support agreements for this kind of thing - you can contact at ory.sh/contact if you are interested. see here for an overview: https://www.ory.sh/deployment-solutions/ "Self-hosted with Enterprise support"
d
Sure. Thank you Vincent.
@magnificent-energy-493 After using the janitor tool able to clean up hydra_oauth2_access and hydra_oauth2_refresh tables but it is not deleting data from remaining large tables like oauth2_flow, oauth2_oidc, oauth2_code. Is there any other parameters need to set for this. Please suggest.
m
Again I cant really help with this as I know nothing about your system and deployment and I cant give a good recommendation without more direct insight as to how you are running Ory Hydra etc. This would be a case for professional support.
d
Ok. Understood thank you Vincent for all your support.
m
@dry-match-53735 feel free to also check the Slack archive: https://archive.ory.sh/ and the GitHub discussions: https://github.com/discussions?discussions_q=org%3Aory+sort%3Aupdated-desc you might find more pointers there from other users.
d
Sure. Thank you
5 Views
Open in Slack
PreviousNext
Powered by