I’m playing around with Keycloak.X (Preview) on my local machine using postgresql (13) as database.
Starting and running the server seems to be quite simple but when I log in to the admin console and click around a little bit, e.g. quickly navigating between “Clients” and “Roles” the number of database connections increases quickly. Eventually it hits the DB server limit (around 100 according the the postgresql server settings) and then errors popup in keycloak.
This is a screenshot from pgadmin:
It seems to release idle connections sporadically/randomly. Eventually it does not prevent that the DB server connection limit is reached which results in errors.
I also tried to limit the number of max connections using --db.pool.max-size and then -Dquarkus.datasource.jdbc.max-size but both do not seem to have any effect.
Any idea what I’m doing wrong?