3
社区成员
发帖
与我相关
我的任务
分享2025-04-18 11:07:07,204 ERROR [liquibase.changelog.ChangeSet] (main) ChangeSet META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::sthorger@redhat.com encountered an exception.
2025-04-18 11:07:07,223 INFO [org.infinispan.CLUSTER] (main) ISPN000080: Disconnecting JGroups channel `ISPN`
2025-04-18 11:07:07,257 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (development) mode
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to update database
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::sthorger@redhat.com:
Reason: liquibase.exception.DatabaseException: Table 'uiac_dev.APPLICATION_DEFAULT_ROLES' already exists [Failed SQL: (1050) CREATE TABLE uiac_dev.APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL)]
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: liquibase.exception.MigrationFailedException: Migration failed for changeset META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::sthorger@redhat.com:
Reason: liquibase.exception.DatabaseException: Table 'uiac_dev.APPLICATION_DEFAULT_ROLES' already exists [Failed SQL: (1050) CREATE TABLE uiac_dev.APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL)]
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Migration failed for changeset META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::sthorger@redhat.com:
Reason: liquibase.exception.DatabaseException: Table 'uiac_dev.APPLICATION_DEFAULT_ROLES' already exists [Failed SQL: (1050) CREATE TABLE uiac_dev.APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL)]
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Table 'uiac_dev.APPLICATION_DEFAULT_ROLES' already exists [Failed SQL: (1050) CREATE TABLE uiac_dev.APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL)]
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Table 'uiac_dev.APPLICATION_DEFAULT_ROLES' already exists
2025-04-18 11:07:07,258 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) For more details run the same command passing the '--verbose' option. Also you can use '--help' to see the details about the usage of the particular command.
没太注意,很抱歉,不知道你解决了没有。从日志看起来是keycloak启动时候需要用liquibase按照jpa-changelog-1.0.0.Final.xml(不同xml之间有版本迭代的关系,表示数据库表字段、索引等变更) 等文件记录的字段初始化数据库。
比如同一数据库不同版本的关键字不一样,或者类型不兼容,容易导致建表错误,需要手动修改。这里应该就是这个问题:
CREATE TABLE uiac_dev.APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL)]