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

Actions operations haven't been working since upgrade from 5.2 to 5.4

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 5.4.4rc1, 6.0.0alpha1, 6.0 (plan)
    • 5.4.3
    • Server (S)
    • None
    • Oracle 19.3
    • Team A
    • Sprint 79 (Aug 2021)
    • 1

      After automatical upgrade from 5.2 to 5.4.3 with Oracle DB as backend usage and converting remote commands to global scripts for actions no one action, related with script execution haven't working

      No errors in frontend, no new records into actions log

      escalations have creating, operations as well

       

       

      Log info with debug log level for escalator processes

       

      303668:20210811:154714.326 [Z3005] query failed: [-1] ORA-00932: inconsistent datatypes: expected - got NCLOB [select distinct h.hostid,h.proxy_hostid,h.host,s.type,s.scriptid,s.execute_on,s.port,s.authtype,s.username,s.password,s.publickey,s.privatekey,s.command,s.groupid,s.scope,s.timeout,s.name,h.tls_connect,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk from opcommand o,opcommand_hst oh,hosts h,scripts s where o.operationid=oh.operationid and o.scriptid=s.scriptid and oh.hostid=h.hostid and o.operationid=110 and h.status=0 union select distinct 0,0,null,s.type,s.scriptid,s.execute_on,s.port,s.authtype,s.username,s.password,s.publickey,s.privatekey,s.command,s.groupid,s.scope,s.timeout,s.name,1,0,2,null,null,null,null,null,null from opcommand o,opcommand_hst oh,scripts s where o.operationid=oh.operationid and o.scriptid=s.scriptid and o.operationid=110 and oh.hostid is null]
      

       

            wiper Andris Zeila
            igorbach Igor Gorbach
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: