[keycloak-user] Unable to acquire JDBC Connection

[Stian Thorgersen]

Depends on your load, but I believe we use 100 when we're benchmarking.

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

> What is a good value for max-pool-size with MySQL?
>
> On Tue, Oct 22, 2019 at 4:14 PM Corentin Dupont <corentin.dupont at gmail.com>
> wrote:
>
>> 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
>>>>
>>>