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

Can not delete hosts with lld items

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 3.0.4, 3.0.5
    • Frontend (F)
    • None
    • CentOS7 DB with partitions.

      I get error when i try delete item with lld items.
      Deleted: Trigger "Chassis _Fail H801MABC_0 0" on "ma1-gagarina28-seml".
      Deleted: Trigger "Slot_Fail H801CITD_0_0 0.0" on "ma1-gagarina28-seml".
      Deleted: Trigger "Slot_Fail VDM_0_2 0.2" on "ma1-gagarina28-seml".
      Deleted: Trigger "Slot_Fail VDM_0_3 0.3" on "ma1-gagarina28-seml".
      Deleted: Trigger "Slot_Fail H801SCUB_0_9 0.9" on "ma1-gagarina28-seml".
      Deleted: Item "hwFrameOperStatus H801MABC_0 0" on "ma1-gagarina28-seml".
      Deleted: Item "hwSlotOperStatus H801CITD_0_0 0.0" on "ma1-gagarina28-seml".
      Deleted: Item "hwSlotOperStatus VDM_0_2 0.2" on "ma1-gagarina28-seml".
      Deleted: Item "hwSlotOperStatus VDM_0_3 0.3" on "ma1-gagarina28-seml".
      Deleted: Item "hwSlotOperStatus H801SCUB_0_9 0.9" on "ma1-gagarina28-seml".
      Deleted: Trigger prototype "Slot_Fail {#SNMPVALUE} {#SNMPINDEX}" on "ma1-gagarina28-seml".
      Deleted: Trigger prototype "Chassis _Fail {#SNMPVALUE} {#SNMPINDEX}" on "ma1-gagarina28-seml".
      pg_query(): Query failed: ??????: UPDATE ??? DELETE ? ??????? "triggers" ???????? ??????????? ???????? ????? "c_trigger_discovery_2" ??????? "trigger_discovery"
      DETAIL: ?? ???? (triggerid)=(74684495) ??? ??? ???? ?????? ? ??????? "trigger_discovery". [hosts.php:654 ? CFrontendApiWrapper->delete() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHost->delete() ? CDiscoveryRule->delete() ? CItemPrototype->delete() ? CTriggerPrototype->delete() ? DB::delete() ? DBexecute() ? pg_query() in include/db.inc.php:518]
      Error in query [DELETE FROM triggers WHERE (triggerid IN ('74684495','74684496'))] [??????: UPDATE ??? DELETE ? ??????? "triggers" ???????? ??????????? ???????? ????? "c_trigger_discovery_2" ??????? "trigger_discovery"
      DETAIL: ?? ???? (triggerid)=(74684495) ??? ??? ???? ?????? ? ??????? "trigger_discovery".]
      SQL statement execution has failed "DELETE FROM triggers WHERE (triggerid IN ('74684495','74684496'))" [hosts.php:654 ? CFrontendApiWrapper->delete() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHost->delete() ? CDiscoveryRule->delete() ? CItemPrototype->delete() ? CTriggerPrototype->delete() ? DB::delete() ? DB::exception() in include/classes/db/DB.php:818]

        1. debug.txt
          130 kB
        2. SomeInfoFromDB.txt
          2 kB
        3. zbx_export_hosts.xml
          4 kB
        4. zbx_export_hosts-2.xml
          4 kB
        5. zbx_export_templates.xml
          56 kB
        6. zbx_export_templates-2.xml
          17 kB

            Unassigned Unassigned
            ulypka Artur
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: