Problem with mysql


We have problem with mysql as follow:

  1. if we use long timeout, we have problem with deadlock as:
    debug=“Error 1213: Deadlock found when trying to get lock; try restarting transaction” description=“The authorization server encountered an unexpected condition that prevented it from fulfilling”

  2. If we use short timeout, we have problem from GetLoginRequest as:
    “[mysql] 2020/07/04 06:59:10 packets.go:36: unexpected EOF”

error=“invalid connection” reason= request-id= status= trace=“Stack trace: \\n\t/go/pkg/mod/[email protected]/sqlcon/error.go:51\
We have more problems when using two factors with email after user input code.

Hope that you support us to trace this problem.

Thank you so much!!!

Looks like the connections to the database are flaky and/or slow. Are hydra and your DB co-located?

Thank you for quick feedback!!!

We are different location.
For my SQL, we use cluster via HAProxy.

My colleague says “there isn’t any query that takes over 2 seconds”.

How can we fix this?

NOTE: we are using hydra v.1.0.0 and a multi-master galera cluster of percona 5.7.30

multi-master galera cluster of percona 5.7.30

Never heard of this, don’t think I can help

hydra v.1.0.0

We’re at 1.5, I recommend upgrading. 1.0 is over 1 1/2 years old