[keycloak-user] Unable to acquire JDBC Connection

[Corentin Dupont]

Thanks a lot. What's the trade-off to have a big max-pool-size? More memory
usage?

On Wed, Oct 23, 2019 at 7:42 AM Stian Thorgersen <sthorger at redhat.com>
wrote:

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