Repository navigation
Database Migration Timing Out #19264
|
Hi, I have an existing Keycloak V12.0.4 with a Postgres v12 DB. I've installed Keycloak V21.0.1. If I run kc.sh start-dev or kc.sh start --spi-connections-jpa-legacy-migration-strategy=manual I can see the all the postgres traffic with tcpdump. But after 5 mins it times out. No matter what I've tried. I've tried in the keycloak.conf file: db-url=jdbc:postgresql://servername/dbname?connectionTimeout=0 db-url=jdbc:postgresql://servername/dbname?connectionTimeout=900 db-url=jdbc:postgresql://servername/dbname?options=-c%20statement_timeout=9000 db-url=jdbc:postgresql://servername/dbname?socketTimeout=900 Last thing in the log it was inserting into the db: 2023-03-23 00:11:43 UTC:10.120.100.4(33760):root@quickauth:[6590]:LOG: execute S_45: insert into CLIENT_SCOPE (DESCRIPTION, NAME, PROTOCOL, REALM_ID, ID) values ($1, $2, $3, $4, $5) Where can I change the timeout? Thanks. Mike |
Replies: 1 comment 1 reply
|
I even changed the statement timeout on server. |
|
It was a server side issue. quarkus.transaction-manager.default-transaction-timeout = 900s fix it. Migration updated completed. |
I even changed the statement timeout on server.