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

Active agent availability update is not working with Oracle

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 6.2.0beta3, 6.2 (plan)
    • Server (S)
    • None
    • Team A
    • Sprint 88 (May 2022)
    • 0.125

    Description

      Active availability update (added in ZBXNEXT-5088) is broken on oracle:

      	DBbegin_multiple_update(&sql, &sql_alloc, &sql_offset);
      
      	zbx_snprintf_alloc(&sql, &sql_alloc, &sql_offset,
      			"update host_rtdata set active_available=%i where", status);
      
      	DBadd_condition_alloc(&sql, &sql_alloc, &sql_offset, "hostid", hostids->values, hostids->values_num);
      	DBend_multiple_update(&sql, &sql_alloc, &sql_offset);
      

      When used within DBbegin_multiple_update/DBend_multiple_update the SQL queries must be terminated with ';\n'. However in this place using DBbegin_multiple_update/DBend_multiple_update for single query seems to be unnecessary and can be removed.

      Attachments

        Activity

          People

            dgoloscapov Dmitrijs Goloscapovs
            wiper Andris Zeila
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: