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

Details

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

    Description

      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]
      

       

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: