HI a have a problem with run Keycloak with external mysql (Percona-XtraDB-Cluster).
Keycloak is running in Kubernetes
Dockerfile:
FROM jboss/keycloak:12.0.4
CMD [ “-b”, “0.0.0.0”, “–server-config”, “./standalone-ha.xml” ]
k8s.yml (custom options)
env:
- name: JDBC_PARAMS
value: “useSSL=false”
- name: JDBC_PARAMS
value: “connectTimeout=30000”
- name: JDBC_PARAMS
value: “enabledTLSProtocols=TLSv1.2”
- name: MYSQL_PORT
value: “3306”
- name: PROXY_ADDRESS_FORWARDING
value: “true”
- name: DB_VENDOR
value: “mysql”
some error messages from the log:
e[0me[0m11:42:39,950 INFO [org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory] (ServerService Thread Pool -- 61) Database info: {databaseUrl=jdbc:mysql://mysql-url.cz:3306/keycloak?enabledTLSProtocols=TLSv1.2, databaseUser=keycloak@10.10.10.1, databaseProduct=MySQL 5.7.25-28-57-log, databaseDriver=MySQL Connector/J mysql-connector-java-8.0.22 (Revision: d64b664fa93e81296a377de031b8123a67e6def2)}
e[0me[0m11:43:07,646 INFO [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 61) Initializing database schema. Using changelog META-INF/jpa-changelog-master.xml
e[0me[31m11:43:11,450 ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 61) Error has occurred while updating the database: liquibase.exception.DatabaseException: Percona-XtraDB-Cluster prohibits use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER [Failed SQL: INSERT INTO keycloak.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', '6413387743')]
at org.liquibase//liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
Caused by: java.sql.SQLException: Percona-XtraDB-Cluster prohibits use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at org.jboss.ironjacamar.jdbcadapters@1.4.23.Final//org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
at org.liquibase//liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
... 73 more
e[0me[31m11:43:11,547 FATAL [org.keycloak.services] (ServerService Thread Pool -- 61) Error during startup: java.lang.RuntimeException: Failed to update database