Problem with mysql

ORY Hydra
#1

Dear,

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: \ngithub.com/ory/x/sqlcon.HandleError\n\t/go/pkg/mod/github.com/ory/[email protected]/sqlcon/error.go:51\ngithub.com/ory/hydra/consent”
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!!!

#2

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

#3

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

#4

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