java.sql.SQLTransientConnectionException when setting up a server
-
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
-
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.
-