Authentication Fails in RH-SSO with log error "Data too long for column 'DETAILS_JSON'"
Issue
- Authentication fails saying "Internal Server Error"
-
Log shows an error ending with:
Caused by: java.sql.SQLDataException: (conn=107055) Data too long for column 'DETAILS_JSON' at row 1 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:167) at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:216) at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:150) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:183) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) ... 92 more Caused by: java.sql.SQLException: Data too long for column 'DETAILS_JSON' at row 1 Query is: insert into EVENT_ENTITY (CLIENT_ID, DETAILS_JSON, ERROR, IP_ADDRESS, REALM_ID, SESSION_ID, EVENT_TIME, TYPE, USER_ID, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters ['authorization-service','{"auth_method":"openid-connect","auth_type":"code","response_type":"code","redirect_uri":"http://localhost:8280/auth/roles?state=aHR0cDovL2xvY2FsaG9zdDo4MjgwL2F1dGgvcm9sZXNfX2F1dGhvcml6YXRpb24tc2VydmljZQ%3D%3D&session_state=0154ef47-96f8-46ac-b438-c712a669c387&code=3de8d0e2-1d2e-40c1-99e7-fd76a426b9ec.0154ef47-96f8-46ac-b438-c712a669c387.e050e6e5-0531-465d-93a5-e66f367a04f6&state=aHR0cDovL2xvY2FsaG9zdDo4MjgwL2F1dGgvcm9sZXNfX2F1dGhvcml6YXRpb24tc2VydmljZQ%3D%3D&session_state=0154ef47-96f8-46ac-b438-c712a669c387&code=84fbe845-3f3a-4ef8-a9fb-4bcc28693a94.0154ef47-96f8-46ac-b438-c712a669c387.e050e6e5-0531-465d-93a5-e66f367a04f6&state=aHR0cDovL2xvY2FsaG9zdDo4MjgwL2F1dGgvcm9sZXNfX2F1dGhvcml6YXRpb24tc2VydmljZQ%3D%3D&session_state=0154ef47-96f8-46ac-b438-c712a669c387&code=72e0725d-c919-4170-98f0-7ab73eeff31e.0154ef47-96... at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:255) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:209) ... 96 more
Environment
- Red Hat Single Sign-On (RH-SSO)
- 7
- Event Logging Enabled
- After successful login
- Very long redirect URL (> 2400 characters)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.