Sometimes one of our SQL Server Sources shows the ...
# ask-ai
m
Sometimes one of our SQL Server Sources shows the following Error Message: "Failure in source: Message: HikariPool-1 - Connection is not available, request timed out after 60004ms (total=0, active=0, idle=0, waiting=0)" What could this cause?
u
The error message "HikariPool-1 - Connection is not available, request timed out after 60004ms" indicates that Airbyte wasn't able to establish a connection to your SQL Server source within the specified timeout period (60004 milliseconds or 60.004 seconds in this case). This could be due to a variety of reasons such as: 1. Network issues: There might be connectivity problems between the Airbyte instance and the SQL Server. This could be due to firewall settings, network congestion, or other network-related issues. 2. Server issues: The SQL Server might be down or not responding. It could also be that the server is too busy to handle the connection request. 3. Configuration issues: The connection settings provided to Airbyte might be incorrect. This includes the server address, port, username, password, and other configuration details. 4. Whitelisting issues: If your SQL Server only allows connections from certain IP addresses, you need to ensure that the IP address of your Airbyte instance is whitelisted. To troubleshoot this issue, you can check your network and server status, verify your connection settings, and ensure that the necessary IP addresses are whitelisted. If you're using HikariCP with your SQL server, you might also want to check the default connection validation (
spring.datasource.hikari.validationTimeout
) and consider setting it to a higher number if possible [[source](https://discuss.airbyte.io/t/1839)]. If the issue persists, you might want to consider reaching out to the Airbyte community or support for further assistance.