Hi, we recently have a problem with hydra 1.11.10 ...
# generalc
cool-midnight-44542
06/03/2024, 11:24 PMHi, we recently have a problem with hydra 1.11.10 and mysql 5.7.30, the connection suddenly increase from 56 to 1000. The query that have all % of use is hydra: UPDATE hydra_oauth2_refresh SET active=false WHERE request_id=..... You know if there is a bug in hydra related to conneciton pool with mysql or some bug that could make busy the database? Thanks!
cool-midnight-44542
06/04/2024, 3:19 PM@magnificent-energy-493 can we have some help with this? Thanks!
m
magnificent-energy-493
06/04/2024, 4:16 PM
Hello,
I am not aware of any bug here, but I also dont have a ton of experience in that area to be honest.
I guess your best bet is to see if there is an open issue on the repo and if not create one with as much information as possible.
c
cool-midnight-44542
06/04/2024, 5:06 PMThanks @magnificent-energy-493
cool-midnight-44542
06/04/2024, 5:20 PMI created the issue https://github.com/ory/hydra/issues/3775
👍 1
✅ 1
cool-midnight-44542
06/06/2024, 4:27 PM@magnificent-energy-493 i update we more information, can we have some news of it? We check that the table hydra_oauth2_refresh is too big. Hydra make some cleanup of the refresh token according to the ttl of refresh token? Thanks!
cool-midnight-44542
06/06/2024, 4:28 PMThis is what i put in the issue:
cool-midnight-44542
06/06/2024, 4:28 PM"Hi we are trying to search why happens the stuck to the database, i give you some more information:
We have until now in the table: hydra_oauth2_refresh, a total of: 26016447, the total that are in active=false state are: 25343718 and that are with active=true are: 672729. Why hydra is not deleting the ones that are in active=false or hydra used for another thing?
We have a TTL refresh token of 180days, but if i search the refresh token that are in active=false and column requested_id lesser than (actual date 06/06/2024) - 180, we have a total of: 81646
Any one can give us some solution to reduce this table and check if this is what produce the stuck in the database?"
cool-midnight-44542
06/26/2024, 11:39 PM@magnificent-energy-493 hi, how are you in relation to the issue could you give some review and see the comments that i sended, today the database went down again, Thanks!
m
magnificent-energy-493
06/27/2024, 7:39 AM
Hey @cool-midnight-44542
I cant really help with database issues sorry.
c
cool-midnight-44542
06/27/2024, 11:27 AMHi, but is not a database issue, the issue is from hydra @magnificent-energy-493
cool-midnight-44542
06/27/2024, 11:28 AMPlease @magnificent-energy-493 https://github.com/ory/hydra/issues/3775#issuecomment-2152935124
cool-midnight-44542
07/01/2024, 7:00 PM@magnificent-energy-493 sorry but is posible to have some news related to https://github.com/ory/hydra/issues/3775#issuecomment-2152935124 ?
16 Views