keycloak服务器15.0.2 mysql 5.7和Java 17和jconnect 8的超时错误

Question

使用connect 8.0.27将kycloak服务器15.0.2连接到我的SQL5.7数据库时出错。

启动keycloak服务器后，我可以看到keycloak服务器在keycloak模式中创建的表。但是服务器启动并停止时会出现错误。

在配置MySQL数据源后第一次启动时，会挂起5分钟，抛出超时异常，然后停止使用以下堆栈跟踪：

liquibase.exception.UnexpectedLiquibaseException: java.sql.SQLException: IJ031070:事务无法继续: STATUS_ROLLEDBACK

at liquibase.database.jvm.JdbcConnection.getURL(JdbcConnection.java:79)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:66)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)

... 76 more

由: java.sql.SQLException: IJ031070:事务无法继续: STATUS_ROLLEDBACK引起

at org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:272)

at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:2007)

at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:2022)

at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1996)

at org.jboss.jca.adapters.jdbc.WrappedConnection.getMetaData(WrappedConnection.java:982)

at liquibase.database.jvm.JdbcConnection.getURL(JdbcConnection.java:77)

... 81 more

在随后的初创企业中，它按以下方式抛出外键错误，然后再次停止：

liquibase.exception.DatabaseException:表' keycloak.CLIENT_TEMPLATE_ATTRIBUTES‘不存在失败的SQL: ALTER keycloak.CLIENT_TEMPLATE_ATTRIBUTES拖放外键FK_CL_TEMPL_ATTR_TEMPL

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.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)

... 76 more

原因: java.sql.SQLSyntaxErrorException:表'keycloak.client_template_attributes‘不存在

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:768)

at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653)

at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)

... 81 more

Answer 1

您需要增加超时值。

选项1 in standalone.xml

<协调员-环境默认超时=“3600”统计信息启用=.

选项2其他方法是使用JVM参数-Djboss.as.management.blocking.timeout=3600