Hi everyone,
I am trying to migrate keycloak from version 13.0.1 to 17.0.1 which is configured with MSsql Database.
While migrating its works fine till version 16.0.1, and when I am upgrading to version 17.0.1 or another quarkus version I get the following error:
Appending additional Java properties to JAVA_OPTS: -Djgroups.dns.query=keycloak-headless
Changes detected in configuration. Updating the server image.
Updating the configuration and installing your custom providers, if any. Please wait.
2022-07-11 05:22:05,859 INFO [io.quarkus.deployment.QuarkusAugmentor] (main) Quarkus augmentation completed in 13693ms
Server configuration updated and persisted. Run the following command to review the configuration:
kc.sh show-config
Next time you run the server, just run:
kc.sh start --db-url=jdbc:sqlserver://database-host:1433 --db-url-database=databaseName --db-username=dbUser --db-password=******* --spi-connections-jpa-default-migration-strategy=update --spi-sticky-session-encoder-infinispan-should-attach-route=false --hostname-strict=false
2022-07-11 05:22:09,708 INFO [org.keycloak.quarkus.runtime.hostname.DefaultHostnameProvider] (main) Hostname settings: FrontEnd: , Strict HTTPS: true, Path: , Strict BackChannel: false, Admin: , Port: -1, Proxied: true
2022-07-11 05:22:10,792 WARN [org.infinispan.CONFIG] (keycloak-cache-init) ISPN000569: Unable to persist Infinispan internal caches as no global state enabled
2022-07-11 05:22:10,847 WARN [org.infinispan.PERSISTENCE] (keycloak-cache-init) ISPN000554: jboss-marshalling is deprecated and planned for removal
2022-07-11 05:22:10,864 INFO [org.infinispan.CONTAINER] (keycloak-cache-init) ISPN000556: Starting user marshaller ‘org.infinispan.jboss.marshalling.core.JBossUserMarshaller’
2022-07-11 05:22:11,094 INFO [org.infinispan.CONTAINER] (keycloak-cache-init) ISPN000128: Infinispan version: Infinispan ‘Triskaidekaphobia’ 13.0.6.Final
2022-07-11 05:22:11,205 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000078: Starting JGroups channel ISPN
2022-07-11 05:22:13,442 INFO [org.jgroups.protocols.pbcast.GMS] (keycloak-cache-init) aaa1-0-39344: no members discovered after 2015 ms: creating cluster as coordinator
2022-07-11 05:22:13,459 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000094: Received new cluster view for channel ISPN: [aaa1-0-39344|0] (1) [aaa1-0-39344]
2022-07-11 05:22:13,486 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000079: Channel ISPN local address is aaa1-0-39344, physical addresses are [19.1.17.235:7800]
2022-07-11 05:22:14,648 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:14,952 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:15,244 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:15,590 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:15,983 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:16,265 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:16,611 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:17,742 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:20,386 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:22,416 WARN [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Failed to create lock table. Maybe other transaction created in the meantime. Retrying…
2022-07-11 05:22:22,539 INFO [org.infinispan.CLUSTER] (main) ISPN000080: Disconnecting JGroups channel ISPN
2022-07-11 05:22:22,612 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode
2022-07-11 05:22:22,612 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: liquibase.exception.DatabaseException: There is already an object named ‘DATABASECHANGELOGLOCK’ in the database. [Failed SQL: (2714) CREATE TABLE DATABASECHANGELOGLOCK (ID int NOT NULL, LOCKED bit NOT NULL, LOCKGRANTED datetime2(3), LOCKEDBY nvarchar(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
2022-07-11 05:22:22,612 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: There is already an object named ‘DATABASECHANGELOGLOCK’ in the database. [Failed SQL: (2714) CREATE TABLE DATABASECHANGELOGLOCK (ID int NOT NULL, LOCKED bit NOT NULL, LOCKGRANTED datetime2(3), LOCKEDBY nvarchar(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
2022-07-11 05:22:22,612 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: There is already an object named ‘DATABASECHANGELOGLOCK’ in the database.
2022-07-11 05:22:22,612 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.