[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