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

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

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(a)gmail.com&gt; 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(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 >>>> >>>