hasura / hasura/graphql-engine

mssql connection error

Open
#9,484 4 comments 0 reactions 0 assignees View on GitHub
k/bug t/native-dbs
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information
Hasura v2.15.2

### Environment
Hasura: Azure (container)
Client: C# WASM website that calls Hasura from a GraphQL client (StrawberryShake).

### What is the current behaviour?
I'm using Hasura to request 3 SQL databases:
- A Postgres DB
- An SQL Server DB
- Another SQL Server DB, on the same server that the previous one

It works most of the time, but sometimes Hasura seems to randomly lose the connection to SQL Server. Both SQL Server databases are impacted at the same time (they are stored on the same server).

I'm having this error message:
```json
{
"errors": [
{
"extensions": {
"code": "unexpected",
"internal": {
"exception": {
"message": "[Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired",
"type": "unsuccessful_return_code"
}
},
"path": "$"
},
"message": "mssql connection error"
}
]
}
```

### Any possible solutions/workarounds you're aware of?
This problem seems to appear randomly.
I have to manually restart the container on Azure (reloading databases from Hasura doesn't work).

### Keywords
hasura, azure, sql server, mssql

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.