[keycloak-user] Unable to acquire JDBC Connection

[Corentin Dupont]

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 at 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 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
>>
>