[keycloak-user] Enabling login events causes ERROR: value too long for type character varying(2550)

[Dennis de Vaal | Rovecom]

When a user logs in via our custom SAML-based identity provider (which in turn is based on the one provided with keycloak), keycloak will throw the following exception: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(2550). This happens when the user is redirected back to keycloak from the external IdP.

I have traced this back to the details_json column in the event_entity table. This column has a varchar data type of length 2550. Can this limit be increased or removed? For now we decided to disable this feature (Save Events: OFF) under Events > Config > Login Events Settings.

We are running keycloak 3.4.3 Final (from theofficial jboss docker image). See attached log for a full stacktrace.

Regards,

Dennis de Vaal


[Rovecom]
Dennis de Vaal
webontwikkelaar

[Rovecom] elbe 2, 7908 hb hoogeveen     [Rovecom]  0528 22 35 35 /
[Rovecom] postbus 2126, 7900 bc hoogeveen       [Rovecom]  rovecom.nl<https://www.rovecom.nl/>

Voortdurend bezig met innoveren om beweging te stimuleren en groei te realiseren. Wij zijn Rovecom.
Disclaimer: https://www.rovecom.nl/maildisclaimer. Wanneer de link niet werkt, plak de link dan in uw internet browser.

-------------- next part --------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image819dd7.PNG
Type: image/png
Size: 2346 bytes
Desc: image819dd7.PNG
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0005.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image02834f.PNG
Type: image/png
Size: 267 bytes
Desc: image02834f.PNG
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0006.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imageb7033d.PNG
Type: image/png
Size: 412 bytes
Desc: imageb7033d.PNG
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0007.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image131f23.PNG
Type: image/png
Size: 173 bytes
Desc: image131f23.PNG
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0008.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imaged84a55.PNG
Type: image/png
Size: 160 bytes
Desc: imaged84a55.PNG
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0009.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: keycloak-postgres-stacktrace-2.log
Type: application/octet-stream
Size: 47836 bytes
Desc: keycloak-postgres-stacktrace-2.log
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20180824/5c2c5f02/attachment-0001.obj