Navigation

    FusionAuth
    • Login
    • Search
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs

    java.sql.SQLTransientConnectionException seen

    Q&A
    postgres exception error
    2
    5
    925
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • dan
      dan last edited by

      We see this happening very now and then with both pgBouncer and Stolon when FusionAuth is connected to either. Any insights?

      This appears to be the problem: HikariPool-1 - Connection is not available, request timed out after 4732ms.

      Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 4732ms.
      	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
      	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
      	at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:357)
      	at com.sun.proxy.$Proxy46.selectOne(Unknown Source)
      	at org.apache.ibatis.session.SqlSessionManager.selectOne(SqlSessionManager.java:166)
      	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83)
      	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
      	at com.sun.proxy.$Proxy47.retrieve(Unknown Source)
      	at io.fusionauth.api.service.system.DefaultSystemConfigurationService.retrieve(DefaultSystemConfigurationService.java:57)
      	at io.fusionauth.app.primeframework.CORSRequestWorkflow.<init>(CORSRequestWorkflow.java:32)
      	at io.fusionauth.app.primeframework.CORSRequestWorkflow$$FastClassByGuice$$c8e3da99.newInstance(<generated>)
      	at com.google.inject.internal.DefaultConstructionProxyFactory$FastClassProxy.newInstance(DefaultConstructionProxyFactory.java:89)
      	at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:114)
      	at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:91)
      	at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:306)
      	at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:42)
      	at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:65)
      	at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:113)
      	at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:91)
      	at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:306)
      	at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:62)
      	at com.google.inject.internal.InjectorImpl$1.get(InjectorImpl.java:1050)
      	... 24 more
      Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 4732ms.
      

      --
      FusionAuth - Auth for devs, built by devs.
      https://fusionauth.io

      1 Reply Last reply Reply Quote 0
      • dan
        dan last edited by

        This may be related: https://github.com/brettwooldridge/HikariCP/issues/1042

        Perhaps changing from transaction mode to session mode in pgBouncer may help?

        --
        FusionAuth - Auth for devs, built by devs.
        https://fusionauth.io

        1 Reply Last reply Reply Quote 0
        • C
          civaxox259 last edited by dan

          when i navigate to `https://libroslara.com/ i have the same problemes

          i'm wonder if you fix the problem

          C 1 Reply Last reply Reply Quote 0
          • dan
            dan last edited by

            Can you explain a bit more @civaxox259 ?

            --
            FusionAuth - Auth for devs, built by devs.
            https://fusionauth.io

            1 Reply Last reply Reply Quote 0
            • C
              civaxox259 @civaxox259 last edited by dan

              @civaxox259
              you fix you problem on `https://libroslara.com/libros/
              becouse i donde see any problem on tha page

              1 Reply Last reply Reply Quote 0
              • First post
                Last post