keycloak-dev@googlegroups.com
30 views
Skip to first unread message
Shiva Saidonthula
Apr 18, 2025, 4:07:50 AMApr 18
to Keycloak Dev
Hi Developers,
I have recently started using browser flow in keycloak using PKCE to authenticate mobile app users. I have written a custom plugin to verify user mobile number and OTP and login users successfully. In one of the scenarios our users may directly uninstall the app and re-login again, or login in two different devices. When user attempts to login and session Id is already present in the DB (using keycloak - v26, offline sessions feature) I am receiving the below error
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "constraint_offl_us_ses_pk2"
Detail: Key (user_session_id, offline_flag)=(a88c9062-19e1-45ed-9f6f-93c2f98e1da3, 0) already exists.
I have recently started using browser flow in keycloak using PKCE to authenticate mobile app users. I have written a custom plugin to verify user mobile number and OTP and login users successfully. In one of the scenarios our users may directly uninstall the app and re-login again, or login in two different devices. When user attempts to login and session Id is already present in the DB (using keycloak - v26, offline sessions feature) I am receiving the below error
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "constraint_offl_us_ses_pk2"
Detail: Key (user_session_id, offline_flag)=(a88c9062-19e1-45ed-9f6f-93c2f98e1da3, 0) already exists.
Alexander Schwartz
Apr 28, 2025, 4:37:07 PMApr 28
to Shiva Saidonthula, Keycloak Dev
Hi Shiva,
it seems you want to report a Keycloak bug. Please report those as a GitHub issue here: https://github.com/keycloak/keycloak/issues
Maybe this is similar to the issue reported here: https://github.com/keycloak/keycloak/issues/38671
If you think this is a different problem, It would be great if you could reproduce that behavior with a standard Keycloak instance without your extension and possibly with a regular browser.
This mailing list is used to discuss the development of Keycloak itself, so it is not the place to submit bug reports.
Best,
Alexander
--
You received this message because you are subscribed to the Google Groups "Keycloak Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keycloak-dev...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/keycloak-dev/5555c6ab-4a2d-4965-9685-47c34b09266an%40googlegroups.com.
Alexander Schwartz, RHCE
He/Him
Principal Software Engineer, Keycloak Maintainer
Red Hat - Germany remote
 |
Red Hat GmbH, Registered seat: Werner von Siemens Ring 12, D-85630 Grasbrunn, Germany
Commercial register: Amtsgericht Muenchen/Munich, HRB 153243,
Managing Directors: Ryan Barnhart, Charles Cachera, Michael O'Neill, Amy Ross
Commercial register: Amtsgericht Muenchen/Munich, HRB 153243,
Managing Directors: Ryan Barnhart, Charles Cachera, Michael O'Neill, Amy Ross
Reply all
Reply to author
Forward
0 new messages