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

saving host with "Template Virt VMware vCenter" produces sql errors and can not be upadated

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 2.1.4
    • Fix Version/s: 2.1.6, 2.2.0
    • Component/s: Frontend (F), Templates (T)
    • Labels:
      None
    • Environment:
      SUSE Linux Enterprise Server 11 (x86_64)
      VERSION = 11
      PATCHLEVEL = 1

      Server version: Apache/2.2.10 (Linux/SUSE)
      Server built: May 5 2010 14:32:30

      postgres (PostgreSQL) 8.3.9

      Description

      Added ESXi host to host list and trying to assign template
      "Template Virt VMware vCenter"
      After "Save" button it stays on the same screen and shows error
      ERROR: Cannot update host

          Created: Application "Log" on "VM".
          Created: Application "Clusters" on "VM".
          Created: Discovery rule "Discover vCenter VMs" on "VM".
          Created: Discovery rule "Discover vCenter hypervisors" on "VM".
          Created: Discovery rule "Discover vCenter clusters" on "VM".
          Created: Item prototype "Status of "$2" cluster" on "VM".
          pg_query(): Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE "" ^ [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT hg.group_prototypeid,hg.hostid FROM group_prototype hg WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE ""] [ERROR: zero-length delimited identifier at or near """" LINE 1: ...WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE "" ^]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT t.* FROM group_prototype t WHERE 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid IN ('10090','10092')] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT i.itemid,i.hostid FROM items i,hosts h WHERE i.flags=1 AND i.itemid IN ('23542','23554') AND h.hostid=i.hostid AND h.status=3] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND h.hostid='10093' AND 1=0 AND h.hostid=ht.hostid AND h.status IN (0,1,3) AND h.flags='0'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.hostid,i.name,i.description,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.trapper_hosts,i.units,i.multiplier,i.delta,i.snmpv3_contextname,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authprotocol,i.snmpv3_authpassphrase,i.snmpv3_privprotocol,i.snmpv3_privpassphrase,i.formula,i.logtimefmt,i.valuemapid,i.delay_flex,i.params,i.ipmi_sensor,i.data_type,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.filter,i.port,i.inventory_link,i.lifetime FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='10088' AND i.flags='0'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT ht.httptestid,ht.name,ht.applicationid,ht.delay,ht.status,ht.variables,ht.agent,ht.authentication,ht.http_user,ht.http_password,ht.hostid,ht.templateid FROM httptest ht WHERE ht.hostid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT hs.httpstepid,hs.httptestid,hs.name,hs.no,hs.url,hs.timeout,hs.posts,hs.variables,hs.required,hs.status_codes FROM httpstep hs WHERE 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT ht.templateid,ht.hostid FROM hosts_templates ht WHERE 1=0 AND ht.hostid='10093'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT i.hostid,t.* FROM triggers t,functions f,items i WHERE i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT i.hostid,t.* FROM triggers t,functions f,items i WHERE t.flags=2 AND i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10093' AND ht.templateid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT i.hostid,g.* FROM graphs g,graphs_items gi,items i WHERE g.flags=2 AND i.hostid='10088' AND gi.graphid=g.graphid AND i.itemid=gi.itemid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10093' AND ht.templateid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT i.hostid,g.* FROM graphs g,graphs_items gi,items i WHERE i.hostid='10088' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411]
          Error in query [SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622]
          pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623]
          pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? DBexecute() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:547]
          Error in query [DELETE FROM host_inventory WHERE hostid='10093'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          Cannot delete inventory.
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              joooans Janis Perkons
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: