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

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

      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.

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

              Created:
              Updated:
              Resolved: