Re: [keycloak-user] Unable to acquire JDBC Connection

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