[Keycloak-upgrade] From 3.4.2 version to 18.0

[Arulaln A R]

Hi Team,

We recently upgraded our Dev environment of Keycloak from 3.4.2 version to 18.0, since the data is not huge it worked smoothly.

Now when we are trying to do the same update in our staging env, it fails with the attached error.

We followed an article "Upgrading Guide (keycloak.org)" and manually created the sql script file and ran it in our staging DB before starting the keycloak. It fails with the same error attached. 

We are trying to deploy keycloak using kubernetes with kubernetes cache stack enabled.

Any help would be appreciated!

--

Regards,

Arulaln A R

+91-8754438576

[Arulaln A R]

Hi Team,

We found that Arjuna timeout error is because of the configuration to close the connection after 5 mins by liquibase. It can be overwritten with the java environment variable "-Dquarkus.transaction-manager.default-transaction-timeout=3600". Along with this, we added two more configurations for java environment variable to enable the batch size and mention the size number "-Dkeycloak.migration.batch-enabled=true -Dkeycloak.migration.batch-size=1000".

With the above three parameters added, the upgrade of our keycloak environment from 3.4.2 to 18.0.2 succeeded. It took around 35 mins to complete it.

[djvic]

This definitely needs to be in the upgrade documentation.

Arulaln's post here was exactly what I needed to fix the issue.