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

    java.sql.SQLTransientConnectionException seen

    Scheduled Pinned Locked Moved
    Q&A
    postgres exception error
    2
    5
    4.2k
    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.
    • danD
      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
      • danD
        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
          • danD
            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