[keycloak-user] Unable to acquire JDBC Connection

[Stian Thorgersen]

DId you increase the number of connections to the DB? If I don't remember
wrongly it's only max 10 connections or something by default, which isn't
going to cope with a lot of load.

On Tue, 22 Oct 2019 at 12:52, Corentin Dupont <corentin.dupont at gmail.com>
wrote:

> Hi guys,
> I get this error:
>
> [0m [31m10:36:26,890 ERROR
> [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-5447)
> javax.resource.ResourceException: IJ000453: Unable to get managed
> connection for java:jboss/datasources/KeycloakDS
> Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire
> JDBC Connection
> Caused by: javax.resource.ResourceException: IJ000655: No managed
> connections available within configured blocking timeout (30000 [ms])
>
> I use Keycloak 4.4.0-Final and MySQL.
> I saw this: https://issues.jboss.org/browse/KEYCLOAK-3539
> But it seems to be closed already.
>
> My application is very permission-intensive: on each API request (100 per
> second), I request Keycloak permission. That might be wrong design, maybe I
> should cache the permissions locally?
>
> Best,
> Corentin
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>