[ZBX-6973] saving host with "Template Virt VMware vCenter" produces sql errors and can not be upadated Created: 2013 Sep 10  Updated: 2017 May 30  Resolved: 2013 Sep 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Templates (T)
Affects Version/s: 2.1.4
Fix Version/s: 2.1.6, 2.2.0

Type: Incident report Priority: Trivial
Reporter: Janis Perkons Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
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.


 Comments   
Comment by Janis Perkons [ 2013 Sep 10 ]

Template Virt VMware vCenter Guest - can be assigned and saved
Template Virt VMware vCenter Hypervisor - can be assigned and saved
Template Virt VMware vSphere Guest- can be assigned and saved

Template Virt VMware vSphere - SQL errors

Comment by Vitalij Romanovskij (Inactive) [ 2013 Sep 18 ]

fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-6973

Comment by Pavels Jelisejevs (Inactive) [ 2013 Sep 19 ]

TESTED.

Comment by Vitalij Romanovskij (Inactive) [ 2013 Sep 20 ]

fixed in pre-2.1.6 (trunk) r38667

Generated at Fri Apr 26 13:38:53 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.