RH-SSO Table Creation Error "The table does not comply with the requirements by an external plugin" on MySQL

Solution Verified - Updated -

Issue

  • Initial Startup and table creation fails

    Caused by: liquibase.exception.DatabaseException: The table does not comply with the requirements by an external plugin. [Failed SQL: INSERT INTO ciam.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1.0.0.Final-KEYCLOAK-5461', 'sthorger@redhat.com', 'META-INF/jpa-changelog-1.0.0.Final.xml', NOW(), 1, '7:4e70412f24a3f382c82183742ec79317', 'createTable tableName=APPLICATION_DEFAULT_ROLES; createTable tableName=CLIENT; createTable tableName=CLIENT_SESSION; createTable tableName=CLIENT_SESSION_ROLE; createTable tableName=COMPOSITE_ROLE; createTable tableName=CREDENTIAL; createTable tab...', '', 'EXECUTED', NULL, NULL, '3.5.4', '1907343781')]
            at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103)
            at liquibase.changelog.StandardChangeLogHistoryService.setExecType(StandardChangeLogHistoryService.java:341)
            at liquibase.database.AbstractJdbcDatabase.markChangeSetExecStatus(AbstractJdbcDatabase.java:1138)
            at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:62)
            at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
            at liquibase.Liquibase.update(Liquibase.java:214)
            at liquibase.Liquibase.update(Liquibase.java:192)
            at liquibase.Liquibase.update(Liquibase.java:188)
            at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.updateChangeSet(LiquibaseJpaUpdaterProvider.java:182)
            at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:102)
            ... 59 more
    Caused by: java.sql.SQLException: The table does not comply with the requirements by an external plugin.
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
            at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)
            at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:729)
            at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
            at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
    

Environment

  • Red Hat Single Sign-On (RH-SSO) 7.3
  • MySQL Enterprise 5.7
  • MySQL Database Replication

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content