-
Problem report
-
Resolution: Fixed
-
Major
-
6.0.22, 6.4.7, 7.0.0alpha6
-
None
-
1
Steps to reproduce:
- In place by default from time to time
- Monitored via ODBC SQL gets timeouts restored in the next 30-60 seconds
- Most probably increasing the timeout value will help to get rid of this issue
- Maybe additional improvements like ability to provide frequent queries might be helpful too.
Result:
600701:20231009:045104.498 item "SQL1:mssql.db.log_flush_waits_sec.rate["SomeDatabase"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[HYT00][0][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]|[08001][258][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Timeout error [258]. ]|[08001][258][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in prelogin response]
Expected:
Increase default SQL timeout parameters:
- Connection timeout (15 seconds by default)
- Query or command timeout (30 seconds by default)
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/timeout-expired-error