[keycloak-user] user data > 255 characters is causing Exception
David Erie (US)
David.Erie at datapath.com
Wed Feb 6 16:27:15 EST 2019
Hi,
We are storing some user preference data as attributes in Keycloak, and I am seeing this Exception in the Keycloak log file:
2019-02-06 13:43:55,413 WARN [org.keycloak.services.resources.admin.UserResource] (default task-2720) Could not update user!: org.keycloak.models.ModelException: org.hibernate.exception.DataException: could not execute statement
at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)
at org.keycloak.connections.jpa.JpaExceptionConverter.convert(JpaExceptionConverter.java:31)
at org.keycloak.transaction.JtaTransactionWrapper.handleException(JtaTransactionWrapper.java:65)
at org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:94)
at org.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)
at org.keycloak.services.resources.admin.UserResource.updateUser(UserResource.java:172)
<snip>
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Will it be possible to change that DB column definition to have no limit, or a much higher limit? Are there other ways to store long JSON strings with the User besides their attributes?
Thanks,
Dave
More information about the keycloak-user
mailing list