dasniko/upgrade_keycloak_database_settings.md

Created May 10, 2023 05:06

Star (4) You must be signed in to star a gist
Fork (3) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dasniko/f074aeab81eb941cc3b2caaf96f4ca47.js"></script>
Save dasniko/f074aeab81eb941cc3b2caaf96f4ca47 to your computer and use it in GitHub Desktop.

Download ZIP

Upgrade Keycloak Database #settings

Raw

upgrade_keycloak_database_settings.md

Because of Arjuna timeout / closing the connection after 5 mins, setting following additional JAVA_OPTS might help:

-Dquarkus.transaction-manager.default-transaction-timeout=3600
-Dkeycloak.migration.batch-enabled=true
-Dkeycloak.migration.batch-size=1000

andrelramos commented Feb 26, 2025

I also added the below instructions to ensure only one thread running migration and avoid problems with race condition and infinispan (see the issue keycloak/keycloak#34267 for more details)

-Dkeycloak.cache=infinispan
-Dkeycloak.cache.persistence.enabled=false
-Dquarkus.thread-pool.core-threads=1
-Dquarkus.thread-pool.max-threads=1