Michal Formulanet
05/29/2024, 6:41 PMkapa.ai
05/29/2024, 6:41 PMairbyte/source-mssql:4.0.24
image. This issue is similar to other issues reported where Airbyte fails to find and pull the required Docker images for connectors. ### Steps to Troubleshoot and Resolve 1. Verify Image Availability: Ensure that the airbyte/source-mssql:4.0.24
image is available in the Docker registry. You can do this by manually trying to pull the image using the following command: shell docker pull airbyte/source-mssql:4.0.24
If the image is not available, you might need to check if there is a typo in the image name or tag, or if the image has been removed or renamed. 2. Check Network Connectivity: Ensure that the machine running Airbyte has internet access and can reach the Docker registry. Network issues can sometimes prevent Docker from pulling images. 3. Update Airbyte Version: Sometimes, updating to the latest version of Airbyte can resolve issues related to image pulling. You are currently using Airbyte version 0.60.1
. Check if there is a newer version available and update if necessary. 4. Logs and Error Messages: Review the logs for any additional error messages that might provide more context. The relevant log output you provided shows: shell 2024-05-29 15:29:40 [46mplatform[0m > airbyte/source-mssql:4.0.24 not found locally. Attempting to pull the image... 2024-05-29 15:29:40 [46mplatform[0m > Image does not exist. 2024-05-29 15:29:40 [46mplatform[0m > Unexpected error while checking connection: io.airbyte.workers.exception.WorkerException: Could not find image: airbyte/source-mssql:4.0.24
### Similar Issues for Reference - [Issue 36732](https://github.com/airbytehq/airbyte/issues/36732): Similar problem with the airbyte/source-sftp:0.2.2
image. - [Issue 30575](https://github.com/airbytehq/airbyte/issues/30575): Similar problem with the airbyte/destination-postgres:0.4.0
image. - [Issue 35704](https://github.com/airbytehq/airbyte/issues/35704): Similar problem with the airbyte/source-db2:0.2.2
image. These issues indicate that the problem might be related to the availability of the image in the Docker registry or network connectivity issues. If the problem persists, you might want to raise a new issue on the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte/issues) with detailed logs and steps to reproduce the issue. For more detailed troubleshooting, you can refer to the [Airbyte documentation](https://docs.airbyte.com/). If you need further assistance, feel free to ask!Michal Formulanet
05/29/2024, 9:35 PMkapa.ai
05/29/2024, 9:36 PMMichal Formulanet
05/29/2024, 11:15 PMkapa.ai
05/29/2024, 11:15 PMkapa.ai
05/29/2024, 11:15 PMHikariPool-1 - Connection is not available, request timed out after 60005ms (total=0, active=0, idle=0, waiting=0)
indicates that Airbyte is unable to establish a connection to the database within the specified timeout period. This can be due to several reasons, such as incorrect database configuration, network issues, or resource limitations. Here are some steps to troubleshoot and resolve this issue: 1. Check Database Configuration: - Ensure that the database credentials (username, password, host, port) are correct. - Verify that the database is running and accessible from the machine where Airbyte is running. 2. Network Issues: - Ensure that there are no network issues preventing Airbyte from reaching the database. This includes checking firewall settings and network connectivity. 3. Resource Limitations: - Ensure that the database has enough resources (CPU, memory, connections) to handle the incoming connection requests from Airbyte. 4. Increase Connection Timeout: - If the database is under heavy load, you might need to increase the connection timeout settings in Airbyte to allow more time for the connection to be established. 5. Relevant Logs: - Review the relevant logs for more detailed error messages. For example, the logs might show a java.net.ConnectException: Connection refused
error, which indicates that the database server is not accepting connections. Here are some relevant excerpts from the knowledge sources that might help: - Comment by MEMBER: > This means Airbyte wasn't able to connect to the database. Please make sure your instance has the proper configuration. [Source](https://github.com/airbytehq/airbyte/issues/33821) - Original Post Part 1: > Caused by: java.net.ConnectException: Connection refused > at java.base/sun.nio.ch.Net.pollConnect(Native Method) > at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) > at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549) > at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) > at java.base/java.net.Socket.connect(Socket.java:633) [Source](https://github.com/airbytehq/airbyte/issues/33821) - Original Post Part 2: > 2023-12-28 040826 platform > Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@11908bb9[status=failed,message=Could not connect with provided configuration. > java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60001ms.,additionalProperties={}] [Source](https://github.com/airbytehq/airbyte/issues/33821) By following these steps and reviewing the relevant logs, you should be able to identify and resolve the issue causing the connection timeout. If the problem persists, consider reaching out to the Airbyte community or support for further assistance.Michal Formulanet
05/30/2024, 8:53 PMkapa.ai
05/30/2024, 8:53 PMkapa.ai
05/30/2024, 8:53 PMMichal Formulanet
05/30/2024, 8:59 PMkapa.ai
05/30/2024, 8:59 PMkapa.ai
05/30/2024, 8:59 PMMichal Formulanet
05/30/2024, 8:59 PMkapa.ai
05/30/2024, 8:59 PMkapa.ai
05/30/2024, 9:00 PMHikariPool-1 - Connection is not available, request timed out after 60005ms (total=0, active=0, idle=0, waiting=0)
indicates that Airbyte is unable to establish a connection to the database within the specified timeout period. This can be due to several reasons, such as incorrect database configuration, network issues, or resource limitations. Here are some steps to troubleshoot and resolve this issue: 1. Check Database Configuration: - Ensure that the database credentials (username, password, host, port) are correct. - Verify that the database is running and accessible from the machine where Airbyte is running. 2. Network Issues: - Ensure that there are no network issues preventing Airbyte from reaching the database. This includes checking firewall settings and network connectivity. 3. Resource Limitations: - Ensure that the database has enough resources (CPU, memory, connections) to handle the incoming connection requests from Airbyte. 4. Increase Connection Timeout: - If the database is under heavy load, you might need to increase the connection timeout settings in Airbyte to allow more time for the connection to be established. 5. Relevant Logs: - Review the relevant logs for more detailed error messages. For example, the logs might show a java.net.ConnectException: Connection refused
error, which indicates that the database server is not accepting connections. Here are some relevant excerpts from the knowledge sources that might help: - Comment by MEMBER: > This means Airbyte wasn't able to connect to the database. Please make sure your instance has the proper configuration. [Source](https://github.com/airbytehq/airbyte/issues/33821) - Original Post Part 1: > Caused by: java.net.ConnectException: Connection refused > at java.base/sun.nio.ch.Net.pollConnect(Native Method) > at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) > at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549) > at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) > at java.base/java.net.Socket.connect(Socket.java:633) [Source](https://github.com/airbytehq/airbyte/issues/33821) - Original Post Part 2: > 2023-12-28 040826 platform > Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@11908bb9[status=failed,message=Could not connect with provided configuration. > java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60001ms.,additionalProperties={{}}] [Source](https://github.com/airbytehq/airbyte/issues/33821) By following these steps and reviewing the relevant logs, you should be able to identify and resolve the issue causing the connection timeout. If the problem persists, consider reaching out to the Airbyte community or support for further assistance.