Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-7659

Oracle by Zabbix agent 2 problem with parsing JSON data

    XMLWordPrintable

Details

    • New Feature Request
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 6.0.3
    • None
    • Templates (T)
    • None

    Description

      Ошибка:

      В items:  Oracle: Session count, Oracle: Sessions concurrency, Oracle: Sessions lock rate

      Preprocessing failed for:

      {"active_background":41,"active_user":5,"concurrency_rate":0,"inactive_user":69,"lock_rate":.8695... 1. Failed: cannot extract value from json by path "$.total": cannot parse as a valid JSON object: invalid JSON object value starting character at: '.8695652173913043478260869565217391304348,"long_time_locked":1,"total":115}

      '

      Место возникновения в SQL запросе:
      SELECT 'lock_rate' , (CNT_BLOCK / 116) * 100 pct

      Причина возникновения ошибки:
      В случае, если (CNT_BLOCK * 100) < CNT_ALL, то JSON_OBJECTAGG преоразует дробное значение < 1 в "lock_rate":.8695652173913043478260869565217391304348 отбрасывая ноль. Что, по всей видимости, при парсинге в коде приводит к ошибке.

      Attachments

        Activity

          People

            vjaceslavs Vjaceslavs Bogdanovs
            e.pyrkin Evgeny
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: