airbytehq / airbytehq/airbyte

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

Aberta
#72,928 4 comentários 0 reações 0 responsáveis Ver no GitHub
area/connectors autoteam community connectors/source/mssql hyd-prove hyd-review needs-triage team/extensibility team/use type/bug
Linguagem predominante
Python
Estrelas
22.1k
Forks
5.4k
Merge médio
5h
PRs com merge (30d)
671

Descrição

### 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

Guia de contribuição

Abrir o guia de contribuição

Avaliação

Esta issue ainda não foi avaliada.

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.