Authentication Fails in RH-SSO with log error "Data too long for column 'DETAILS_JSON'"

Solution Unverified - Updated -

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.3
  • 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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In