Re: [keycloak-user] Unable to acquire JDBC Connection
Is it this parameter in datasource?
<pool>
<max-pool-size>20</max-pool-size>
</pool>
Actually I didn't change my standalone.xml; I use the docker version of
Keycloak with an environment parameter: DB_VENDOR=mysql
Thanks
On Tue, Oct 22, 2019 at 3:46 PM Stian Thorgersen <sthorger(a)redhat.com>
wrote:
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(a)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(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>