-
Problem report
-
Resolution: Fixed
-
Critical
-
None
-
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.