Failed Migration to Keycloak v17 #42065

gokhantamkoc · 2025-08-22T08:48:13Z

gokhantamkoc
Aug 22, 2025

OS: Amazon Linux 2
DB: Postgres

My migration From Keycloak 16 to Keycloak v17 has failed. I am getting this error:

2025-08-22 07:46:43,539 INFO  [org.infinispan.CONTAINER] (keycloak-cache-init) ISPN000128: Infinispan version: Infinispan 'Triskaidekaphobia' 13.0.5.Final
2025-08-22 07:46:46,893 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (main) SQL Error: 0, SQLState: 42703
2025-08-22 07:46:46,894 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (main) ERROR: column migrationm0_.update_time does not exist
  Position: 36
2025-08-22 07:46:47,126 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (development) mode
2025-08-22 07:46:47,126 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2025-08-22 07:46:47,127 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: could not extract ResultSet
2025-08-22 07:46:47,127 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: ERROR: column migrationm0_.update_time does not exist

I am using Docker to migrate the database. This is the image tag I am using quay.io/keycloak/keycloak:17.0.1

FROM quay.io/keycloak/keycloak:17.0.1 as builder

# Enable health and metrics support
ENV KC_HEALTH_ENABLED=true
ENV KC_METRICS_ENABLED=true

WORKDIR /opt/keycloak

RUN /opt/keycloak/bin/kc.sh build

FROM quay.io/keycloak/keycloak:17.0.1
COPY --from=builder /opt/keycloak/ /opt/keycloak/

# change these values to point to a running postgres instance
ENTRYPOINT ["/opt/keycloak/bin/kc.sh"]

I have checked the database MIGRATION_MODEL table and its column UPDATE_TIME exists.
The database user is the owner of the schema where keycloak data resides. The user has the necessary privileges to access column.

Could you please help me? What could be the reason?

Navigation Menu

Repository navigation

Failed Migration to Keycloak v17 #42065

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

Failed Migration to Keycloak v17 #42065

Uh oh!

Uh oh!

gokhantamkoc Aug 22, 2025

Replies: 0 comments

gokhantamkoc
Aug 22, 2025