airbytehq / airbytehq/airbyte

[source-mssql] Syncs fail with invalid timeout string (works in 4.2.6)

未关闭
#72,928 4 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
area/connectors autoteam community connectors/source/mssql hyd-prove hyd-review needs-triage team/extensibility team/use type/bug
主要语言
Python
星标
22.1k
派生
5.3k
PR 合并指标
PR 指标待抓取

描述

### Connector Name

source-mssql

### Connector Version

4.3.3

### What step the error happened?

During the sync

### Relevant information

Effectively when using newer versions, I can't sync to certain servers. I can run a connection check just fine, but then the sync fails to start and throws one of these two forms of the same error:
```
ERROR main i.a.c.AirbyteConnectorRunnable(run):38 Failed class io.airbyte.cdk.discover.DiscoverOperation operation execution. com.microsoft.sqlserver.jdbc.SQLServerException: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```
. . . or this one (which seems to happen on subsequent attempts):
```
ERROR Failing job: 923287, reason: Could not connect with provided configuration. Error: Message: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```

Regardless it appears that the issue is the timeout value being provided being malformed. I'm not certain if this is specific to SQL server version, as I've seen failures on several different connections to various third-party SQL servers (some of which I don't know the version of).

I've had to pin my connector version to `4.2.6` due to this issue, in which case the sync completes just fine.

### Relevant log output

```shell
ERROR main i.a.c.AirbyteConnectorRunnable(run):38 Failed class io.airbyte.cdk.discover.DiscoverOperation operation execution. com.microsoft.sqlserver.jdbc.SQLServerException: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```

### Contribute

- [ ] Yes, I want to contribute

---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/11187

贡献指南

打开贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。