Ory is the largest open source community in the world for cloud software application security. We maintain advanced open source security software solving authentication, authorization, access control, application network security, and delegation. Ory implements a variety of industry and best-practice standards including OAuth 2.0 / OAuth 2.1, OpenID Connect, Zero Trust Networking, Google Zanzibar Policy Framework, FIDO2 U2F, WebAuthn, TOTP, and more.

Ory Community

Hi all!
Multiple of our Hydra services started failing in different environments/clusters a few days ago. Authentication requests would then only be answered by `The error is unrecognizable Error: cannot execute INSERT in a read-only transaction (SQLSTATE 25006)` . We initiated a failover in the affected postgres databases and that seems to have helped. Any idea why this happened?

This looks like a database issue. The database was apparently no longer to issue write transactions! Doesn't look like an issue with Hydra in particular. Maybe wrong read secondary?