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

Oracle db returns an error 'ORA-00900: invalid SQL statement' when trying to use discovery functionality

XMLWordPrintable

    • Sprint candidates

      Precondition:

      Steps to reproduce:

      • Create discovery rule with HTTP check for IP range 192.168.3.1-254 and update interval 10s
      • Check zabbix server log

      Result: Nothing discovered. Server return a lot of errors from oracle e.g.

      118026:20250204:143028.405 In zbx_discovery_update_service_down_server() dhostid:1 dserviceids:1 now:1738672223
118026:20250204:143028.405 query [txnlev:1] [ dservices set status=1,lastup=0,lastdown=1738672223 where (status=0 or lastup<>0) and dhostid=1 and not dserviceid=1]
118026:20250204:143028.407 [Z3008] query failed due to primary key constraint: [-1] ORA-00900: invalid SQL statement
118026:20250204:143028.407 query [ dservices set status=1,lastup=0,lastdown=1738672223 where (status=0 or lastup<>0) and dhostid=1 and not dserviceid=1] failed, setting transaction as failed
118026:20250204:143028.407 End of zbx_discovery_update_service_down_server()

      Expected: Discovery should work correctly without sql query errors.

        1. discovery.patch
          0.8 kB

            asestakovs Aleksejs Sestakovs
            kseve Kirils Seve
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: