Microsoft SQL Server (MSSQL) v2.0.1 - Connection errors

[MixalisMixail]

Greetings, everyone! Newcomer here.
I have successfully set up Airbyte OSS v0.50.30 (Docker) on Linux Ubuntu 22.04. I have also successfully configured a data source (MSSQL remote) and a destination source (PostgreSQL) running on the host machine. Furthermore, I've successfully established a connection and initiated data transfer. However, after a few runs, I encountered connection issues with the data source (MSSQL) and received the following error: "Configuration check failed. Message: HikariPool-1 - Connection is not available, request timed out after 60001ms."

Please find below the detail logs as taken from Airbyte:
Learn more
Internal message: io.airbyte.commons.exceptions.ConnectionErrorException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60001ms.
Failure origin: source
Failure type: config_error

Logs
2023-10-11 07:33:44 INFO i.a.w.t.TemporalAttemptExecution(get):124 - Docker volume job log path: /tmp/workspace/c709e0e1-8aba-4919-943b-a982d3c93f6c/0/logs.log
2023-10-11 07:33:44 INFO i.a.w.t.TemporalAttemptExecution(get):129 - Executing worker wrapper. Airbyte version: 0.50.30
2023-10-11 07:33:44 INFO i.a.a.c.AirbyteApiClient(retryWithJitterThrows):290 - Attempt 0 to save workflow id for cancellation
2023-10-11 07:33:44 INFO i.a.c.EnvConfigs(getEnvOrDefault):1228 - Using default value for environment variable SIDECAR_KUBE_CPU_LIMIT: '2.0'
2023-10-11 07:33:44 INFO i.a.c.EnvConfigs(getEnvOrDefault):1228 - Using default value for environment variable SOCAT_KUBE_CPU_LIMIT: '2.0'
2023-10-11 07:33:44 INFO i.a.c.i.LineGobbler(voidCall):149 -
2023-10-11 07:33:44 INFO i.a.c.EnvConfigs(getEnvOrDefault):1228 - Using default value for environment variable SIDECAR_KUBE_CPU_REQUEST: '0.1'
2023-10-11 07:33:44 INFO i.a.c.EnvConfigs(getEnvOrDefault):1228 - Using default value for environment variable SOCAT_KUBE_CPU_REQUEST: '0.1'
2023-10-11 07:33:44 INFO i.a.c.EnvConfigs(getEnvOrDefault):1228 - Using default value for environment variable LAUNCHDARKLY_KEY: ''
2023-10-11 07:33:44 INFO i.a.c.i.LineGobbler(voidCall):149 - ----- START CHECK -----
2023-10-11 07:33:44 INFO i.a.c.i.LineGobbler(voidCall):149 -
2023-10-11 07:33:44 INFO i.a.c.i.LineGobbler(voidCall):149 - Checking if airbyte/source-mssql:2.0.1 exists...
2023-10-11 07:33:44 INFO i.a.c.i.LineGobbler(voidCall):149 - airbyte/source-mssql:2.0.1 was found locally.
2023-10-11 07:33:44 INFO i.a.w.p.DockerProcessFactory(create):143 - Creating docker container = source-mssql-check-c709e0e1-8aba-4919-943b-a982d3c93f6c-0-ucenl with resources io.airbyte.config.ResourceRequirements@44a5d766[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=,additionalProperties={}] and allowedHosts null
2023-10-11 07:33:44 INFO i.a.w.p.DockerProcessFactory(create):196 - Preparing command: docker run --rm --init -i -w /data/c709e0e1-8aba-4919-943b-a982d3c93f6c/0 --log-driver none --name source-mssql-check-c709e0e1-8aba-4919-943b-a982d3c93f6c-0-ucenl --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_CONNECTOR_IMAGE=airbyte/source-mssql:2.0.1 -e AUTO_DETECT_SCHEMA=true -e LAUNCHDARKLY_KEY= -e SOCAT_KUBE_CPU_REQUEST=0.1 -e SOCAT_KUBE_CPU_LIMIT=2.0 -e USE_STREAM_CAPABLE_STATE=true -e FIELD_SELECTION_WORKSPACES= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e APPLY_FIELD_SELECTION=false -e WORKER_JOB_ATTEMPT=0 -e OTEL_COLLECTOR_ENDPOINT=http://host.docker.internal:4317/ -e FEATURE_FLAG_CLIENT=config -e AIRBYTE_VERSION=0.50.30 -e WORKER_JOB_ID=c709e0e1-8aba-4919-943b-a982d3c93f6c airbyte/source-mssql:2.0.1 check --config source_config.json
2023-10-11 07:33:44 INFO i.a.w.i.VersionedAirbyteStreamFactory(create):177 - Reading messages from protocol version 0.2.0
2023-10-11 07:33:45 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):312 - INFO i.a.i.s.m.MssqlSource(main):569 starting source: class io.airbyte.integrations.source.mssql.MssqlSource
2023-10-11 07:33:45 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):312 - INFO i.a.i.b.IntegrationCliParser(parseOptions):126 integration args: {check=null, config=source_config.json}
2023-10-11 07:33:45 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):312 - INFO i.a.i.b.IntegrationRunner(runInternal):130 Running integration: io.airbyte.integrations.base.ssh.SshWrappedSource
2023-10-11 07:33:45 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):312 - INFO i.a.i.b.IntegrationRunner(runInternal):131 Command: CHECK
2023-10-11 07:33:45 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):312 - INFO i.a.i.b.IntegrationRunner(runInternal):132 Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2023-10-11 07:33:45 WARN i.a.w.i.VersionedAirbyteStreamFactory(internalLog):309 - WARN c.n.s.JsonMetaSchema(newValidator):278 Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword

Stacktrace
io.airbyte.commons.exceptions.ConnectionErrorException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60001ms.
at io.airbyte.db.jdbc.DefaultJdbcDatabase.getMetaData(DefaultJdbcDatabase.java:84)
at io.airbyte.integrations.source.jdbc.AbstractJdbcSource.createDatabase(AbstractJdbcSource.java:446)
at io.airbyte.integrations.source.jdbc.AbstractJdbcSource.createDatabase(AbstractJdbcSource.java:88)
at io.airbyte.integrations.source.relationaldb.AbstractDbSource.check(AbstractDbSource.java:85)
at io.airbyte.integrations.base.ssh.SshTunnel.sshWrap(SshTunnel.java:270)
at io.airbyte.integrations.base.ssh.SshWrappedSource.check(SshWrappedSource.java:54)
at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:148)
at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:123)
at io.airbyte.integrations.source.mssql.MssqlSource.main(MssqlSource.java:570)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60001ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
at io.airbyte.db.jdbc.DefaultJdbcDatabase.getMetaData(DefaultJdbcDatabase.java:78)
... 8 more

[marcosmarxm]

Are you trying to connect to a local docker MSSQL server?