![]() In a 1000/2000 requests you can get this errorĮztalk-service_1 | Caused by: : Unable to acquire JDBC ConnectionĮztalk-service_1 | at .nvert(StandardSQLExceptionConverter.java:47)Įztalk-service_1 | at .(SqlExceptionHelper.java:113)Įztalk-service_1 | at .(SqlExceptionHelper.java:99)Įztalk-service_1 | at .(LogicalConnectionManagedImpl.java:107)Įztalk-service_1 | at .(LogicalConnectionManagedImpl.java:134)Įztalk-service_1 | at .(StatementPreparerImpl.java:50)Įztalk-service_1 | at .internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149)Įztalk-service_1 | at .internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)Įztalk-service_1 | at .(StatementPreparerImpl.java:151)Įztalk-service_1 | at .prepareQueryStatement(Loader.java:2104)Įztalk-service_1 | at .executeQueryStatement(Loader.java:2034)Įztalk-service_1 | at .executeQueryStatement(Loader.java:2012)Įztalk-service_1 | at .doQuery(Loader.java:953)Įztalk-service_1 | at .doQueryAndInitializeNonLaz圜ollections(Loader.java:354)Įztalk-service_1 | at .doList(Loader.java:2838)Įztalk-service_1 | at .doList(Loader.java:2820)Įztalk-service_1 | at .listIgnoreQuer圜ache(Loader.java:2652)Įztalk-service_1 | at .list(Loader.java:2647)Įztalk-service_1 | at .QueryLoader.list(QueryLoader.java:506)Įztalk-service_1 | at .(QueryTranslatorImpl.java:396)Įztalk-service_1 | at .(HQLQueryPlan.java:219)Įztalk-service_1 | at .list(SessionImpl.java:1404)Įztalk-service_1 | at .AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)Įztalk-service_1 | at .AbstractProducedQuery.list(AbstractProducedQuery.java:1533)Įztalk-service_1 | Caused by: : Sorry, acquisition timeout!Įztalk-service_1 | at io.(ConnectionPool.java:244)Įztalk-service_1 | at io.(ConnectionPool.java:173)Įztalk-service_1 | at io.(DataSource.java:66)Įztalk-service_1 | at io.(QuarkusConnectionProvider.java:23)Įztalk-service_1 | at .obtainConnection(NonContextualJdbcConnectionAccess.java:38)Įztalk-service_1 | at .(LogicalConnectionManagedImpl.java:104)Įnvironment (please complete the following information):.Make many request in a short time (Bot or something else).Return the list in your jax-rs get path.Create a service class annoted Make a findAll on your panache entity in the service class.Make a JDBC connection on Mariadb or Postgres.(Describe the actual behavior clearly and concisely.) No more Unable to acquire JDBC connection □. Sometimes it happens at the 50th request sometimes at the 200th, sometimes more but it happens everytime. The statement_timeout is set to 0 on Postgres too. The idle_in_transaction_session_timeout is set to 0 on Postgres I put some configuration for timeout (extremely low because of my bug) : See below my confĪfter 1000/2000 requests, I get the error : Unable to acquire JDBC connection (Detail below on Scrrenshot section) I launched the application with one datasource (same problem on postgres and mariadb). ![]() ![]() Docker mariadb and postgres for development.Hi everyone, I followed the guide on quarkus jdbc, quarkus hibernate orm and quarkus hibernate panache. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |