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

java.sql.SQLTransientConnectionException when setting up a server

Scheduled Pinned Locked Moved
Q&A
0
2
4.0k
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.
  • D
    dan
    last edited by 21 Jan 2021, 17:13

    Hi,

    I am setting up a server with fusion auth version 1.23
    I am getting below error when update user with node client,

    ### Error querying database.  Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 2006ms.
    ### The error may exist in io/fusionauth/api/domain/UserMapper.xml
    ### The error may involve io.fusionauth.api.domain.UserMapper.retrieveById
    ### The error occurred while executing a query
    ### Cause: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 2006ms.
            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
            at jdk.internal.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
            at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.base/java.lang.reflect.Method.invoke(Method.java:564)
            at
    

    is it an issue with the configuration or something wrong with my end

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

    1 Reply Last reply Reply Quote 0
    • D
      dan
      last edited by 21 Jan 2021, 17:13

      Sounds like the database is struggling.

      Ensure your db is available, and sized reasonably.

      If you are using a free tier of a managed database service ensure you have not exceed your IOPs.

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

      1 Reply Last reply Reply Quote 0
      • M mark.shapiro referenced this topic on 20 Oct 2023, 20:49
      2 out of 2
      • First post
        2/2
        Last post