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

Unable to add dependencies within Template

    XMLWordPrintable

Details

    • Patch request
    • Status: Closed
    • Trivial
    • Resolution: Incomplete
    • 6.0.7
    • None
    • Frontend (F)
    • None

    Description

      Steps to reproduce:

      1. Open "Linux by Zabbix agent active"
      2. Create new trigger "Version of Zabbix agent is outdated" which checks "last(/Linux by Zabbix agent active/agent.version)<>"{$MAINSTREAM_AGENT_VERSION}""
      3. Select depdendencies tab
      4. Add depend on "Zabbix agent is not available" trigger from same template
      5. Click "Update" template
      6. Got error "Cannot update trigger"

      Result:

      Undefined offset: 10443 [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() in include/classes/api/services/CTriggerGeneral.php:3091]
      Undefined offset: 10450 [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() in include/classes/api/services/CTriggerGeneral.php:3091]
      pg_query(): Query failed: ERROR: invalid input syntax for type bigint: ""
      LINE 1: ...own FROM trigger_depends WHERE triggerid_down IN ('',26831,2...
      ^ [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → CTriggerGeneral::checkCircularDependencies() → DBselect() → pg_query() in include/db.inc.php:254]
      Error in query [SELECT triggerdepid,triggerid_up,triggerid_down FROM trigger_depends WHERE triggerid_down IN ('',26831,26832,26833,26834,26835,26836,26837,26838,26839,26840,26841,26843,26844,31056,31097,31138,31308,31331,31354,31377,31600,31623,31646,31669)] [ERROR: invalid input syntax for type bigint: ""
      LINE 1: ...own FROM trigger_depends WHERE triggerid_down IN ('',26831,2...
      ^]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → DB::insertBatch() → DB::addIds() → DB::reserveIds() → DBselect() → pg_query() in include/db.inc.php:254]
      Error in query [SELECT nextid FROM ids WHERE table_name='trigger_depends' AND field_name='triggerdepid' FOR UPDATE] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → DB::insertBatch() → DB::addIds() → DB::reserveIds() → DBexecute() → pg_query() in include/db.inc.php:373]
      Error in query [SELECT nextid FROM ids WHERE table_name='trigger_depends' AND field_name='triggerdepid' FOR UPDATE] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      Your database is not working properly. Please wait a few minutes and try to repeat this action. If the problem still persists, please contact system administrator. The problem might be caused by long running transaction or row level lock accomplished by your database management system.
      

      Expected:

      Dependencies should be created and saved.{}

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            xocolate Arthur Ivanov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: