Hello, I tried to upgrade a non complex installation from 25.0.1 to 26.0.0 and I got this error when a user try to login to SSO
2024-10-05 12:49:19,334 INFO [org.hibernate.event.internal.DefaultLoadEventListener] (org.keycloak.models.sessions.infinispan.changes.PersistentSessionsWorker$BatchWorker) HHH000327: Error performing load command: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [select pcse1_0.CLIENT_ID,pcse1_0.CLIENT_STORAGE_PROVIDER,pcse1_0.EXTERNAL_CLIENT_ID,pcse1_0.OFFLINE_FLAG,pcse1_0.USER_SESSION_ID,pcse1_0.DATA,pcse1_0.TIMESTAMP,pcse1_0.VERSION from public.OFFLINE_CLIENT_SESSION pcse1_0 where (pcse1_0.CLIENT_ID,pcse1_0.CLIENT_STORAGE_PROVIDER,pcse1_0.EXTERNAL_CLIENT_ID,pcse1_0.OFFLINE_FLAG,pcse1_0.USER_SESSION_ID) in ((?,?,?,?,?))] [ERROR: column pcse1_0.version does not exist
Seems to be a missing column in the migration file.
I opened issue here : Return of offline session bug on 26.0.0 · Issue #33610 · keycloak/keycloak · GitHub