Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10583

Social Registration with Twitter when using MySQL repo is not working anymore

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: OpenIDM 6.0.0
    • Fix Version/s: OpenIDM 6.0.0
    • Labels:
    • Environment:
      OpenIDM version "6.0.0-SNAPSHOT" (build: 20180403230730, revision: c22592c)

      Description

      Steps to reproduce

      • start OpenIDM with MySQL repo
      • configure Twitter as a Social Login Provider
      • configure User Registration using Twitter
      • Go to Self Service UI
      • Register with Twitter
      • once the twitter credentials are entered and validated, we have to enter firstname, lastname and email in the Self Service UI
      • when we validate, we get an error:
      {
        "code": 500,
        "reason": "Internal Server Error",
        "message": "Creating object failed after 1 attempts (1366-HY000): Incorrect string value: '\\xF0\\x9F\\x98\\xAC\",...' for column 'fullobject' at row 1"
      }
      

      And in the log we get:

      Apr 04, 2018 3:48:59 PM org.forgerock.selfservice.core.AnonymousProcessService logAndAdaptException
      SEVERE: Internal error intercepted
      org.forgerock.json.resource.InternalServerErrorException: Creating object failed after 1 attempts (1366-HY000): Incorrect string value: '\xF0\x9F\x98\xAC",...' for column 'fullobject' at row 1
      	at org.forgerock.openidm.repo.jdbc.impl.JDBCRepoService.handleCreate(JDBCRepoService.java:388)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:264)
      	(...)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xAC",...' for column 'fullobject' at row 1
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
      	at org.forgerock.openidm.repo.jdbc.impl.query.TracedPreparedStatement.executeUpdate(TracedPreparedStatement.java:83)
      	at org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler.create(GenericTableHandler.java:357)
      	at org.forgerock.openidm.repo.jdbc.impl.JDBCRepoService.handleCreate(JDBCRepoService.java:360)
      	... 195 more
      
      Apr 04, 2018 3:48:59 PM org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3 lambda$handleRequestWithLogging$8
      WARNING: Resource exception: 500 Internal Server Error: "Creating object failed after 1 attempts (1366-HY000): Incorrect string value: '\xF0\x9F\x98\xAC",...' for column 'fullobject' at row 1"
      org.forgerock.json.resource.InternalServerErrorException: Creating object failed after 1 attempts (1366-HY000): Incorrect string value: '\xF0\x9F\x98\xAC",...' for column 'fullobject' at row 1
      	at org.forgerock.openidm.repo.jdbc.impl.JDBCRepoService.handleCreate(JDBCRepoService.java:388)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:264)
      	(...)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xAC",...' for column 'fullobject' at row 1
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
      	at org.forgerock.openidm.repo.jdbc.impl.query.TracedPreparedStatement.executeUpdate(TracedPreparedStatement.java:83)
      	at org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler.create(GenericTableHandler.java:357)
      	at org.forgerock.openidm.repo.jdbc.impl.JDBCRepoService.handleCreate(JDBCRepoService.java:360)
      	... 195 more
      
      
      

        Attachments

          Activity

            People

            • Assignee:
              krismy.alfaro Krismy Alfaro
              Reporter:
              laurent.bristiel Laurent Bristiel [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: