hasura / hasura/graphql-engine
mssql connection error
- 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
Assessment
This issue has not been assessed yet.