Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23520

MSSQL ODBC monitoring - SQL Timeout error [258], Login timeout expired, Unable to complete login process due to delay in prelogin response

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 6.0.22, 6.4.7, 7.0.0alpha6
    • Templates (T)
    • None

      Steps to reproduce:

      1. In place by default from time to time
      2. Monitored via ODBC SQL gets timeouts restored in the next 30-60 seconds
      3. Most probably increasing the timeout value will help to get rid of this issue
      4. 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:

            zit Zabbix Integration Team
            anslu Łukasz Chojnacki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: