I upgraded my FusionAuth instance (self-hosted container) from 1.64.1 to 1.65.0, but the container never starts.
Reading the logs during start up I found the following issue
SQL: SELECT internal_authentication_keys_id FROM instance LIMIT 1"}
Cause: org.postgresql.util.PSQLException: ERROR: column \"internal_authentication_keys_id\" does not exist"}
...
...
...
ERROR org.primeframework.mvc.guice.GuiceBootstrap - Unable to start the server. Exception:"}
So the app is clearly expecting a schema change that my database doesn’t have.
What’s confusing is:
There are no visible migration scripts running during startup
Release notes don’t mention a migration step
But 1.65 clearly assumes this column exists in instance
I downloaded the schemas for both versions and instance.internal_authentication_keys does exist on 1.65.0, but not 1.64.1