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