Magic Link continuation error in KC 26.1.2

[rtufisi]

Repro steps:

1. Try login in a realm using Magic Link Continuation flow

Stack traces:

ERROR: duplicate key value violates unique constraint "constraint_offl_us_ses_pk2"
  Detail: Key (user_session_id, offline_flag)=('fc90ff7c-3ecb-4fd4-b9f9-cebee8bf3ac5', '0') already exists.

Batch entry 0 insert into public.OFFLINE_USER_SESSION (BROKER_SESSION_ID,CREATED_ON,DATA,LAST_SESSION_REFRESH,REALM_ID,USER_ID,VERSION,OFFLINE_FLAG,USER_SESSION_ID) values ((NULL),('[1740748166-1740748197]'::int4),('{"ipAddress":"188.27.128.252","authMethod":"openid-connect","rememberMe":false,"started":0,"notes":{"KC_DEVICE_NOTE":"eyJpcEFkZHJlc3MiOiIxODguMjcuMTI4LjI1MiIsIm9zIjoiTGludXgiLCJvc1ZlcnNpb24iOiJVbmtub3duIiwiYnJvd3NlciI6IkNocm9tZS8xMjguMC4wIiwiZGV2aWNlIjoiT3RoZXIiLCJsYXN0QWNjZXNzIjowLCJtb2JpbGUiOmZhbHNlfQ==","AUTH_TIME":"[1740748166-1740748197]","authenticators-completed":"{\"e4cd9ce7-e191-4c49-9992-a65cc3166a44\":[1740748166-1740748197]}"},"state":"LOGGED_IN"}'),('[1740748166-1740748197]'::int4),('razvan-cluster'),('f09b0687-42ee-427e-965c-a642a42fdae8'),('0'::int4),('0'),('*')) was aborted: ERROR: duplicate key value violates unique constraint "constraint_offl_us_ses_pk2"   Detail: Key (user_session_id, offline_flag)=('*', '0') already exists.  Call getNextException to see other errors in the batch.

[scandinave]

Same error. Maybe related to keycloak/keycloak#35602