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

Any ideas on what to try? Can't really redeploy hydra from scratch since we have lots of active clients. (SQL works for creating clients etc)

Hello Karl,
Apologies, I can imagine this situation is quite frustrating.

I will ask the team for some guidance, but if you could create an issue/bug-report with some more information that would probably help debugging this.
<https://github.com/ory/hydra/issues/new?assignees=&amp;labels=bug&amp;template=BUG-REPORT.yml>

Thank you! Will update the log level to see if we can get some more information and then write an issue if we don't figure it out!

<https://github.com/ory/hydra/issues/2986>

select max(version) from schema_migration

based on the migration files it looks like hydra_oauth2_authentication_session is the only table that had a NOT NULL constraint on the authenticated_at column

but that was removed in 20201116133000000000

Thanks <@U0226P4G4FQ>, as you said, the database wasn't migrated properly! Thank you!